show me how to connect visual basic with sequential query language server.
connect VB with SQL Server !!
Collapse
X
-
Here try this.Originally posted by dereshow me how to connect visual basic with sequential query language server.
I hope you know how to create a connectionstrin g....(",)
Or in place of ConnectionStrin g, you can use DSN Name.
Then, you can manipulate Rs object in your forms after calling it and passing an SQL query paramater coz its global recordset ADO object.Code:Public Con,Rs Public Function dbConnect(strQuery as string) set Con = CreateObject("ADODB.Connection") Con.ConnectionString = "<your connectionstring>" Con.Open set Rs = CreateObject("ADODB.Recordset") Rs.ActiveConnection = Con Rs.Open StrQuery End Function
Comment