?
Solved

Connect multiple users to MySQL using VB 6

Posted on 2003-03-14
7
Medium Priority
?
158 Views
Last Modified: 2010-05-01
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
Comment
Question by:dankennedy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 18

Expert Comment

by:Sethi
ID: 8140779
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
 

Accepted Solution

by:
EricOKelly earned 1000 total points
ID: 8143700
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
 

Expert Comment

by:SpideyMod
ID: 8143794
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 18

Expert Comment

by:Sethi
ID: 8145223
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
 
LVL 2

Author Comment

by:dankennedy
ID: 8146643
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
 

Expert Comment

by:SpideyMod
ID: 8146731
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
 

Expert Comment

by:SpideyMod
ID: 8167085
Points reduced from 500 to 250.  Force Accepted.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question