Is it posible to connect my vb6.0 program to a wamp(mysql, myphpadmin) server on my pc. If i use my program to other part of our country, can i still connect to the wamp server? This is my challenge for a job, the IT personel from a company i am applying wants me to create a server based program.
2mhzbrain
0
Light Poster
Recommended Answers
Jump to PostAs long as there is a connection between the computer and the server, whether it's intranet, or internet, you can make the program connect. The main question is changing the connection string to reflect a different server address, and possibly different credentials.
Jump to Postas far as I can tell you'll have to change to a static IP( maybe a different ISP), or subscribe to a Dynamic DNS service. I have no personal knowledge of this but if you Google it there are plenty of links that can help you.
Jump to PostThis will make the connection for you. Change the detail as needed...
Dim cnServer As ADODB.Connection Dim rsServer As ADODB.Recordset Set rsServer = New ADODB.Recordset Set cnServer = New ADODB.Connection cnServer.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _ & "SERVER=MyIPAddressOfServerHere;" _ & "Port=3306;" _ & "DATABASE=MyDatabaseNameHere;" _ & …
All 9 Replies
tinstaafl
1,176
Posting Maven
2mhzbrain
0
Light Poster
tinstaafl
1,176
Posting Maven
AndreRet
526
Senior Poster
2mhzbrain
0
Light Poster
2mhzbrain
0
Light Poster
2mhzbrain
0
Light Poster
AndreRet
526
Senior Poster
ikocrush
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.