ODBC .Net

[Darren Gulliver]

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

[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

[Herfried K. Wagner [MVP]]

"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>

[Jeremy Cowles]

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>

[Jeremy Cowles]

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>

[Paul Clement]

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)

[Darren Gulliver]

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

[Paul Clement]

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)