ODBC help needed?

[techker]

hey guys.when i creat a new connection with mysql odbc,that meens that when i export the application the connection is done.right?

so.how to i call that connection?

if i make a button populate data..

and do i have to make a databse in the application the have the 2 databses sinc to update?or i can insert directly in the mysql database with the odbc?

[jmcilhinney]

I'd suggest not using ODBC if you can get away with it. If you want to access MySQL from VB.NET then I'd suggest downloading the Connector/Net ADO.NET provider from the MySQL web site. You can then install the same thing on any target machine or just deploy MySql.Data.dll with your app.

[techker]

true.whats the main concern or odbc?

[jmcilhinney]

ODBC is old and essentially a "lowest common denominator" when it comes to data sources. If there is a specific way to access your data source then that is preferable to ODBC.