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

Dave Dumaresq ddumaresq at bccampus.ca
Wed Jun 8 21:14:38 BST 2011


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







More information about the unixODBC-support mailing list