Re: mysql connection with VB

2002-09-06 Thread Gelu Gogancea
Hi, If you don't wish to use ODBC you can try GMySQL Type Library(Extension library for libmysql.dll).Interface between VB or VBA and MySQL API functions. You can download it from : http://www.a1vbcode.com/app.asp?ID=1764 or http://www.simtel.net/pub/pd/59731.html Regards, Gelu

RE: mysql connection with VB

2002-09-06 Thread Ben Joyce
If you're in VB and want to connect to a mySQL database then why not use myODBC? it's what it's there for. A simple connection string would be: strConnectionString="DRIVER={MySQL}; SERVER=server; DATABASE=database; UID=username; PWD=password;" To access and manipulate the data use ADO: