[Q] VB6 and SQLyog Connect to Network Database

[disinwebe]

Hi All,

Need your help.
I want to connect my VB6 and SQLyog application database from my PC client to Network Database.
Right now, i only can do connect my database thru my local PC (installed SQLyog and VB6). Is there any codes to connect my a VB6 to SQLyog database via network? Thanks.


Here's my current codes for local connection of my VB6 and SQLyog:

'connect to MYSQL Server
strString = "Server=localhost;driver={MySQL ODBC 3.51 Driver};database=NPI;dsn=;"
cnMySql.CursorDriver = rdUseOdbc
cnMySql.Connect = strString
cnMySql.EstablishConnection

Form1.Show

thanks in advanced.