Re: [Gretl-users] Gretl-users Digest, Vol 39, Issue 22
On Wed, 21 Apr 2010, Stefan Rehm wrote:
Jack (on ODBC connection):
> You're halfway through. The "open" command
establishes the connection.
> The actual data retrieval is a job for the "data" command, which stores
> the output of an SQL query. Example:
>
> <script>
> qry = "select foo from bar"
> data myseries query=qry --odbc
> </script>
Hmm, no chance. There is no message after the open command. So i'm not
shure if everything work fine.
Apparently it's not fine. If it is, you should get a message from
gretl:
Connected to ODBC data source <source>
If the connection can't be made you're supposed to get an
informative error message back from the SQL server. I just tried
provoking a couple of errors on my system: issuing an --odbc
"open" command with no SQL daemon running, and then, with MySQL
running, issuing the open command with an invalid dsn name. In
these cases I got reasonably informative error messages, e.g.
[unixODBC][Driver Manager]Data source name not found
I'm not sure why you're getting no message, but I'll take a look
at the code and see if there are error modes that might explain
that.
Allin Cottrell