INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

VS Express 2013 - System.Data.Odbc not supported

VS Express 2013 - System.Data.Odbc not supported

(OP)
Hi,

Does anyone know how to register the ODBC data provider for VS Express 2013? I've got some old applications written in VB.Net 2.5 that have to be upgraded, and whenever I try to configure the ODBC connection I get an error saying that he system.data.odbc provider is not supported.

RE: VS Express 2013 - System.Data.Odbc not supported

(OP)
Thanks for the quick reply. Unfortunately that link doesn't help much. I'm not trying to use an ODBC connection string with an OleDB connection, just trying to create an ODBC connection from the VS GUI.

Here are the problems I'm having:

When I'm in the connection string properties for an ODBC connection that's been dropped onto a form, click "new connection" gives me a pop-up saying "The data provider system.data.odbc is not supported"

When I go to Data Sources to create a new source, the only data source types that are available are MS Access, MS SQL Server, MS SQL Server Database File, and Other. Selecting "other" only gives me SQL Server and OLEDB as options for the data provider.

I can add, configure and open/close an ODBC connection at run time, (below), but can't do it in the GUI. I'm trying to add new fields to the DataSets and DataGridViews, so being able to connect programmatically doesn't help in this case.

CODE

' this works fine
Dim O As New System.Data.Odbc.OdbcConnection

O.ConnectionString = "Dsn=Micros;uid=custom;pwd=custom"

O.Open()
O.Close() 

RE: VS Express 2013 - System.Data.Odbc not supported

Someone else may have had a similar issue. Two places that I check for this are Visual Studio Gallery to see if there is a VS extension (or AddIn) that does this and CodeProject to see if anyone has written an article to solve the problem. 80% of the time I have found a solution.

RE: VS Express 2013 - System.Data.Odbc not supported

Sorry I've just noticed that you are using VS Express 2013. That won't accept AddIns and /or extensions.

However VS2013 Community and VS2015 Community are both free and are equivalent to a slightly reduced version of VS 2013/2015 Pro. They both accept extensions (although some extensions are only available for Pro and above). 2013 Community has a lot more extensions available in the Gallery than 2015.

In this situation I would check the Gallery (search Visual Studio Gallery Online) to see if something has already been done and if so download and intall one of the Community editions.

The Pro and above versions have to have something to encourage us to buy them, so each higher version has more features. The free versions therefore have reduced functionality, but are still eminently usable.

RE: VS Express 2013 - System.Data.Odbc not supported

(OP)
Thanks for all the help. I'll try to upgrade to 2013 Community when I have time. This was kind of a low priority project that I wanted to get done during a few slow days and hadn't expected problems like this.

RE: VS Express 2013 - System.Data.Odbc not supported

Using Community 2013 you can create an ODBC data connection using the Server Explorer window (select Microsoft ODBC Data Source) which is generic and allows to refer to a precreated one.

The reason that it works in code and not through the UI is as I said earlier. You get the .Net libraries in Express but not all are available through the UI, but are in code. Community and above provides them through the UI as well.

Presumably if you decide to remain with Express, you could create a UserControl in which you provide the necessary resources. I've never used Express so I'm not sure but I think you can add your own user controls - then just add it to your ToolBox to use as and when required.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close