ASP to SQL Connection?

A

Alwa A

New member
I have a ASP program that is working with the Access (statictables.mdb)
Set Connection=Server.CreateObject("ADODB.Connection")
dbPath = Server.MapPath("/data/statictables.mdb")
Dim ConnectionString
ConnectionString="PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath
Connection.Open ConnectionString
SQL="SELECT * FROM dbo_vw_KW_B WHERE Right([APPL_YEAR],4)= '"& APPL_YEAR &"' AND LEFT([USER_ID],4)='"& USER_ID &"' AND Right([SSN_LAST4],4)='"& SSN_LAST4 &"' AND Left([BIRTH_DATE],10)='"& BIRTH_DATE &"';"
But when I am trying to connect to same database(SQL) it is not working. Here the( SQL)
dbPath = Server.MapPath("Driver={SQL Server};server=MY-SQL;database=table_new;uid=sa;pwd=year20013;")
Recordset.Open SQL, Connection
 
Back
Top