Database Connection (Urgent)
Posted on 2002-05-02
i am converting a vb application into a VC++ application,
in vb the following code is written to access the database,i am confused what to put VC++,i know only ODBC,now what should i do.
plzz guide me and the give me the code which can replace the below code in VC++.
sProcessId = "XXX"
sConnectstring = "Provider=SQLOLEDB;Data Source=STR;Initial Catalog=ZZZ;User Id=XXXX-AUSER;Password=Auser;"
Set Conn = New ADODB.Connection
Set RS = New ADODB.Recordset
sSQL = "USP_SELECT_RULES '" & sProcessId & "'"
RS.Open sSQL, Conn
In the Above Code USP_..... is a stored procedure in sql.