connection on MS SQL server

[roby]

hi,

i have a website on ASP language and connection with
MS access and i want to make it with MS SQL sever what is the changes that i will make it

roby

[sanjay]

can u please type u r connection string

[roby]

Originally posted by sanjay
can u please type u r connection string

hi,
that is the connection with MS Access

Dim DB_CONNECTION
DB_CONNECTION = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("./myDB") & ";"



roby

[sanjay]

Please c
DB_CONNECTION = "Provider=MSDASQL;DRIVER={SQL Server};Database=databasename; Server=Servername;UID=userid; PWD=password"