Basic DSN-Less Connection to DB

[Corey Bryant]

OK - VERY new to ASP. I thought that I could build a connectoin to the Database but I always got an error. I have a file in the database folder & then I have another folder - called count. Both of these are in the root. The db is called counter & the table is hit_count & the filed name is hit_count. I created a few different scenarios, but it did not work. Any suggestions? I searched thru www.asp101.com & a few others but nothing I saw was REALLY basic that I needed. Thanks!

[Smokie]

Hi Corey,

Please could you post the error message?

If you need help with connection strings, look here:
http://webforumz.com/topic.asp?TOPIC_ID=8

Cheers,
Smokie

[Corey Bryant]

Well the error message is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/counter/default.asp, line 13

Actually the db is in fpdb - has writeable permissions, etc. This is what I am using:
<%
'DSN Less Coneection to the Database

strDBPath = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=fpdb/counter.mdb"

' Create an ADO Connection to connect to the database.

Set cnnSimple = Server.CreateObject("ADODB.Connection")

' This line is for the Access sample database:
cnnSimple.Open strDBPath

' Execute a query using the connection object. It automatically
' creates and returns a recordset which we store in our variable.
Set rstSimple = cnnSimple.Execute("SELECT * FROM TestTable")


' Display a table of the data in the recordset. We loop through the
' recordset displaying the fields from the table and using MoveNext
' to increment to the next record. We stop when we reach EOF.
%>
And line 13:
cnnSimple.Open strDBPath

I know it is in the fpdb/counter - I am sure. Plus to read the value from the table - I am using: <%= rstSimple.Fields("hit_count").Value %> - not too sure if that is correct since it has not gotten that far either. Thanks!

[vor]

The Path to the database has to be the Physical Path, ie. c:\Db.mdb and not a Relative path ie. folder/db.mdb, which you seem to have used.

[Corey Bryant]

Thanks. That seems to have fixed it. Hm, my first connection. :P I guess I am moving on up. Thanks once again!!

[Rob]

It's worth also pointing out you could have used this:-

strDBPath = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("fpdb/counter.mdb")

:wink:

[Smokie]

strDBPath = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=fpdb/counter.mdb"

BTW the old access driver sucks, you should use Jet, it'll give you nicer error messages and better performance:

strDBPath = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("fpdb/counter.mdb") & ";"

[Monie]

Here is the complete connection to your database including the recordset:

Code: Select all

<%
 set conn = Server.CreateObject("ADODB.Connection")
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("fpdb/counter.mdb"))
 set rs = Server.CreateObject("ADODB.recordset")
 rs.Open "Select * from Customers", conn
%>