Snitz Forums 2000 - changing hosts

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MS Access

changing hosts

New Topic

Topic Locked

Printer Friendly

Author

Topic

sami_rima
Starting Member

4 Posts

Posted - 24 September 2006 : 08:04:42

I was running my forum on access database with my myold host

I am changing hosts:

I copied all files and the database

and put them with th new host

now I am getting an error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x774 Thread 0xba8 DBC 0x224bfa4 Jet'.

/rimaforum/inc_header.asp, line 116

-- I cahnged the config.asp to reflect the new layout but I am still getting this error

any suggestions.

thanks

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 24 September 2006 : 09:08:31

Use a connection string with "Jet OLEDB" in it, from the ones marked as Access connection strings in config.asp.

Snitz 3.4 Readme | Like the support? Support Snitz too

sami_rima
Starting Member

4 Posts

Posted - 24 September 2006 : 09:15:05

whic one of those:


'sDB = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("..\database\mydb.mdb")
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../database/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
'strConnString = "DSN_NAME" '## DSN

sami_rima
Starting Member

4 Posts

Posted - 24 September 2006 : 09:29:57

I have two directories:

first main directory database:
subdirectory: snitz_forums_2000.mdb

the second main directory is:
webroot:

subdirectory: forum

sami_rima
Starting Member

4 Posts

Posted - 24 September 2006 : 11:00:42

issue is solved :

I used:

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97

thanks

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 24 September 2006 : 15:31:28

I strongly recommend that you use:


strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb"

This one will make your forum run faster and that previous problem simply won't show. With the other one, it may come back.

Snitz 3.4 Readme | Like the support? Support Snitz too

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.36 seconds.