Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

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.
0
dankennedy
Asked:
dankennedy
1 Solution
 
SethiCommented:
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?
0
 
EricOKellyCommented:
I use more SQL Server, but make sure that the machine's DCOM settings allow the remote machine to access it. Also use a UID/PWD that has security on the database.
0
 
SpideyModCommented:
A request for deletion has been made at: http://www.experts-exchange.com/Community_Support/CleanUp/Q_20551661.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
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
SethiCommented:
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.
0
 
dankennedyAuthor Commented:
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!
0
 
SpideyModCommented:
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
0
 
SpideyModCommented:
Points reduced from 500 to 250.  Force Accepted.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now