connecting mysql with vb6
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
# 1 Re: connecting mysql with vb6
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;
# 2 Re: connecting mysql with vb6
thank u sir
mysql server is provided by yahoo
its not connecting its giving error cannot found mysql server on server name
plz help
# 4 Re: connecting mysql with vb6
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
# 5 Re: connecting mysql with vb6
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 (http://help.yahoo.com/help/sbc/store/edit/sitebuilder/sitebuilder-19.html)
Good luck,
