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

eric.berg at barclayscapital.com eric.berg at barclayscapital.com
Wed Jun 8 21:48:35 BST 2011


Dave,

>From the error message you sent, it looks like you've got some kind of additional characters in the Driver line in odbcinst.ini.

I recommend that you retype that in...I have definitely run into this when my pasting into a file picked up some extraneous characters.

Alternatively, if those spaces aren't actually there, you might make sure that the user that's executing the command has read access to your odbcinst.ini.

Eric

> -----Original Message-----
> From: unixodbc-support-bounces at mailman.unixodbc.org [mailto:unixodbc-
> support-bounces at mailman.unixodbc.org] On Behalf Of Dave Dumaresq
> Sent: Wednesday, June 08, 2011 4:15 PM
> To: Support for the unixODBC project; FreeTDS Development Group
> Subject: [unixODBC-support] [unixODBC][Driver Manager]Can't open lib ...
> Access is denied
> 
> 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
> 
> 
> 
> 
> 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________


More information about the unixODBC-support mailing list