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
 Database error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bubi
Starting Member

17 Posts
Posted - 02 May 2001 :  03:09:52  Show Profile
Hello,
I have problem for few days and I am not finally able to solve it!!! Please HELP!

I have ASP pages at brinkster server and when I am trying to get to default.asp page, it shows me error happende in inc_top.asp file:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/ifbb/inc_top.asp, line 43

The problem line is:
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString

What can I do? People from Support@brinkster.com think everything is ok, but my pages do not work.

Jan

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 02 May 2001 :  03:16:15  Show Profile
Can you post the strDBType and strConnString lines that you uncommented in config.asp ?
Go to Top of Page

bubi
Starting Member

17 Posts
Posted - 02 May 2001 :  03:29:22  Show Profile
strDBType = "access"

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\ifbb\db\snitz_forums_2000.mdb")

OR, Brinkster recommended me,:

Set Conn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("\ifbb\db\snitz_forums_2000.mdb") & ";" & _
"Persist Security Info=False"
Conn.Open(sConnection)

Both do not work.

Jan

http://www20.brinkster.com/ifbb/default.asp
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 02 May 2001 :  03:34:46  Show Profile
try changing your strConnString to this:


strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/ifbb/db/snitz_forums_2000.mdb")
Go to Top of Page

bubi
Starting Member

17 Posts
Posted - 02 May 2001 :  03:41:08  Show Profile
quote:

try changing your strConnString to this:


strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/ifbb/db/snitz_forums_2000.mdb")



Oh know!!! It works !!! What was wrong?
You are FANTASTIC! If you need something about fitness or bodybuilding, let me know!
Jan
ifbb@seznam.cz
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 02 May 2001 :  03:46:13  Show Profile
I just changed: \ to /

you're welcome
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07