whats my DSN.........help me

hi.whats my dsn. i dont know.please help me.thankx



ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("db/mem.mdb")

set my_conn= Server.CreateObject("ADODB.Connection")
RS.open Sql,my_conn,1,3

Re: whats my DSN.........help me

mehdi.webmaster@gmail.com wrote:
> hi.whats my dsn. i dont know.please help me.thankx
>
>
>
> ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
> Server.MapPath("db/mem.mdb")
>
You neither have one nor need one.

Actually, the connection string should be:
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("db/mem.mdb")

http://www.aspfaq.com/show.asp?id=2126

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"