Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Dave Dumaresq <ddumaresq AT bccampus.ca>
  • To: Support for the unixODBC project <unixodbc-support AT mailman.unixodbc.org>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] [unixODBC][Driver Manager]Can't open lib ... Access is denied
  • Date: Wed, 8 Jun 2011 13:14:38 -0700

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









Archive powered by MHonArc 2.6.24.

Top of Page