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: General / Current Version (Old)
 80020009 - The Revenge		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sayanora
Starting Member

United Kingdom
5 Posts
Posted - 26 June 2001 :  20:46:00  Show Profile  Visit Sayanora's Homepage  Send Sayanora an ICQ Message
OK I've copied the files to my domain server (which does support ASP) and set the config.asp as follows:


'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/web/forum/tools/snitz_forums_2000.mdb" & Server.MapPath("/web/forum/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"


I get this error message:


the ADODB.Connection.1 error '80020009'

Empty connection string.

inc_top.asp, line 42



What's going on?


I like Jam.

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 26 June 2001 :  21:11:40  Show Profile
you need to change your strConnString.

Currently it's this:

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


change it to this:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/web/forum/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Go to Top of Page

Sayanora
Starting Member

United Kingdom
5 Posts
Posted - 26 June 2001 :  22:28:23  Show Profile  Visit Sayanora's Homepage  Send Sayanora an ICQ Message
ok - now I get this:

ADODB.Connection.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified


inc_top.asp, line 42


I like Jam.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 26 June 2001 :  22:51:21  Show Profile
ok, try this:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\web\forum\tools\snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Go to Top of Page

Sayanora
Starting Member

United Kingdom
5 Posts
Posted - 26 June 2001 :  22:56:55  Show Profile  Visit Sayanora's Homepage  Send Sayanora an ICQ Message
Still getting the same error.

Perhaps my host does not support Access Databases - what would I need to test the theory by using an SQL database? Just a blank database?

I like Jam.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 26 June 2001 :  23:24:18  Show Profile
Yes, you will need to already have a SQL database.
Go to Top of Page

Sayanora
Starting Member

United Kingdom
5 Posts
Posted - 27 June 2001 :  23:09:15  Show Profile  Visit Sayanora's Homepage  Send Sayanora an ICQ Message
Guess I should find out if they only support SQL then before I start messing about with non-Access databases. God I hate being a webmaster.


~..~
-<>- who's that Pokemon?

I like Jam.
Go to Top of Page

Craig from Alberta
Starting Member

Canada
7 Posts
Posted - 28 June 2001 :  18:56:26  Show Profile  Visit Craig from Alberta's Homepage
Are you sure what path your .mdb is stored in? If it is not in \web\forum\tools\ then the Server.MapPath will fail with this connection string.

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\web\forum\tools\snitz_forums_2000.mdb") '## MS Access 2000 using virtual path

Exactly what is the path to the Access database?
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 28 June 2001 :  21:13:10  Show Profile
quote:
INTERSOLV][ODBC lib] Data source name not found and no default driver specified

This error isn't from an Access DB driver.

======
Doug G
======
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 29 June 2001 :  07:15:44  Show Profile
I think he is on a linux server.

- David
Go to Top of Page

Craig from Alberta
Starting Member

Canada
7 Posts
Posted - 04 July 2001 :  10:31:29  Show Profile  Visit Craig from Alberta's Homepage
It would help greatly if those with problems explained things a bit more like exactly what platform, web server and database they are using. If they are on Linux then I suspect they are using MySQL. Access will not run on Linux.
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.49 seconds. Powered By: Snitz Forums 2000 Version 3.4.07