PDA

View Full Version : Creating DSNless Connection Strings and OLE DB errors in ASP



Dylan
April 28th, 2002, 11:24 AM
My Site (www.bytesparks.com/aka) involves the use of a developmental database connection. This is the first attempt and I am using a Custom Connection String and the Server.MapPath method of identifying the database.

I am fairly sure that my database folder permissions are correct as the folder was created by my Supplier. There is perhaps still a problem with my ASP coding and am wondering if I need to define the PROVIDER parameter.

my code follows...
"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\bytesp\data\aka_messager.mdb")

As you will see if you navigate to the 'chat-room', log in as 'body' password 'beirut' and try to add your own message.

There is a problem only with writing to the database, existing fields and data are being shown by the ASP.

Getting more and more lost!

Dylan

kirupa
May 2nd, 2002, 07:19 PM
Hey Dylan,
I really am not sure what the answer to your problem would be. I have no real knowledge of ASP to help solve your question :( Sorry!

Cheers,
Kirupa