Path: news.cs.au.dk!not-for-mail From: Klaus Marius Hansen Newsgroups: comp.lang.beta Subject: Re: Beta/Mjolner versus Relational Databases Date: Sun, 10 Jan 1999 12:08:26 +0100 Organization: University of Aarhus, Department of Computer Science (DAIMI) Lines: 42 Message-ID: <36988A2A.8CF5E3FF@cs.au.dk> References: <19990109132325.6157.qmail@noatun.mjolner.dk> NNTP-Posting-Host: carls.cs.au.dk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: xinwen.cs.au.dk 915966557 13319 255.255.255.255 (10 Jan 1999 11:09:17 GMT) X-Complaints-To: news@cs.au.dk NNTP-Posting-Date: 10 Jan 1999 11:09:17 GMT X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: da,en Xref: news.cs.au.dk comp.lang.beta:11784 I have - thanks to Jean-Louis's script - made a Mjolner R4.1 version of BetaDBC. It may be found at http://www.cs.au.dk/~marius/download/betadbcr41.zip This version also does not throw an exception in case 2 below. Instead a more appropriate warning is issued. Regards, Klaus Jean-Louis Leroy wrote: > > 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/ -- /Marius Mirabile est quod omnibus insciis tantas nugas latine scriptitare possum