Fournisseur +vb6

nones Messages postés 80 Statut Membre -  
phil232 Messages postés 610 Statut Membre -
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 610 Statut Membre 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