VB & MySQL......system DSN....
Hi Andre,
I dont know how I missed mentioning the platform i work on. Sorry abt that! I work on VB6 with Windows 95/NT .....95 mainly.
I ran:
REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL" .........
and I think my program is on the way to working.....my Internet connection was down during the afternoon(my time) and so I couldn't test it. Will let u know if it works. Thanks a lot.
Here's how I created a system DSN:
Start-->Settings-->Control Panel-->ODBC32
I then went to the System DSN tab and clicked on Add. I then selected MySQl driver and clicked Finish.
I was prompted for the:
DSN name,
server name,
database,
user,
password,
port,
options.
Of these I left password, port and options blank.
Hope this was what u wanted to know.
Thanks again.
[Edited by rammy on 04-07-2000 at 12:07 AM]