CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




Can Reply:  No Members Can Edit: No Online: Yes
Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_studio_2005 Tags:
Item Type: NewsGroup Date Entered: 7/20/2006 6:41:39 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 12 Views: 71 Favorited: 0 Favorite
13 Items, 1 Pages 1 |< << Go >> >|
awilinsk
Asp.Net User
Adding Data Provider to Visual Studio 20057/20/2006 6:41:39 PM

0

I have just finished creating a MySQL Data Provider. I have added the data provider in the machine.config file. I would like to add this data provider to Visual Studio so that when I choose to create a new connection string, the provider would show up in the list of providers. How would you add a data provider to show up in the list?

Also, can anyone give me any links on how to make a installation program that will do this automatically?

Thanks,

Andrew

-wili
vcsjones
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 5:19:05 PM

0

You need to make sure the MySQL ODBC driver is installed on the machine you are working with. You would have to connect to it with Visual Studio via ODBC.

Cheers,
       Kevin Jones
awilinsk
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 6:24:09 PM

0

I'm not using the ODBC Data Provider. I created a data provider to work directly with MySQL. This new data provider is what I want to add to Visual Studio.
-wili
Caddre
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 6:30:50 PM

0

Help me understand this? You have created your own protocol level driver to connect to MySQL?  I am assuming you know it takes months and teams to write one.  That is what Datadirect do for a living.

http://www.datadirect.com

Kind regards,
Gift Peddie
vcsjones
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 7:22:47 PM

0

No, this person is talking about a .NET Data provider, like these: http://msdn2.microsoft.com/en-us/library/a6cd7c08.aspx

Cheers,
       Kevin Jones
Caddre
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 7:32:05 PM

0

That is the same thing I am talking about because when you are writing it for a third party RDBMS(relational database management systems) like MySQL it takes a lot of effort to write such providers because you are connecting to MySQL on the sucket level.  That is the reason the code you can write with Oracle provider by Oracle and Oracle provider by Microsoft are not the same.
Kind regards,
Gift Peddie
awilinsk
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 7:55:17 PM

0

I did write my own Data Provider for MySQL, with a little help from the MySQL .Net Connector assemblies and Reflector. Yes it took me a couple months to do, but I'm done and going through testing. None of the MySQL .Net Connector classes derived from the correct base classes in the System.Data.Common namespace, so I reconstructed them. I know CoreLab has one of these, but I didn't want to spend the money and I had fun developing it.

-wili
Caddre
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 8:07:17 PM

0

MySQL just bought another commercial provider by ByteFX, I don't know what to tell you but I would start with the Bin directory.
Kind regards,
Gift Peddie
awilinsk
Asp.Net User
Re: Adding Data Provider to Visual Studio 20057/21/2006 8:43:32 PM

0

I have installed this in the GAC and made references to it in the machine.config file, so the bin directory is out of the equation.

-wili
awilinsk
Asp.Net User
Re: Adding Data Provider to Visual Studio 20058/2/2006 4:08:23 PM

0

After days of searching, I came across my answer. It is called DDEX Support. There are four samples in the Visual Studio 2005 SDK and here is an article about it: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/ddexintro.asp
-wili
Caddre
Asp.Net User
Re: Adding Data Provider to Visual Studio 20058/2/2006 4:18:17 PM

0

I am glad you have resolved your problem, keep me posted how it goes because building provider is not a trivial task.
Kind regards,
Gift Peddie
awilinsk
Asp.Net User
Re: Adding Data Provider to Visual Studio 20058/14/2006 3:09:27 PM

0

I have the provider built and am able to show it in the server explorer with its hierarchy. I have also added the provider to the add connection dialog box with its custom interface to connect to the MySQL database. I still need to do a whole lot more testing before I put this control out to the public, but it seems to be working great. I can select it as my data provider when adding a SqlDataSource Control to my webform and perform updates and deletes and selects and such. The only thing I cannot find how to implement is the server explorer tasks. Like when you right click on a table and choose new query or show table data, etc. That will have to wait until later to add that functionality.
-wili
lazzarus
Asp.Net User
Re: Adding Data Provider to Visual Studio 20058/15/2006 3:18:33 PM

0

hi awilinsk,

i'm interested @ your work (Microsoft announced a .NET provider for MySQL)

Try MySQL .NET Provider developped by Luca. You can find it @

http://www.skakkinostri.com/mysql/

 

