DSN Less Problem

arimakidd · September 21st, 2005, 08:09 PM

Can someone tell me why this simple script is not working? I am testing my asp locally and everything always works just fine. However I wanted to start using my work live on the net and to do this I have to use a DSN Less connection. This is the script:

Code:

<%
Dim obCOnn
Dim obJEc
Set obCOnn = Server.CreateObject("ADODB.connection")
Set obJEc = Server.CreateObject("ADODB.recordset")
obCOnn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("wrox.mdb")
obJEc.Open "SELECT * FROM sailor", obCOnn
obJEc.MoveFirst
Response.Write obJEc(name) & "<br>"
obCOnn.close
obJEc.close
Set obCOnn = Nothing
Set obJEc = Nothing
%>

The database is access and you guessed it, the name is wrox.mdb. Can someone tell me what's wrong?

ChrisScott · September 22nd, 2005, 09:29 AM

What sort of errors are you getting?

IMHO you would be better off using the jet driver instead off the access one...

Code:

provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=yourDataSource;

Is your db really in the same directory as your web page? If this is the case, a user could download your database direct from the web.

HTH,

Chris

arimakidd · September 23rd, 2005, 10:41 PM

Isn't it great when you can solve your own problems. I forgot the inverted commas around (name) when refering to the recordset:

Code:

Response.Write obJEc("name")

This is the code for the DSN Less Connection:

Code:

obCOnn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data/wrox.mdb") & ";"