HELP! Web DB Connection String

[=EDGARDO=]

I'm trying to connect to an Access DB on a Web Server, with DSN Less Connection. This web server lets me use ASP, so I think I can create a client to EDIT Info in my DB.

I fallowed a sample project with MS OLE DB Provider for Internet Publishing, and I'. able to se de files on the web server.
But what I really want is to be able to EDIT data.

What Provider should I use to create a connection, and a record set from my DB?
What information should I look for on MSDN Library?

Thanks;

=EDGARDO=
Univ. Of Puerto Rico

try RDS or OLE DB remote provider !!!
hquang_cuong@hotmail.com

[Johnny101]

If you want to build the recordset on the server side, you can use this for the connection string:

Dim cn as adodb.connection
Dim sPathToMDB as string

sPathToMDB = Server.MapPath("YourMDB.mdb")

cn.connecionstring = "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};DBQ=" & sPathToMDB & ";"
cn.open

'then just open a recordset the same way as in regular VB.




Hope this helps,
John

John Pirkey
MCSD
www.ShallowWaterSystems.com