Dear Y'all -
Well, I'm pretty giddy having just gotten my linux box to successfully
communicate with M$ SQL Server on a remote NT machine. As promised,
in gratitude for earlier help from list members I've written this
e-mail outlining how I got it to work.
The real trick was to follow the instructions I found on the web at:
http://www.phpbuilder.com/columns/alberto20000919.php3
Alberto Dainotti does a very thorough job of explaining the issues.
Including an extremely clear description of ODBC which until I read
his I never really understood. (It's a layer of indirection to
insulate applications from the DBMS exactly like perl's DBI. I wish
somebody had told me that about 5 years ago.)
Once I read his paper I made my way to www.freetds.org downloaded the
snapshot followed the instructions in the INSTALL file using:
./configure --with-tdsver=7.0 --enable-msdblib
Edit the /usr/local/freetds/interfaces file, setup the
SYBASE... environment variables, edit the PWM file in the directory
where I built everything (heretofore $BUILD_DIR) run the tests and get:
t0001.c: Testing login, logout
PASS: t0001
t0002.c: Test basic submit query, results
PASS: t0002
t0003.c: Testing DB change -- 'use tempdb'
PASS: t0003
t0004.c: Test large (>512 bytes) queries
PASS: t0004
t0005.c: Test large (>512 bytes) replies
PASS: t0005
t0006.c: Test SYBREAL, SYBFLT8 values
PASS: t0006
==================
All 6 tests passed
==================
The only off-colour thing I had to do was overwrite the file
$BUILD_DIR/src/tds/libtds.la with /usr/local/freetds/lib/libtds.a to
get the tests to compile.
Thanks again for the earlier help.
Yours - Billy
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
