VB6 to SQL SERVER

Question

hi, am new in SQL programming.. and am using SQL 2000. my main problem is to connect the server to another PC running a VB6. pls help me.

Answer 1

This tutorial may help. Also, check out connectionstrings.com for SQL Server 2000.

Answer 2

The nature of server-client relationships is that it is the client that actively initiates the connection, not the server... In this case, the client is your VB6 app. The fact it is on another machine is beside the point btw - everything I am about to say would apply even it they were on the same machine.

In order to get a connection from your app to the MS-SQL Server, you want to be looking at using ADO. You're going to have to google around for an example, but in brief...

You use a connection object to connect to the server. You use a command object, and parameter objects, to create queries. If you are talking Select queries, you view (and possibly amend) the data using Recordsets.

Hope this sets you on the right path...

Have a look here...