Re: DSN

2001-04-06 Thread role+mysql-readers
HN> How can I set a datasource name (DSN) for a database in MySQL? Get MyODBC for the platform where you want the DSN available, then enter the MySQL server & database details for a "machine DSN" using your ODBC administration facilities on the platform where you want the DSN to be available. Ho

Re: beggin, commit, and rollback

2001-04-05 Thread role+mysql-readers
KB> Doesn't mysql support begin and rollback transactions? I *believe* it went like this -- syntax supported and returned success without doing anything in older versions, then functionality was actually *implemented* more recently -- maybe only most recent stable release? (v3.23)

Re[2]: Converting Access to MySQL

2001-04-04 Thread role+mysql-readers
L> Ok i'm still a little bit lost. I have a database in MySQL called "irm" L> In the ODBC Data Source 32 bit I went in user dsn and added user data source L> called irm the driver is mysql L> not this is were i dont understand . L> In the field that says Windwos DSN name I put "irm" L> MySQL I

Re[2]: Converting Access to MySQL

2001-04-04 Thread role+mysql-readers
HHG> You must go to control panel of windows in Data Sources(ODBC) section and add your DSN of you new MySQL database and then you can explor the database by browsing your ODBC avilable databases . HHG> You can check MyODBC manual for this . Yes, this worked for me too. However ... I can only

Re[2]: [couldn't connect to the mysql server]

2001-04-03 Thread role+mysql-readers
U> Hi, U> I did the binary installation. Yes, I restarted and checked again, U> it shows same. The other thing to check is permissions on the directory / sock file for the user that you're logged-in as. Are you logged-in as the same user as yesterday? U> Regds U> Ujwol U> - Original Messa