FreeTDS Development Group

[Dave Dumaresq <ddumaresq AT bccampus.ca>]

Hello, I'm not sure where to post this.

I am building unixodbc and freetds in cygwin. I have freetds  
connecting to a MS-SQL server, as demonstrated with tsql. I've tried  
this with both the stable version of freetds (0.82) and the RC (0.91).

When I try running isql, I get the error:

$ isql dsn_bccampus MyUid MyPWD -v

[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/freetds/ 
lib/libtdsodbc.a' : Access is denied.
[ISQL]ERROR: Could not SQLConnect

odbcinst.ini
[FreeTDS]
Driver=/usr/local/freetds/lib/libtdsodbc.a

[ODBC]
Trace        = Yes
TraceFile    = /tmp/sql.log
ForceTrace   = Yes

odbc.ini
[dsn_bccampus]
Driver=FreeTDS
Server=ned.bccampus.ca
Port=9466
User=ddumaresq
Password=dd917bcc
Language=
Database=ldap
logging=1
logfile=/tmp/dsn_bccampus.log


sql.log
[ODBC][7236][1307563457.883000][__handles.c][459]
                Exit:[SQL_SUCCESS]
                        Environment = 0x8849b8
[ODBC][7236][1307563457.884000][SQLAllocHandle.c][375]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x8849b8
[ODBC][7236][1307563457.885000][SQLAllocHandle.c][493]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x8adb50
[ODBC][7236][1307563457.885000][SQLConnect.c][3654]
                Entry:
                        Connection = 0x8adb50
                        Server Name = [dsn_bccampus][length = 12 (SQL_NTS)]
                        User Name = [ddumaresq][length = 9 (SQL_NTS)]
                        Authentication = [********][length = 8 (SQL_NTS)]
[ODBC][7236][1307563457.893000][SQLConnect.c][1106]Can't open lib '/ 
usr/local/freetds/lib/libtdsodbc.a' : Access is denied.
[ODBC][7236][1307563457.894000][SQLError.c][434]
                Entry:
                        Connection = 0x8adb50
                        SQLState = 0x22cc6a
                        Native = 0x22cc74
                        Message Text = 0x22ca75
                        Buffer Length = 500
                        Text Len Ptr = 0x22cc7a
[ODBC][7236][1307563457.895000][SQLError.c][471]
                Exit:[SQL_SUCCESS]
                        SQLState = 01000
                        Native = 0x22cc74 -> 0
			Message Text = [[unixODBC][Driver Manager]Can't open lib '/usr/ 
local/freetds/lib/libtdsodbc.a' : Access is denied.]
[ODBC][7236][1307563457.897000][SQLError.c][434]
                Entry:
                        Connection = 0x8adb50
                        SQLState = 0x22cc6a
                        Native = 0x22cc74
                        Message Text = 0x22ca75
                        Buffer Length = 500
                        Text Len Ptr = 0x22cc7a
[ODBC][7236][1307563457.898000][SQLError.c][471]
                Exit:[SQL_NO_DATA]
[ODBC][7236][1307563457.899000][SQLError.c][514]
                Entry:
                        Environment = 0x8849b8
                        SQLState = 0x22cc6a
                        Native = 0x22cc74
                        Message Text = 0x22ca75
                        Buffer Length = 500
                        Text Len Ptr = 0x22cc7a
[ODBC][7236][1307563457.900000][SQLError.c][551]
                Exit:[SQL_NO_DATA]
[ODBC][7236][1307563457.901000][SQLFreeHandle.c][286]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x8adb50
[ODBC][7236][1307563457.902000][SQLFreeHandle.c][337]
                Exit:[SQL_SUCCESS]
[ODBC][7236][1307563457.903000][SQLFreeHandle.c][219]
                Entry:
                        Handle Type = 1
                        Input Handle = 0x8849b8


Any help is appreciated!
Dave

--
Dave Dumaresq
Technical Analyst - BCcampus
200 - 555 Seymour St, Vancouver BC
Phone: 604-412-7738