A valid connection with Oracle using asp is
<%
Set Con = Server.CreateObject( "ADODB.Connection" )
     Con.Open "driver={Oracle ODBC driver};" & _
               "Server=ORCLSL;" &_
               "Uid=GEST;"&_
               "Pwd=manager;"
 
sqlString = ".........."
Con.Execute( sqlString )
%>
 
I try to connect to sap db but i have a lot of problem.
 
<%
Set Con = Server.CreateObject( "ADODB.Connection" )
     Con.Open "driver={SAP DB 7.3 driver};" & _
               "Server=SERVER;" &_
               "Uid=TEST;"&_
               "Pwd=TEST;"
 
sqlString = ".........."
Con.Execute( sqlString )
%>
 
DO NOT WORK
 
ODBC DSN CONNECTION
 
<%
Set Con = Server.CreateObject( "ADODB.Connection" )
     Con.Open  "DSN=SERVERDB;" &_
               "Uid=TEST;"&_
               "Pwd=TEST;"
 
sqlString = ".........."
Con.Execute( sqlString )
%>
 

May you help me ?!!!!
 
server=server
database=tst
user=test
password=test
dsn=serverdb

Reply via email to