How to Connect VB6 to SQL2005?

Asked By techyman 0 points N/A Posted on - 09/15/2012

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

• Status: Open
• Question Views: 1409
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Software Others

Best Answer by AllieWick

Go To Solution

Answered By limasler 15 points N/A #162964

How to Connect VB6 to SQL2005?

 

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.

· https://msdn.microsoft.com/en-us/library/bb264566(v=sql.90).aspx
· https://itstillworks.com/execute-sql-script-visual-basic-6201818.html
· http://www.itprotoday.com/business-intelligence
· https://stackoverflow.com/questions/2962296/vb6-adodb-connection-string-to-sql-server-2008

Hope this is helpful.

About limasler

Questions
2

Answers
50

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 09/16/2012
• Question Category: Software Others

Answered By Eville bandler 5 points N/A #162965

How to Connect VB6 to SQL2005?

 

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.

About Eville bandler

Questions
1

Answers
52

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 12/06/2012
• Question Category: Software Others

Best Answer

Best Answer

Answered By AllieWick 0 points N/A #162966

How to Connect VB6 to SQL2005?

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

About AllieWick

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/10/2012
• Question Category: Software Others