Ejaz
July 24th, 2003, 03:47 AM
Hi All,
I created an application with VB 6.0 at front end and MS-Access 2000 at backend, it worked perfectly, life was fairly cool till then.
Then one day, I come to know that the other office need to be integrated. Now the situation is like that, the other office will use the same application that have already been developed in VB, but the database is suggested to be deployed at the web-server, now both offices will use the same applicaton, which is suppose to conect the database at the web-server, get the data from there and proceed.
Ok, fine...there comes another twist then, the web-server supports My-SQL and the database have to be converted into My SQL from Access.
Now the situation is like that. I'm totally new to My SQL, but thats not much problem. The point that I'm after is, how to manage the connection from my application at 2 different locations, to the My SQL at the web-server.
Any help in this matter will be highly appriciated & thanx in advance.
I created an application with VB 6.0 at front end and MS-Access 2000 at backend, it worked perfectly, life was fairly cool till then.
Then one day, I come to know that the other office need to be integrated. Now the situation is like that, the other office will use the same application that have already been developed in VB, but the database is suggested to be deployed at the web-server, now both offices will use the same applicaton, which is suppose to conect the database at the web-server, get the data from there and proceed.
Ok, fine...there comes another twist then, the web-server supports My-SQL and the database have to be converted into My SQL from Access.
Now the situation is like that. I'm totally new to My SQL, but thats not much problem. The point that I'm after is, how to manage the connection from my application at 2 different locations, to the My SQL at the web-server.
Any help in this matter will be highly appriciated & thanx in advance.