odbc

[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.

[Spam Catcher]

Re: odbc

"GS" <gsmsnews.micro soft.comGS@msne ws.Nomail.comwr ote in
news:#Altkx17GH A.4776@TK2MSFTN GP02.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.OD BC).

[rowe_newsgroups]

Re: odbc

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

https://www.connectionstrings.com

Thanks,

Seth Rowe


Spam Catcher wrote:

"GS" <gsmsnews.micro soft.comGS@msne ws.Nomail.comwr ote in
news:#Altkx17GH A.4776@TK2MSFTN GP02.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.OD BC).

[GS]

Re: odbc

thank you all very much
"GS" <gsmsnews.micro soft.comGS@msne ws.Nomail.comwr ote in message
news:%23Altkx17 GHA.4776@TK2MSF TNGP02.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.
>
>

[Cor Ligthert [MVP]]

Re: odbc

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.micro soft.comGS@msne ws.Nomail.comsc hreef in bericht
news:%23Altkx17 GHA.4776@TK2MSF TNGP02.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.
>
>

[GS]

Re: odbc

Thank you, Cor.

I guess that I will use OleDbDataAdapte r, OleDbConnnectio n...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]" <notmyfirstname @planet.nlwrote in message
news:utPfKj77GH A.4572@TK2MSFTN GP02.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.micro soft.comGS@msne ws.Nomail.comsc hreef in bericht
news:%23Altkx17 GHA.4776@TK2MSF TNGP02.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.

>
>

[Cor Ligthert [MVP]]

Re: odbc

Just do it, it is easy,

:-)

Cor

"GS" <gsmsnews.micro soft.comGS@msne ws.Nomail.comsc hreef in bericht
news:%23NsYcD87 GHA.3396@TK2MSF TNGP04.phx.gbl. ..

Thank you, Cor.
>
I guess that I will use OleDbDataAdapte r, OleDbConnnectio n...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]" <notmyfirstname @planet.nlwrote in message
news:utPfKj77GH A.4572@TK2MSFTN GP02.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.micro soft.comGS@msne ws.Nomail.comsc hreef in bericht
>news:%23Altkx1 7GHA.4776@TK2MS FTNGP02.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.
>
>

>>
>>

>
>