On Wed, 04 Jun 2008, John Goerzen wrote:
Prelude Database.HDBC Database.HDBC.ODBC> conn <- connectODBC "dictation"
Please note that this is not a valid connection string.
I need to remember the connection functions are specific to the drivers and there are differences between connectODBC and connectSqlite3.
The HDBC-odbc API docs ... give the example string of: "DSN=hdbctest1" as well as a link to the Microsoft document that describes the string: http://msdn.microsoft.com/en-us/library/ms715433(VS.85).aspx That URL also contains error message descriptions. For your state 01S00, it lists:
Invalid connection string attribute
Your fix may be as simple as prepending the string with "DSN=".
That did the trick. And I can insert and query the database. So HDBC-odbc-1.1.4.4 is good here. -- Dr Bean Make a mistake. Try it, you'll like it. --Dr Bean