Connecting a SQL Server database with Visual Basic 6.0
What code would I need to connect a SQL Server database with Visual Basic 6?

Software/Hardware used:
ASKED: April 7, 2009  8:23 PM
UPDATED: October 25, 2009  3:27 AM

Answer Wiki:
use an ADODB data connection: dim cn As New ADODB.connection dim rs As New ADODB.Recordset If cn.state = 0 Then cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DatabaseName;Data Source=."
Last Wiki Answer Submitted:  April 7, 2009  10:25 pm  by  mshen   27,310 pts.
All Answer Wiki Contributors:  mshen   27,310 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

hi dis is sabur
i’m having many doubts
pls anyone clear

 10 pts.