Fournisseur +vb6

nones Messages postés 80 Date d'inscription   Statut Membre Dernière intervention   -  
phil232 Messages postés 607 Date d'inscription   Statut Membre Dernière intervention   -
Bonjour,
je veut savoir le fournisseur qu'il faut utiliser dans une application vb6 pour se connecter à une base mysql.
qq peut m'aider????????????

1 réponse

phil232 Messages postés 607 Date d'inscription   Statut Membre Dernière intervention   178
 
http://databases.aspfaq.com/database/what-should-my-connection-string-look-like.html


MySQL

MySQL.com used to have a download available for an OLEDB provider to MySQL (MyOLEDB):

<%
cst = "Provider=MySQLProv;" & _
"Data Source=<x.x.x.x>;" & _
"Database=<dbname>;" & _
"User Id=<uid>;" & _
"Password=<pwd>"
%>

However, it has gone missing in recent months. If you don't have the OLEDB provider, you will need to use ODBC. You can try these connection strings (depending on whether you have MySQL ODBC or MyODBC drivers installed):

<%
cst = "Driver={MySQL};" & _
"Server=<x.x.x.x>;" & _
"Database=<dbname>;" & _
"Uid=<uid>;" & _
"Pwd=<pwd>"

cst = "Driver={MySQL ODBC 3.51 Driver};" & _
"Server=<x.x.x.x>;" & _
"Database=<dbname>;" & _
"Uid=<uid>;" & _
"Pwd=<pwd>;"
%>

You can download Windows MyODBC drivers here.
0