odbc

14 Oct 2006 6:45 AM

GS

I would like to connect to a third part database. I know the datasourcename
and even know the location of the dll that can serve the database, .

what is the best way for an vb.net ( 2005 express wit .net2) application to
access that odbc DB.

14 Oct 2006 7:59 AM

Spam Catcher

"GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> wrote in
news:#Altkx17GHA.4776@TK2MSFTNGP02.phx.gbl:

> I would like to connect to a third part database. I know the
> datasourcename and even know the location of the dll that can serve
> the database, .
>
> what is the best way for an vb.net ( 2005 express wit .net2)
> application to access that odbc DB.

Does the database support ODBC?

If it does - use the .NET ODBC provider (System.Data.ODBC).

14 Oct 2006 1:50 PM

rowe_newsgroups

I know you said you already knew your DSN, but this sight might help
others who browse this thread:

www.connectionstrings.com

Thanks,

Seth Rowe

Spam Catcher wrote:
Show quoteHide quote

> "GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> wrote in
> news:#Altkx17GHA.4776@TK2MSFTNGP02.phx.gbl:
>
> > I would like to connect to a third part database. I know the
> > datasourcename and even know the location of the dll that can serve
> > the database, .
> >
> > what is the best way for an vb.net ( 2005 express wit .net2)
> > application to access that odbc DB.
>
>
> Does the database support ODBC?
>
> If it does - use the .NET ODBC provider (System.Data.ODBC).

14 Oct 2006 5:01 PM

GS

thank you all very much
Show quoteHide quote

"GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> wrote in message
news:%23Altkx17GHA.4776@TK2MSFTNGP02.phx.gbl...
> I would like to connect to a third part database. I know the
datasourcename
> and even know the location of the dll that can serve the database, .
>
> what is the best way for an vb.net ( 2005 express wit .net2) application
to
> access that odbc DB.
>
>

14 Oct 2006 5:48 PM

Cor Ligthert [MVP]

GS,

Try to avoid ODBC it is in my opinion from the previous century, therefore
use the link as Seth (rowe) gave you and use if possible a special provider
and otherwise OleDb, I write this because I am less hesitating.

http://www.connectionstrings.com/

Cor

Show quoteHide quote

"GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
news:%23Altkx17GHA.4776@TK2MSFTNGP02.phx.gbl...
>I would like to connect to a third part database. I know the datasourcename
> and even know the location of the dll that can serve the database, .
>
> what is the best way for an vb.net ( 2005 express wit .net2) application
> to
> access that odbc DB.
>
>

14 Oct 2006 6:44 PM

GS

Thank you, Cor.

I guess that I will use OleDbDataAdapter, OleDbConnnection...along with
binding navigator etc. In a quick glance on the built-in help, it does
support procedure call- that is great.

It is also rich in functionalities and features; so rich it is a tad
overwhelming.

I guess I just have to search some more.

I have just learned enough on the sql express side for updating simple small
table with navigator ....

Any hint on linking multiple datagridview for related tables
(master-details...) with user specified criteria?

Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:utPfKj77GHA.4572@TK2MSFTNGP02.phx.gbl...
> GS,
>
> Try to avoid ODBC it is in my opinion from the previous century, therefore
> use the link as Seth (rowe) gave you and use if possible a special
provider
> and otherwise OleDb, I write this because I am less hesitating.
>
> http://www.connectionstrings.com/
>
> Cor
>
>
> "GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
> news:%23Altkx17GHA.4776@TK2MSFTNGP02.phx.gbl...
> >I would like to connect to a third part database. I know the
datasourcename
> > and even know the location of the dll that can serve the database, .
> >
> > what is the best way for an vb.net ( 2005 express wit .net2) application
> > to
> > access that odbc DB.
> >
> >
>
>

14 Oct 2006 8:59 PM

Cor Ligthert [MVP]

Just do it, it is easy,

:-)

Cor

Show quoteHide quote

"GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
news:%23NsYcD87GHA.3396@TK2MSFTNGP04.phx.gbl...
> Thank you, Cor.
>
> I guess that I will use OleDbDataAdapter, OleDbConnnection...along with
> binding navigator etc. In a quick glance on the built-in help, it does
> support procedure call- that is great.
>
> It is also rich in functionalities and features; so rich it is a tad
> overwhelming.
>
> I guess I just have to search some more.
>
> I have just learned enough on the sql express side for updating simple
> small
> table with navigator ....
>
> Any hint on linking multiple datagridview for related tables
> (master-details...) with user specified criteria?
>
> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
> news:utPfKj77GHA.4572@TK2MSFTNGP02.phx.gbl...
>> GS,
>>
>> Try to avoid ODBC it is in my opinion from the previous century,
>> therefore
>> use the link as Seth (rowe) gave you and use if possible a special
> provider
>> and otherwise OleDb, I write this because I am less hesitating.
>>
>> http://www.connectionstrings.com/
>>
>> Cor
>>
>>
>> "GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
>> news:%23Altkx17GHA.4776@TK2MSFTNGP02.phx.gbl...
>> >I would like to connect to a third part database. I know the
> datasourcename
>> > and even know the location of the dll that can serve the database, .
>> >
>> > what is the best way for an vb.net ( 2005 express wit .net2)
>> > application
>> > to
>> > access that odbc DB.
>> >
>> >
>>
>>
>
>