dankennedy
asked on
Connect multiple users to MySQL using VB 6
I am trying to connect multiple users to a MySQL server running on a Windows 2000 Server from a program I am writting in VB 6.0. I can connect to the server with no problem when I'm running the program on the same server that MySQL is installed on. When I try to connect from another system it doesn't work. Here is the code I'm using (using ADO)...
DBCon.Open "Driver={MySQL ODBC 3.51 Driver};" & _
"Server=" & strServer & ";" & _
"Database=MyDatabase;"
strServer can be set to the name of the server I want to connect to. I'm going to be setting this software up on lots of systems so I don't want to manually create DSN connections on every system. I'd prefer to have a DSN-less connection.
Thanks for your help.
DBCon.Open "Driver={MySQL ODBC 3.51 Driver};" & _
"Server=" & strServer & ";" & _
"Database=MyDatabase;"
strServer can be set to the name of the server I want to connect to. I'm going to be setting this software up on lots of systems so I don't want to manually create DSN connections on every system. I'd prefer to have a DSN-less connection.
Thanks for your help.
Sethi
I dont see anything wrong with the Connection string you have mentioned above. Do you get an error while connecting or any other indication that the application is not working?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A request for deletion has been made at: https://www.experts-exchange.com/questions/20551661/Delete-Question.html
Experts, you have 72 hours to object.
dankennedy,
First, you have provided no responses to the experts who have donated their time to try to assist you.
Second, please tell us what the resolution was so that we may add value to our database.
Third, in the future, please announce your intentions for a refund in the original question prior to requesting it in community support.
Thanks
SpideyMod
Community Support Moderator @Experts Exchange
Experts, you have 72 hours to object.
dankennedy,
First, you have provided no responses to the experts who have donated their time to try to assist you.
Second, please tell us what the resolution was so that we may add value to our database.
Third, in the future, please announce your intentions for a refund in the original question prior to requesting it in community support.
Thanks
SpideyMod
Community Support Moderator @Experts Exchange
I have no objection to refunding the point, but would like to know the solution dankennedy found to this problem so that it can be a lerning experience for future problems like this.
ASKER
Sure...
It was a combination of not using a UID/PASS (because I thought MySQL was using NT Authentication), my application was actually failing at a different connection string, and the account in MySQL was there, but it didn't have correct permissions on the DB.
I tried using with UID/PASS and without and neither worked because of the other problems I mentioned above.
It turned out to be more of a MySQL problem then a VB problem.
Thanks!
It was a combination of not using a UID/PASS (because I thought MySQL was using NT Authentication), my application was actually failing at a different connection string, and the account in MySQL was there, but it didn't have correct permissions on the DB.
I tried using with UID/PASS and without and neither worked because of the other problems I mentioned above.
It turned out to be more of a MySQL problem then a VB problem.
Thanks!
dankennedy,
Thanks for your response and adding value to the database. The question I would have is that if the issue was one of permissions on the DB, then the comment by EricOKelly has some merit. I don't think the response is worthy of 500 points, but I do suspect that it should have some points assigned. If you agree, let me know how many points you'd like EricOKelly to receive and I can make that happen. If you disagree, and still want a full refund, let me know also and we will continue to allow until the 18th to finalize.
Thanks.
SpideyMod
Community Support Moderator @Experts Exchange
Thanks for your response and adding value to the database. The question I would have is that if the issue was one of permissions on the DB, then the comment by EricOKelly has some merit. I don't think the response is worthy of 500 points, but I do suspect that it should have some points assigned. If you agree, let me know how many points you'd like EricOKelly to receive and I can make that happen. If you disagree, and still want a full refund, let me know also and we will continue to allow until the 18th to finalize.
Thanks.
SpideyMod
Community Support Moderator @Experts Exchange
Points reduced from 500 to 250. Force Accepted.
SpideyMod
Community Support Moderator @Experts Exchange
SpideyMod
Community Support Moderator @Experts Exchange