Path: news.cs.au.dk!not-for-mail
From: Jean-Louis Leroy <jll@skynet.be>
Newsgroups: comp.lang.beta
Subject: Re: Beta/Mjolner versus Relational Databases
Date: 9 Jan 1999 13:23:25 -0000
Organization: Starfleet
Lines: 26
Approved: mailtonews@cs.au.dk
Distribution: world
Message-ID: <19990109132325.6157.qmail@noatun.mjolner.dk>
Reply-To: Jean-Louis Leroy <jll@skynet.be>
NNTP-Posting-Host: daimi.cs.au.dk
X-Trace: xinwen.cs.au.dk 915888268 8704 255.255.255.255 (9 Jan 1999 13:24:28 GMT)
X-Complaints-To: news@cs.au.dk
NNTP-Posting-Date: 9 Jan 1999 13:24:28 GMT
Xref: news.cs.au.dk comp.lang.beta:11781

Hello Klaus,

I got betadbc to work, thanks again.

I encountered the following problems in the process, I thought you will be 
interested to know about them. 

I'm using MS SQL Server 6.5 with ODBC Server 2.65.240.

1) Since I'm using the current public release I had to patch the .bet files 
to insert version numbers in the path to the standard libraries. In case 
anobody wants it, I can send you the Perl script I used.

2) executesqlfile died on an exception; the information reported by ODBC 
was "Changed context to 'master'". I removed the test for SQL_SUCCESS in 
ConnectionOpen and found out that the connection *was* open, although it 
was not SQL_SUCCESS that was returned. I vaguely remember seeing a report 
on incorrect behavior by some versions of the MS-SQL ODBC driver. Yet, I 
can open the database via Perl+DBI+DBD/ODBC.

3) MS SQL Server doesn't know the SQL type 'BOOLEAN'; I replaced it with 
'BIT'.

Jean-Louis Leroy
http://ourworld.compuserve.com/homepages/jl_leroy/