[unixODBC][Driver Manager]Can't open lib ... Access is denied

Dave Dumaresq <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.