odbc

  • Thread starter Thread starter GS
  • Start date Start date
G

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.
 
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.
Click to expand...


Does the database support ODBC?

If it does - use the .NET ODBC provider (System.Data.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
 
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?
 
Just do it, it is easy,

:-)

Cor

GS said:
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?
Click to expand...
 
Back
Top