[freetds] Domain Auth to MS SQL - PHP/FreeTDS 0.61

MAURICIO, LAURA D. (JSC-SM) (MEI) laura.d.mauricio1 at jsc.nasa.gov
Mon Apr 4 18:01:06 EDT 2005


Hello,

I was reading the thread at
http://lists.ibiblio.org/pipermail/freetds/2003q3/013729.html and would like
to know what the outcome was. I'm having the same problem: I can connect via
TSQL but not from php. I used the putenv
("TDSDUMPCONFIG=/tmp/dumpconfig.log"); statement you suggested and the log
file isn't even created after calling the php page. In php page, I get the
error "...SQL error: [iODBC][Driver Manager]Driver's SQLAllocEnv()
failed..."

Notes:
1. We had to rebuild freeTDS package with option "configure
--disable-libiconv" because it was giving us errors.
2. We don't have the file /usr/lib/libtdsodbc.so; instead we're using
/usr/lib/libtds.so
3. Finally, we rebuilt freeTDS like ./configure --with-iodbc=/usr/local/lib
--disable-libiconv. And there was an error: the file isql.h was not found.

Questions:
1. Do we need to use --with-iodbc=/usr/local/lib? If so, where is the file
isql.h supposed to be? We even copied the file to where it was looking for
it - no luck!
2. In my odbc.ini file (attached), do I need to specify libtdsodbc.so as the
driver instead? If so, why don't we have that file and how to get it?
3. In my test-odbc.php file (attached), do I need to use DSN=dsnname (line
14, 15) in the connection string? If I use that, the error is "Data source
name not found and no default driver specified"

I'd really appreciate any help. I'm very new to Unix

Thanks in advance,

Laura Mauricio




-------------- next part --------------
A non-text attachment was scrubbed...
Name: odbc.ini
Type: application/octet-stream
Size: 254 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050404/0800dc12/odbc.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: freetds.conf
Type: application/octet-stream
Size: 4113 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050404/0800dc12/freetds.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.php
Type: application/octet-stream
Size: 2242 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050404/0800dc12/test.obj


More information about the FreeTDS mailing list