The end result I need is that I need to be able to connect to a MSSQL
server on a WinNT box from perl on my linux box. If someone can help me
make this happen, I'll buy you lunch (if you aren't in Austin, TX, I'll
send you a gift certificate). Here is what I currently have:
I have installed unixodbc 2.0.6 and freetds 0.50 on my linux 2.2.17
system. I have created the following entry in /usr/local/etc/odbc.ini:
[TEST]
Driver=/usr/local/lib/odbc-i02.so
Server=mssql.mydomain.com
User=myuser
Pass=mypass
Database=testdb
Majorver=4
Minorver=2
ConnectTimeout=30
Trace=Yes
TraceFile=/tmp/odbc-mssql
If I run 'isql TEST' from the command line (isql is a command line
sql interpreter that comes with unixodbc), I am able to issue queries
and get correct response from the MSSQL server at mssql.mydomain.com.
THIS MEANS THAT MY ODBC IS INSTALLED CORRECTLY!
The entry above logs to /tmp/odbc-mssql. If I run the isql command,
issue one query, and then exit, this file contains:
[Inline TDS
Driver][/development/src/odbc/SQLConnect.c][/development/src/odbc/SQLConnect.c][89]SQL_SUCCESS
[Inline TDS
Driver][/development/src/odbc/SQLGetInfo.c][/development/src/odbc/SQLGetInfo.c][12]handle
= $0804FA58
[Inline TDS
Driver][/development/src/odbc/SQLAllocStmt.c][/development/src/odbc/SQLAllocStmt.c][15]handle
= $0804FA58
[Inline TDS
Driver][/development/src/odbc/SQLDisconnect.c][/development/src/odbc/SQLDisconnect.c][7]handle
= $0804FA58
So, I am ready for ODBC for perl. I install ODBC 0.28, and run the
following script (the query is the same one I executed from isql):
#!/usr/bin/perl
use DBI;
$query = "SELECT acctid,company FROM account";
#DBI->trace;
$db = DBI->connect("DBI:ODBC:TRACK") or die $DBI::errstr;
$h = $db->prepare($query);
$h->execute;
$save = $count = $h->rows;
while($count > 0)
{
@row = $h->fetchrow;
$row = join("|",@row);
print "$row\n";
}
$h->finish;
$db->disconnect;
I get the following error:
DBD::ODBC::st execute failed: [unixODBC][Driver Manager]Data source name not found,
and no default driver specified (SQL-IM002)(DBD:
describe/SQLColAttributes/SQL_COLUMN_LENGTH err=-1) at ./test2.pl line 11.
DBD::ODBC::db disconnect failed: (DBD: db_disconnect/SQLDisconnect err=-1) at
./test2.pl line 20.
It claims that it could not find the DSN. Several points:
1. I removed /tmp/odbc-mssql before running this script. This file is back,
which indicates to me that it _is_ finding the DSN. How else would it know
where to write the trace?
/tmp/odbc-mssql:
[Inline TDS
Driver][/development/src/odbc/SQLConnect.c][/development/src/odbc/SQLConnect.c][89]SQL_SUCCESS
[Inline TDS
Driver][/development/src/odbc/SQLGetInfo.c][/development/src/odbc/SQLGetInfo.c][12]handle
= $08181E28
[Inline TDS
Driver][/development/src/odbc/SQLSetConnectOption.c][/development/src/odbc/SQLSetConnectOption.c][10]handle
= $08181E28
[Inline TDS
Driver][/development/src/odbc/SQLEndTran.c][/development/src/odbc/SQLEndTran.c][43]SQL_SUCCESS
[Inline TDS
Driver][/development/src/odbc/SQLSetConnectOption.c][/development/src/odbc/SQLSetConnectOption.c][58]SQL_SUCCESS
[Inline TDS
Driver][/development/src/odbc/SQLSetConnectOption.c][/development/src/odbc/SQLSetConnectOption.c][10]handle
= $08181E28
[Inline TDS
Driver][/development/src/odbc/SQLSetConnectOption.c][/development/src/odbc/SQLSetConnectOption.c][58]SQL_SUCCESS
[Inline TDS
Driver][/development/src/odbc/SQLAllocStmt.c][/development/src/odbc/SQLAllocStmt.c][15]handle
= $08181E28
[Inline TDS
Driver][/development/src/odbc/SQLDisconnect.c][/development/src/odbc/SQLDisconnect.c][7]handle
= $08181E28
[Inline TDS
Driver][/development/src/odbc/SQLDisconnect.c][/development/src/odbc/SQLDisconnect.c][14]SQL_ERROR
Active Statements exist. Can not disconnect.
2. If it could not find the DSN, why did the ODBC manager report so many
successful lines?
3. If it could not find the DSN, then why did ODBC fail on the handle->execute
instead of the DBI->connect? I do check the return of DBI->connect, after all.
I have tried many variations including setting ODBCHOME and DBI_DSN in
the environment, but always have basically the same problem.
--
"There is no hook, my friend. Jack McKinney
There is only what we do." [EMAIL PROTECTED]
-Doc Holiday, Wyatt Earp (1994) http://www.lorentz.com
1024D/D68F2C07 4096g/38AEF076
PGP signature
