FreeTDS Development Group

[Darren Stokes <Darren.Stokes AT onestop.co.uk>]

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
**********************************************************************