[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SchemeQL



MJ Ray <markj@cloaked.freeserve.co.uk> writes:

Hello,

> Everything appears to be running happily until I try
> (define dbase (connect-to-database "localhost" "markj ""))
> and it just sits there until I break it.

Do this shows something useful,

(with-handlers
 ([general-sql-error? (lambda (x)
			(printf "~a~n" (general-sql-error-diagnostics x)))])
 (connect-to-database dbms login passwd))

? What DBMS are you using? MySQL? PostgreSQL?  the problem might be
an odbc-version compatibility:

I am using MySQL + MyODBC + iodbc.lib, and:

(define odbc-version 2.5)
(require-library "schemeql.ss" "schemeql")
...

works just fine.  I haven't used unixODBC in a long time, but maybe it
has a test program or something (iodbc has one: odbctest), and it
would be a good idea to make sure is working correctly.  Having the
ODBC driver running is 90% of the job, the other 10% is compiling
SrPersist, but I take it you have already done this, right?

MyODBC also requires an "odbc.ini" file with information about the
driver, host, port, etc., and it usually goes in /etc, or /usr/local/etc.

HTH,
Francisco

-- 
Perl - The only language that looks the same before and after RSA encryption. 
-Keith Bostic