Hi there,

So ur DSN is 'MySql' instead of 'test', right?

Further gretl won't import string values (names). And as far as I remember there isn't an automatic conversion. So u probably need another SQL query.

Cheers
Leon

Am 13.10.2013 um 17:21 schrieb "juergen.malitte@t-online.de" <juergen.malitte@t-online.de>:

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 

 

 

_______________________________________________
Gretl-users mailing list
Gretl-users@lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users