How to connect VB6 using adodc wizard (not hard coded) to MS SQL server 2005 Connecting To Mysql Databse

[iGuest 3]

How to connect VB6 using adodc wizard (not hard coded) to MS SQL server 2005 Connecting To Mysql Databse

Hi 

I'm having a problem, I can connect my program to a database. I'm using a VB6 adodc wizard. what I'm doing is I right click the adodc then at the datalink properties - MS oledb provider for sql server then on the connection tab, ive choose the server name and when I click #3.- select the database on the server. It always says dbnetlib connection open sqlserver does not exist or access denied, I already created the tables on the other computer. And what I'm trying to do is to network the program and should link and read the datas on another computer. Ive already check the server management settings and enabled tcpip/named pipes etc.

 

Regards, 

Anthony