_Please_ excuse my ignorance on this subject!
In order to connect to MS SQL Server from my NetBSD box, will I still need the 'ODBC
to ODBC Bridge' software with this driver?
Is the free version of said package, which is limited to 'a single connection' going
to work for anything more than testing?
There was talk of a nstdsdb module from [EMAIL PROTECTED] Would this allow direct
access to an MS SQL Server box from my NetBSD box?
Thank you!
By the way, I have started looking at the difficulty involved in migration from SQL
Server to PostgreSQL and it is only ugly at the Stored Procedure -> Function level. I
stayed away from SP that return tuples, but use cursors extensively, so they would
need major rewrites. On the plus side, I am going to rewrite them all in pl/Tcl!
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 05/02/01 03:02PM >>>
I've taken Rob Mayoff's DB2 driver, and made it ODBC 3.0 compliant.
The benefits of this driver over the standard nsodbc module are:
1. Works with fields greater than 8192 chars in length
2. Max field size is settable on a per aolserver process level
3. autocommit is turned off, making transactions easier to
create within your application
4. supports bind variables (Rob built various commands
to handle input lists of variables and filenames -- this has
been borrowed but untested.)
5. hooks for better support of lobs.
DB/2 automatically could load/store lobs from files. Those hooks
are in the code but have been disabled. I intend to write ODBC 3
compliant versions of the lob <--> file support in the driver.
You can download the driver at:
http://downloads.hollyjerry.org:16080/files/aolserver3.2/odbc2.tar
It's very experimental at the moment. It should have the same performance
characteristics as the DB2 driver and the old nsodbc module. So enjoy, and
please let me know how it
works.
Jerry Asher
=====================================================
Jerry Asher [EMAIL PROTECTED]
1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980
Berkeley, CA 94709 Fax: (877) 311-8688
