Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem trying to install freeTDS 0.64 on aix 5.3.0 .0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Darren Stokes <Darren.Stokes AT onestop.co.uk>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem trying to install freeTDS 0.64 on aix 5.3.0 .0
  • Date: Thu, 25 Jan 2007 15:43:59 -0000

Success ! - of sorts

> I looked deeper at your makes and I found a really weird thing... did you
run configure with different flags using --disable/enable-shared/static? The
output if VERY different !!!

ok- sorry about that, probably me being a (relatively) unix newbie and
trying different flags on the compile before removing what I had done
before. I removed all the directories that I had created previously,
untarred the program again, made the changes you highlighed, and it has
compiled, and the make and make install finished ok. - Thank you


Now i'm looking through the documentation and Im sorry to say I have another
question.

I have set up a freetds.conf file, and referenced it in my $ODBCINI file
(initially preferring to go down the ODBC-combined route). The 'tsql'
command is working (i believe), However im just 'exiting' the utility - not
entirely sure what sort of thing I can do in that. The output is as
follows:

# ./tsql -S MyServer2k -U DBUser -P 0840
locale is "en_US en_US en_US en_US en_US en_US"
locale charset is "ISO8859-1"
1> exit
#

ok, I'm guessing that is fine. The problem comes when I'm attempting to set
up my DSN. I notice from the documentation that the driver libtdsodbc.so is
referenced for use in the odbc.ini file. I don't have libtdsodbc.so
anywhere, but i have a similar one with an extension of .a

The folder list of /usr/local/freeTDS/lib is:
# ls -l
total 19024
-rw-r--r-- 1 root system 1967283 Jan 25 13:27 libct.a
-rwxr-xr-x 1 root system 776 Jan 25 13:27 libct.la
-rw-r--r-- 1 root system 2134203 Jan 25 13:27 libsybdb.a
-rwxr-xr-x 1 root system 785 Jan 25 13:27 libsybdb.la
-rw-r--r-- 1 root system 1563799 Jan 25 13:27 libtds.a
-rwxr-xr-x 1 root system 779 Jan 25 13:27 libtds.la
-rw-r--r-- 1 root system 2331072 Jan 25 13:27 libtdsodbc.a
-rwxr-xr-x 1 root system 845 Jan 25 13:27 libtdsodbc.la
-rw-r--r-- 1 root system 1708167 Jan 25 13:27 libtdssrv.a
-rwxr-xr-x 1 root system 788 Jan 25 13:27 libtdssrv.la


I've attempted to try and use the libtdsodbc.a in my odbc.ini file, but when
i run isql, i get the following:

# pwd
/usr/local/unixODBC/bin
# ./isql -v TDSdsn DBUser 0840
[01000][unixODBC][Driver Manager]Can't open lib
'/usr/local/freeTDS/lib/libtdsodbc.a' : 0509-022 Cannot load module
/usr/local/freeTDS/lib/libtdsodbc.a.
0509-026 System error: Cannot run a file that does not have a valid format.
[ISQL]ERROR: Could not SQLConnect
#

So, I am now assuming that I don't have the correct driver installed for me
to be able to connect.

For Reference, my freetds.conf file contains the following (I've left the
[global] section alone, so no changes there)

# A typical Microsoft SQL Server 2000 configuration
[MyServer2k]
host = 10.1.1.64
port = 1433
tds version = 8.0

and my odbc.ini file contains:

[ODBC Data Sources]
TDSdsn=Test Galleria through TDS

[TDSdsn]
Driver = /usr/local/freeTDS/lib/libtdsodbc.a
Description = Sybase JDBC Server
Trace = No
Servername = MyServer2k
Database = TS_STORES


Apologies for asking for so much help and Thank you for your efforts so far.

Darren


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************





Archive powered by MHonArc 2.6.24.

Top of Page