connecting mysql with vb6

[gsreejit_79]

sir
i am using vb6 with access, but now i want to migrate to mysql on remote server.Can i connect to mysql without using odbc , or if i use ODBC and make a package and install it in other system will dsn be created there.
plz help
thanks in advance

Bye
sreejit

[Phil Weber]

You can connect to MySQL via ODBC without creating a DSN. Your ADO connection string should look like this:

driver={mysql}; database=yourdatabase;server=yourserver;uid=username;pwd=password;option=16386;

[gsreejit_79]

thank u sir
mysql server is provided by yahoo
its not connecting its giving error cannot found mysql server on server name
plz help

[Phil Weber]

Have you asked Yahoo? What did they say?

[gsreejit_79]

yes i had asked yahoo, they said there server does not support third party access.Now what should i do. plz suggests, if there is any other way to access the mysql db. or any other server which provide free or ecnomic mysql server with ip support access.

if anyone know abt it plz let me know

thanks in advance.
sreejit

[msanchez]

Is the site you are speaking of a Yahoo! Merchant Solutions site for a Yahoo! store? I ask because the database used for their catalog and inventory managers can only be accessed by the web-based UI they provide.

To add more features and dynamism to your site, they do include a MySQL database that you can use and access via PHP or PERL. This is a separate database for your own use within the site.

See the section called "MySQL, PHP, and Perl" at the following URI,
http://help.yahoo.com/help/us/store/site/

As an alternative, they do offer the data from the catalog manager in XML format for your own custom reporting. You could call this file and parse it for your own needs.

Export Yahoo! DB to XML

Good luck,