[Gretl-users] Connection fault to mySQL Database

Ladies and Gentlemen, I'm working with the theme 'Connections of Gretl to a database with ODBC'. I have installed the Database mySQL. Then I wrote the following little Gretl-script: open dsn=test user=root password=Malitte12 --odbc string Qry = "SELECT Kundenname Kundenort FROM Kunde_Umsatz" data Kd_name Kd_ort query = Qry After starting I get the message: Error in SQLConnect [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben In English: The data source name was not found and it was not declared a standard driver. And further: ? open dsn=test user=Root password=Malitte12 --odbc Failed to connect to ODBC data source 'test' Once another information : I added the ODBC-Driver to windows under (Benutzer-DSN = User DSN with Name: MySQL Datenbankserver Treiber : MySQL ODBC 5.2 Unicode Driver The connection parameters were the following: Data Source Name: MySQL Datenbankserver TCP/IP Server : localhost Port 3306 Named pipe : <nothing> User: root Password : Malitte12 Database : test When I confirmed the Button "Test" the Windows-System tells : "Connection successfull" I thought that is enough to start the skript and beeing successfull, but unfortunately not..... The table "Kunde_Umsatz" is under the schema "test" in mySQL and has two rows. It would be very nice, if you could help me or give an advice. When you wish, I can send a print of the screen. Yours sincerely Jürgen Malitte My Email-adress : juergen.malitte(a)t-online.de [1] Links: ------ [1] mailto:juergen.malitte@t-online.de