Regards.

 

 
13 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Mastering Web Development with Microsoft Visual Studio 2005 Authors: John Paul Mueller, Pages: 822, Published: 2005
Microsoft SQL Server 2005 New Features: New Features Authors: Michael Otey, Pages: 352, Published: 2004
Professional Visual Studio 2005 Authors: Andrew Parsons, Nick Randolph, Pages: 869, Published: 2006
Microsoft SQL Server 2005 Developer's Guide: Developer's Guide Authors: Michael Otey, Denielle Otey, Pages: 507, Published: 2005
Professional ASP.NET 3.5: In C# and VB Authors: Bill Evjen, Scott Hanselman, Devin Rader, Pages: 1673, Published: 2008
Advantage Database Server: A Developer's Guide Authors: Cary Jensen, Loy Anderson, Pages: 616, Published: 2007
Pro ASP.NET 2.0 in C# 2005 Authors: Matthew MacDonald, Mario Szpuszta, Pages: 1255, Published: 2005
Professional Visual Studio 2005 Team System Authors: Jean-Luc David, Tony Loton, Erik Gunvaldson, Christopher Bowen, Noah Coad, Darren Jefford, Pages: 700, Published: 2006
IBM DB2 9 New Features Authors: Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton, Pages: 422, Published: 2007
Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers Authors: Tom Arnold, Dominic Hopton, Andy Leonard, Mike Frost, Pages: 372, Published: 2007

Web:
Adding Data Provider to Visual Studio 2005 - ASP.NET Forums Adding Data Provider to Visual Studio 2005. Last post 08-15-2006 11:18 AM by lazzarus. 12 replies. Sort Posts: ...
New DataSet Features in Visual Studio 2005 Visual Studio 2005 introduces the concept of Data Sources for a project. .... In the Data Sources window, click on the Add New Data Source toolbar button. ...
IBM - DB2 for .NET: Innovate with Visual Studio The "IBM Database add-ins for Visual Studio 2005" includes:. Support for DB2 data servers; New IBM DB2 Data Provider for . ...
High Perfomance ADO.NET Provider for MySQL with Significantly ... NET integrates tightly with Visual Studio 2005/2008, Delphi, and SQL Server ... an advanced add-in for designing databases and easily manipulating data and ...
Jiří {x2} Činčura : DDEX, Vista (64-bit), Firebird, Visual Studio 2005 Some months ago I was writing about installing DDEX provider for Firebird to Visual Studio [DDEX and Firebird .NET Data Provider]. ...
Connectivity Guide :: Integration with Visual Studio 2005 Add Ingres Documentation Search to your Firefox or IE7 Searchbar ... NET Data Provider must be installed into the Visual Studio 2005 Toolbox before using it ...
Firebird File Repositories NET Data provider is written in C# and provides a high-performance, ... Version 2.0.4 for Visual Studio 2005/2008. 7th Sep 2008 DDEX Provider (.zip) (32kb) ...
HOWTO: Using the Choose Data Source dialog of Visual Studio 2005 ... NET data providers. Microsoft fixed this situation in the .NET Framework 2.0 and Visual Studio 2005 and therefore the new "Add New Connection. ...
Binding DB2 Data to Visual Studio 2005 Windows Applications Net Framework Data Provider for IBM DB2 data provider so that the Server Explorer ... After adding your database connection, the Visual Studio 2005 Server ...
Oracle Data Access Components (ODAC) for Windows Oracle Developer Tools for Visual Studio 2005 10.2.0.2.20. Oracle Data Provider for .NET 1.x 10.2.0.2.20. Oracle Data Provider for .NET 2.0 10.2.0.2.20 ...

Videos:
Silicon Valley WebGuild: Vertical Search Trends Google Tech Talks August 23, 2006 Silicon Valley Web Guild http://www.webguild.org/ Presenters: Michael Yang, Founder, President and CEO, Become.co...






solution contains errors but still builds..

remotely check out and check via vs2005

how to consistently crash vs 2005

show c# methods and variables in a window in visual studio

error while installing team explorer

css background image and app_theme confusion

masterpage declartion in web.config

where to get and access website administration tool in my computer.

css validation: 'position' is not a valid css property name - on aspx page

repairing visual studio: how does it affect...

customize precompilation (add post-build event)

adding a seperate page for code

how to show web form designer generated code

using vs 2003 projects with vs 2005

vs and sourcesafe and lengthy check-out

what is the function of all the .xsd files in the folder c:\documents and settings\#username#\application data\microsoft\visualstudio\8.0\reflectedschemas

custom control

how could i totally disable vs2005 auto formating feature for html/aspx files?

visual sourcesafe 6.0 hangs when opening project in vs2005

aspnet_regiis in deployment projects

server explorer disappeared

pos program

where is the crystal report viewer control ??

edit and continue: works at home but not at the office

audio video chat application

'system.windows.forms.datagridview' does not contain a definition for 'item'

website admin tool

wierd vb.net - problem with "import" statement not working

microsoft visual web developer 2005 for asp 1.1?

suppressing all the html errors which prevents from viewing the design view
   
  Privacy | Contact Us
All Times Are GMT