Click here to Skip to main content
14,978,764 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have problem connecting vb 6.0 to wamp(mysql, myphpadmin) server on my LAN. It connects to server on the same laptop using localhost but cannot be accessed by other Pcs using ip address. What could be the problem? Please, i need your help on this. OS=windows 7. below is my connection code:

Public con As New ADODB.Connection
con.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=192.168.0.102;Database=furniture1; User=root;Password=; Port=3306 Option=1 + 2 + 8 + 32 + 2048 + 16384;"
con.Open
con.CursorLocation = adUseServer


End Sub
Posted

1 solution

If i am right in understanding your problem, your sql server is on other machine and you are accessing it through your application on your machine... Right???

First check if your server is pinging through the machine where your are accessing.

Check that in
SQL Server Configuration Manager
--> Protocols for SQL
--> TCP/IP Enabled

Also check whether the server IP is displayed in SQL native client configuration Aliases

I think this might solve your issue.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900