Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 My database on my server, is this possible???
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

FIRLAMA
Starting Member

29 Posts

Posted - 12 February 2001 :  13:04:45  Show Profile
well, my question is this..I got today a working snitz forum on a server which isnt mine! Is it possible to leave my ASP pages on his server (does support asp) and put the database on my server (dont support asp)..Some of you're asking why?? well, i'll get enough members with their private password..and ofcourse the admin password

this is my config.asp :

strDBType = "mysql"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("forums_2000/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path

ofcourse i need to change something but what??

( ftp = members.home.nl
login = turksnl
password = ***
and db = snitz_forums_2000.mdb )

so anyone know how my database should look like?????

gor
Retired Admin

Netherlands
5511 Posts

Posted - 12 February 2001 :  14:23:32  Show Profile  Visit gor's Homepage
First:
If you are using Access (97/2000) the strDBType should be set to 'access' not to 'mysql'.
You'll get error-messages using it this way.

As far as I know you can't use an Access database that is on a different server.
You can do this with MS Sql Server (with IP enabled as protocol) or MySql (has IP enabled as protocol by default). In that case you would replace the SERVER_NAME of the database-server with the IP number of the server, i.e. when using MySql on a different server:

strConnString = "driver=MySQL;SERVER=123.123.123.123;PORT=3306;DATABASE=DB_NAME;UID=abcde;PWD=xxxx" '## MySQL

ofcourse replacing the values with the one applicable in your case.


Pierre
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07