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(a)t-online.de" <juergen.malitte(a)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(a)t-online.de
_______________________________________________
Gretl-users mailing list
Gretl-users(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users