Hi, I am newbie to this mailing list. Please spare me if my question is too
silly. I did search the archive but cannot find the information I need.
I downloaded DataDirect Connect ODBC yesterday and installed on my Redhat
Linux 6.1. I then installed DBI-1.15 and DBD:ODBC 0.28. I tested
successfully DBD:ODBC with Openlink before. But when I re-install it for
DataDirect, "make test" failed and indicated a required shared library isn't
installed successfully. When I tried to connect to SQL Server database in
perl script like:
my $dbHandle = DBI->connect('dbi:ODBC:direct_test7', 'sa', 'mypassword')
I got a error message of:
perl: error in loading shared libraries:
/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so: undefined
symbol: SQLAllocEnv
I suspect something not setup right. I checked their online book. It
mentioned that I need setup LD_LIBRARY_PATH to include both "dynamic link
libraries" and "Database client library".
http://www.intersolv.com/products/datadirect/download/docs/odbc/Odbcref/rsta
rt.htm#509872
<http://www.intersolv.com/products/datadirect/download/docs/odbc/Odbcref/rst
art.htm#509872> I got lost here. To me, both of them are the same in my
machine: /opt/odbc/lib. I used /opt/odbc/bin/ivtestlib ivmsss16.so (for load
SQL Server driver) and it's successful. Did I missed something here? I
remember someone mentioned "SequeLink", but I cannot find Linux version.
We successfully connect SQL Server from Linux with DBD:ODBC with Openlink
driver, but it cannot insert and retrieve big chunk of "text" type of data.
Is any one successfully handle the big size (say 300,000 bytes) text in SQL
Server by DBD:ODBC with any of the ODBC driver?
Thanks a lot for your help. I really appreciate it.
Guangzu
