How to Connect VB6 to SQL2005?

Asked By 0 points N/A Posted on -
qa-featured

I'm currently doing a library system using VB6 and i want to connect it in SQL2005 for my database, but i don't have any idea how to do it. your Answer will be a great help. Thanks

SHARE
Best Answer by AllieWick
Answered By 0 points N/A #162964

How to Connect VB6 to SQL2005?

qa-featured

 

Hi Techyman,

I found useful links regarding connecting SQL Server – 2005 database with VB-6. Please check the following links. In this example they explain it steps by steps. Please read the post and get idea. You can do it easily.

· http://msdn.microsoft.com/en-us/library/bb264566(v=sql.90).aspx
· http://www.ehow.com/how_10015133_connect-sql-vb6.html
· http://www.dbforums.com/microsoft-sql-server/1217739-connect-vb6-sql-server.html
· http://stackoverflow.com/questions/2962296/vb6-adodb-connection-string-to-sql-server-2008

Hope this is helpful.

Answered By 0 points N/A #162965

How to Connect VB6 to SQL2005?

qa-featured

 

Hi Techyman,

You can try installing a connection line like the following: "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=test1;Network=DBMSSOCN;Server=100.100.100.100;Integrated Security=SSPI". There are three types of connection: ADO, ODBC, and direct connection type. Each one is different from others. So, choose your connection type according to your need. If you want to learn visually, this video might help you:

Hope this helps.

Best Answer
Best Answer
Answered By 0 points N/A #162966

How to Connect VB6 to SQL2005?

qa-featured

You’re going to need to enter some code for this one.  First, open Visual Basic, create a new project, and specify a location for the project files.  Hit “Query” and select “MSHFlexGrid.”  Click the blank area in “Form1” to add the MSHFlexGrid to Form1.  Here’s where the code comes in.  Double click the MSHFlexGrid and enter:

Dim sql_cn As ADODB.Connection

Set sql_cn = New Connection

sql_cn.ConnectionString =  “Provider=SQLNCLI.1; Integrated Security=SSPI;” & _

“Persist Security Info=False;” & _

“AttachDBFileName=” & App.Path & “northwnd.mdf;DataSource=server1sqlexpress”

sql_cn.Open

——————-

This code sets up an ADO database connection to northwnd.mdf.  The database engine is SQL Server Express.  The last thing you need to do is specify data table “orders” as the data source for the MSHFlexGrid.  To do this, enter this code:

Dim sql_rs As Recordset

Set sql_rs = New Recordset

sql_rs.Open “Select * from orders”, sql_cn

Set MSHFlexGrid1.DataSource = sql_rs

Login/Register to Answer

Related Questions