By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,684 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,684 IT Pros & Developers. It's quick & easy.

ODBC .Net

P: n/a
I'm trying to use ODBC to connect to different databases in VB.NET I know
there is a reference I need to add called Microsoft.Data.ODBC.dll but it is
not available on my list of .Net references. I have the .Net Framework 1.1
so I do not understand wht I cannot use ODBC.

What am I doing wrong?

TIA
Darren
Nov 20 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Cor
Hi Darren..
I'm trying to use ODBC to connect to different databases in VB.NET I know
there is a reference I need to add called Microsoft.Data.ODBC.dll but it is not available on my list of .Net references. I have the .Net Framework 1.1
so I do not understand wht I cannot use ODBC.


I think you find your solution easy here

http://www.connectionstrings.com/

I hope this helps a little bit?
Cor
Nov 20 '05 #2

P: n/a
"Darren Gulliver" <gu************@hotmail.com> scripsit:
I'm trying to use ODBC to connect to different databases in VB.NET I know
there is a reference I need to add called Microsoft.Data.ODBC.dll but it is
not available on my list of .Net references. I have the .Net Framework 1.1
so I do not understand wht I cannot use ODBC.


Are you referring to 'System.Data.Odbc'? You can use this namespace by
adding a reference to "System.Data.dll".

--
Herfried K. Wagner
MVP VB Classic, VB.NET
<http://www.mvps.org/dotnet>
Nov 20 '05 #3

P: n/a
No, you need to add: Microsoft.Data.Odbc.dll

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:bm************@ID-208219.news.uni-berlin.de...
"Darren Gulliver" <gu************@hotmail.com> scripsit:
I'm trying to use ODBC to connect to different databases in VB.NET I know there is a reference I need to add called Microsoft.Data.ODBC.dll but it is not available on my list of .Net references. I have the .Net Framework 1.1 so I do not understand wht I cannot use ODBC.


Are you referring to 'System.Data.Odbc'? You can use this namespace by
adding a reference to "System.Data.dll".

--
Herfried K. Wagner
MVP VB Classic, VB.NET
<http://www.mvps.org/dotnet>


Nov 20 '05 #4

P: n/a
Nevermind, I spoke too soon. Sorry.
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:bm************@ID-208219.news.uni-berlin.de...
"Darren Gulliver" <gu************@hotmail.com> scripsit:
I'm trying to use ODBC to connect to different databases in VB.NET I know there is a reference I need to add called Microsoft.Data.ODBC.dll but it is not available on my list of .Net references. I have the .Net Framework 1.1 so I do not understand wht I cannot use ODBC.


Are you referring to 'System.Data.Odbc'? You can use this namespace by
adding a reference to "System.Data.dll".

--
Herfried K. Wagner
MVP VB Classic, VB.NET
<http://www.mvps.org/dotnet>


Nov 20 '05 #5

P: n/a
On Wed, 8 Oct 2003 11:13:58 +0100, "Darren Gulliver" <gu************@hotmail.com> wrote:

I'm trying to use ODBC to connect to different databases in VB.NET I know
there is a reference I need to add called Microsoft.Data.ODBC.dll but it is
not available on my list of .Net references. I have the .Net Framework 1.1
so I do not understand wht I cannot use ODBC.


If it's not in the global assembly cache, try browsing for the file Microsoft.Data.Odbc.dll and add
it through the references dialog.

You could also download and install the component:
http://www.microsoft.com/downloads/d...displaylang=en
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #6

P: n/a
Thank you all for your input.

As I'm running VS2002 v1.1 of the framework is not compatible. Only VS2003
is.

I found a ODBC_Net set up program which makes the Microsoft.Data.ODBC.dll
available. I downloaded this extra driver from
http://www.microsoft.com/downloads/d...displaylang=en

Regards
Darren
"Darren Gulliver" <gu************@hotmail.com> wrote in message
news:eG**************@TK2MSFTNGP12.phx.gbl...
I'm trying to use ODBC to connect to different databases in VB.NET I know
there is a reference I need to add called Microsoft.Data.ODBC.dll but it is not available on my list of .Net references. I have the .Net Framework 1.1
so I do not understand wht I cannot use ODBC.

What am I doing wrong?

TIA
Darren

Nov 20 '05 #7

P: n/a
On Thu, 9 Oct 2003 10:05:51 +0100, "Darren Gulliver"
<gu************@hotmail.com> wrote:

Thank you all for your input.

As I'm running VS2002 v1.1 of the framework is not compatible. Only VS2003
is.

I found a ODBC_Net set up program which makes the Microsoft.Data.ODBC.dll
available. I downloaded this extra driver from
http://www.microsoft.com/downloads/d...displaylang=en


Just an FYI concerning the framework version compatibility issues:

http://www.gotdotnet.com/team/changeinfo/default.aspx
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.