Can't make new MSSQL database connection anymore

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
dghundt
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Can't make new MSSQL database connection anymore

Post by dghundt » Sat 16 Sep 2006 21:22

Before I installed the corelab mysql direct.net data provider, I could establish new database connections in visual studio 2005 standard edition. I could use odbc, or mssql just fine previously.

I installed core lab for mysql a few weeks ago, which I think works great, but now I cannot establish new database connections. Here is what I do in visual studio 2005. At the tool strip I select:

Data, Add new data source, Database, next, New Connection.

The error I get is:
An unexpected error occured in the mysqldirect.net data provider. please contact the vendor to resolve this problem.

Why can I not establish ANY database connections via this method? It appears I can only go through corelab utilities now.

I see older posts from April discussing this is a known issue with Corelab, but this has not been fixed yet? I do not want to upgrade to visual studio professional edition to overcome a bug in corelab.

I appreciate your comments and help with this.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 18 Sep 2006 05:48

This problem is going to be resolved very soon.
To make other providers work try to uninstall MySQLDirect.

dghundt
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Post by dghundt » Mon 18 Sep 2006 23:51

THank you Alexey for looking into this. I think you have developed a great product here. Unfortunately, I can't uninstall mysqldirect, as this is needed for the program to run.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 19 Sep 2006 06:35

We are going to issue a new build in a couple of days.
Thanks for your patience.

dghundt
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Post by dghundt » Thu 21 Sep 2006 02:20

Thanks! I'll give it a whirl. :lol:

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 21 Sep 2006 07:53

Good luck :wink:

dghundt
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Post by dghundt » Thu 21 Sep 2006 22:13

I am still getting the same error....

I uninstalled MySqlDirect.net from the start menu
I logged on to your server and installed mysqldirect.net version 3.50.13.0
I removed the reference to corelab.mysql
I then added the reference corelab.mysql 3.50.13.0, but none of the other references.
I ran my application and it worked.

But I still cannot make a new connection in the Data Source Configuration Wizard. I get the same error as before. Please tell me what you did to get this working on your test system.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 22 Sep 2006 10:09

Try to run "devenv /resetskippkgs" from the command line.

dghundt
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Post by dghundt » Fri 22 Sep 2006 12:41

Thank you for your reply.
I am not sure where to place this command properly.

Do you mean open up a dos command window (shell), and type that command at the prompt without changing to another directory?

Or click on Start, run, and enter it there.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 22 Sep 2006 12:53

Yes, click on Start, run, and enter it there.
Don't forget to close all your Visual Studio instances before.

dghundt
Posts: 38
Joined: Thu 24 Aug 2006 01:16

Post by dghundt » Sat 23 Sep 2006 01:38

Hey! You fixed it! This post I am sure will help others. :lol:

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 25 Sep 2006 06:01

Good news :)

Post Reply