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@t-online.de