At 08:45 AM 4/27/01 -0700, you wrote:
>I am moving my web server from NT to NetBSD and will need to connect to
>SQL Server until I migrate the database to PostgreSQL. I just last night
>started tinkering with unixODBC, and found that you need to install some
>kind of ODBC to ODBC bridge product on both the Win32 box and the *nix box
>to access SQL Server databases. Is this correct? It seems like a
>monumental kludge. Is this what you are using?
>
>I am using nsodbc on my NT installation of aolserver right now and it
>works wonderfully. I don't have any blobs or big text fields, so if the
>8k limit applies, I have not run into it.
>
>Any advice you can give me on setting up access to SQL Server database
>from a *nix box would be appreciated...
It might be a kludge, I can't tell yet.
I am evaluating the easysoft product at the moment. Okay documentation,
but there are a few traps. Install the NT ODBC Bridge Server and start it
up. (They'll do that for you automatically.)
Install the *nix easysoft client.
Modify /etc/odbc.ini to include any of your odbc connections defined on
your nt box. Then confirm basic connectivity by using their version of isql.
Once you can use isql from your *nix box you're 85% of the way there.
The rest is AOLserver.
You'll need to recompile and relink nsodbc against easysoft's include files
and libraries. I just dragged the sql.h and sqlext.h and the other include
files into my nsodbc directory (as I was too lazy/ignorant to type "man
gcc" and figure out the right switch. So then I had to modify the #include
statement in nsdobc.c.
Here's a magical incantation on linux to recompile and relink nsodbc
cc -I/usr/local/easysoft/oob/client/include -D_REENTRANT -pthread -g
-I../include -D_REENTRANT -pipe -fPIC -Wall -Wno-unused -DHAVE_CMMSG=1
-DUSE_FIONREAD=1 -DHAVE_COND_EINTR=1 -c nsodbc.c -o nsodbc.o
gcc -shared -nostartfiles -o nsodbc.so nsodbc.o -L /usr/local/easysoft/lib
-L/usr/local/easysoft/oob/client -lesoobclient_r -lesrpc_r -lessupp_r
-lesextra
once this is done, all you need to do is configure a new data pool to use it.
Enjoy!
Jerry
=====================================================
Jerry Asher [EMAIL PROTECTED]
1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980
Berkeley, CA 94709 Fax: (877) 311-8688
