Thursday, March 29, 2012

dsn help

how can i know the DSN name to connect my database to the server.
DSN Name : work

Database Name data\work.mdb

Type Access

the code i wrote is this
conClsf = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=data\\me.work" & server.mappath("data\\work.mdb") & ";")

i don't know what to soFor data source, provide the physical path to the data source only. Or if using DSN, you just use the "dsn=<name>" text, I believe. Is this ASP.NET 2.0 code?

Brian

No comments:

Post a Comment