accessing ms access 2000 db

help120 · Jan 14, 2002

What I'm trying to do is connect to the snitz forum database and pull some info out of the guestbook. FORUM_GUESTBOOK and I want to pull info out of the table G_varfield1. Could Some one please help me out with this code?

http://www.finalphase.org/nps/forum/won/

This is my code that I'm using to connect to the database..

<HTML>
<BODY>
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection&quot

objConn.ConnectionString = "DBQ=C:\inetpub\finalphase\databases\snitz_forums.mdb;DRIVER={MS Access (*.mdb)}"
objConn.Open
%>

</BODY>
</HTML>

And this is the error I'm getting when I use this code

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/nps/forum/won/index.asp, line 7

krappleby025 · Jan 15, 2002

if the database is actually part of a website you can use the following to connect

<%
dim con
Set con = server.Createobject( "ADODB.Connection" )
Con.Open( "DRIVER={Microsoft Access driver (*.mdb)}; DBQ=" & server.MapPath("(place directory path here from the page you are running ie fpdb/laws.mdb)" ) )
%>
place your page here
<%
con.close
set con = nothing
%>

jonscott8 · Jan 15, 2002

help120 - As krappleby025 illustrates, MTL, your problem stems from not correctly specifying the name of the Access ODBC driver.

DRIVER={MS Access (*.mdb)}"

should be

DRIVER={Microsoft Access Driver (*.mdb)} Jon Hawkins

help120 · Jan 15, 2002

Thanks jon that did the trick.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

accessing ms access 2000 db

help120

Technical User

krappleby025

Programmer

jonscott8

Programmer

help120

Technical User

Similar threads

Part and Inventory Search

Sponsor