[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: SchemeQL problem
> Try schemeql out of CVS.
>
> (I'm the reason the problem is a known one.)
Thanks, will do. I think I found the source of my original problem. If I do
the following I get the same error as I reported with SchemeQL:
(require (lib "srpersist.ss" "srpersist"))
(alloc-handle 'sql-handle-dbc (alloc-handle 'sql-handle-env))
=> Unspecified error in alloc-handle
Reading the ODBC documentation a bit I found calling set-env-attr on an henv
first can resolve the problem in my case:
(require (lib "srpersist.ss" "srpersist"))
(define x (alloc-handle 'sql-handle-env))
(set-env-attr x 'sql-attr-odbc-version 'sql-ov-odbc3)
(alloc-handle 'sql-handle-dbc x)
=> #<sql-hdbc>
Does SchemeQL need to do this set-env-attr for me, or is there some way of
me enabling it to do that?
The notes from the help desk on srpersist say:
"Before using `alloc-handle' to create a connection handle, you may
need to call `set-env-attr' with 'sql-attr-odbc-version and
'sql-ov-odbc3 as arguments."
Chris.