In MySql execute the GRANT command to give the necessary permissions to user@nthost, something like as follows (change the command per your needs, for different options, look up documentation on mysql.com ) GRANT all on *.* to 'username'@'hostname' identified by 'password'. You can use IP too, instead of a hostname Generally, you would want just select, update, insert, delete instead of all & DSN.* instead of *.*, but it depends on you requirements. once you have done that, on the NT end, you will need to configure VB to connect via MyODBC, I am not familiar with VB much, but I have been able to get this done via MS Access so VB should be the same. You will need to configure MyODBC (under system DSN, maybe) to use the correct database name, username and password.
Regards, Bhavin. Regards, Bhavin. ----- Original Message ----- From: "Subhash" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 08, 2002 1:48 AM Subject: Waiting for the solution.. > Dear there, > > I'm Subhash from Bangalore(India). > Can we retrieve the data stored in mySQL database installed on > Linux platform using VB forms installed on WIN-NT. If so > how....? > Kindly help me about this in the earliest..... > > I've also installed the required odbc drivers (MYODBC 3.51) for > Windows by downloading from mysql.com portal. > Still i could'nt connect to it. > > Waiting for your solutions..... > Regards..... > subhash (my email id: [EMAIL PROTECTED]) > _________________________________________________________ > Click below to visit monsterindia.com and review jobs in India or > Abroad > http://monsterindia.rediff.com/jobs > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
