Connection fault to mySQL Database
by 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(a)t-online.de [1]
Links:
------
[1] mailto:juergen.malitte@t-online.de
