Data Source Wizard in Visual Studio 2005
Data Source Wizard in Visual Studio 2005
The DATA SOURCE Wizard in Visual Studio 2005 fails when selecting the MySQLDirect .NET Data Provider in the CONNECTION MANAGER window.
After selecting MySQLDirect .NET Data Provider and OK it simply drops to the DATA SOURCE wizard.
Configuration is:
Win Serv 2003
SQL Server 2005 with Analysis Services
MySQL on the network somewhere
Installed trial version of MySQLDirect .net.
Objective is to test the above environment to haul data from MySQL into an Analysis Services cube.
Tried running the MySQLDirect .NET DATASET wizard. Works fine till the last step. Selecting the GENERATE button presents the following error message: "THE METHOD OR OPERATION IS NOT IMPLEMENTED". Selecting OK on the message drops back to the wizard.
After selecting MySQLDirect .NET Data Provider and OK it simply drops to the DATA SOURCE wizard.
Configuration is:
Win Serv 2003
SQL Server 2005 with Analysis Services
MySQL on the network somewhere
Installed trial version of MySQLDirect .net.
Objective is to test the above environment to haul data from MySQL into an Analysis Services cube.
Tried running the MySQLDirect .NET DATASET wizard. Works fine till the last step. Selecting the GENERATE button presents the following error message: "THE METHOD OR OPERATION IS NOT IMPLEMENTED". Selecting OK on the message drops back to the wizard.
What edition of Visual Studio do you use? VS2005 that comes with Analysis Services (Business Intelligence Development Studio)
Specify your hardware architecture: x32 or x64? x32
What is the full version of MySQLDirect .NET you use? Latest...only downloaded today. MySQLDirect .NET version 3.50 for .NET Framework 2.0
Std, Pro, Mobile? Std (I think)
One other thing I forgot to mention ...this is all running under MS Virtual PC (except for the MySQL which is a real server). The virtual machine is visible on the network and works fine. When testing the connection to the MySQL database in the wizard it comes up fine.
Specify your hardware architecture: x32 or x64? x32
What is the full version of MySQLDirect .NET you use? Latest...only downloaded today. MySQLDirect .NET version 3.50 for .NET Framework 2.0
Std, Pro, Mobile? Std (I think)
One other thing I forgot to mention ...this is all running under MS Virtual PC (except for the MySQL which is a real server). The virtual machine is visible on the network and works fine. When testing the connection to the MySQL database in the wizard it comes up fine.
same issue with me
Hi,
I have the same issue by MysQLDirect.Net data provider in Data Source Wizard of Business Intelligence Studio.
When I used DataSet Wizard in Tools-> MYSQL menu, I am ending up in an error message that this operation og generating dataset is not supported.
When I try to add a new connection in 'Server Explorer' window, it complains that
'An unexpected error occurred in the MySQLDirect .NET Data Provider. Please contact the provider vendor to resolve this problem'.
Any help in this regard is really helpful.
Thanks,
Syamala
I have the same issue by MysQLDirect.Net data provider in Data Source Wizard of Business Intelligence Studio.
When I used DataSet Wizard in Tools-> MYSQL menu, I am ending up in an error message that this operation og generating dataset is not supported.
When I try to add a new connection in 'Server Explorer' window, it complains that
'An unexpected error occurred in the MySQLDirect .NET Data Provider. Please contact the provider vendor to resolve this problem'.
Any help in this regard is really helpful.
Thanks,
Syamala
Yes it is same other than Virtual PC configuration
My configuration is
SQL Server 2005 Business Intelligence Studio that comes with
Visual Studio 2005 Standard Edition (uses .NET Framework 2.0) which is installed with SQL Server 2005 Trial Edition.
I tried same thing with SQL Server 2005 Standard Edition installation which installs same client applications also and resulted in the same problem.
I appreciate very much for your help in this, because this is critical to my project.
Thanks,
Syamala
My configuration is
SQL Server 2005 Business Intelligence Studio that comes with
Visual Studio 2005 Standard Edition (uses .NET Framework 2.0) which is installed with SQL Server 2005 Trial Edition.
I tried same thing with SQL Server 2005 Standard Edition installation which installs same client applications also and resulted in the same problem.
I appreciate very much for your help in this, because this is critical to my project.
Thanks,
Syamala
This could be caused by Visual Studio 2005 Standard Edition. The appropriate forum topic is http://crlab.com/forums/viewtopic.php?t=3860. Please take a look.
SQL Syntax error creating Data Source View in Business Intelligence Studio
Hi,
Now I got this problem solved by installing Visual Studio Professional Edition Trial Version, but I could not create a Data Source View in Business Intelligence Studio, based on which cubes will be built.
The exact error I am getting is
TITLE: Microsoft Visual Studio
------------------------------
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[PRESCRIPTION] limit 0,0' at line 2
When I create data source view, it tries to find the relations between the tables chosen from the data source.
I know the problem here is the enclosers ('[' , ']') around the table name which is not accepted by MySQL SQL Syntax.
So I don't know why .Net Data Provider is producing improper syntax. Are there any settings on .Net Data Provider that I need to configure?
I am using MySQL Server 5.0. Any help in this regard is appreciated.
Thanks,
Syamala
Now I got this problem solved by installing Visual Studio Professional Edition Trial Version, but I could not create a Data Source View in Business Intelligence Studio, based on which cubes will be built.
The exact error I am getting is
TITLE: Microsoft Visual Studio
------------------------------
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[PRESCRIPTION] limit 0,0' at line 2
When I create data source view, it tries to find the relations between the tables chosen from the data source.
I know the problem here is the enclosers ('[' , ']') around the table name which is not accepted by MySQL SQL Syntax.
So I don't know why .Net Data Provider is producing improper syntax. Are there any settings on .Net Data Provider that I need to configure?
I am using MySQL Server 5.0. Any help in this regard is appreciated.
Thanks,
Syamala