headers
wolfgang | 21 May 2013 22:48
Picon

Abwesenheit - Assenza

Ich bin bis Sonntag, 26.05.2013, wegen Urlaubs nicht erreichbar.

In dringenden Fällen schicken Sie bitte ein SMS an meine Handy-Nummer.

-----------------------

A causa di ferie non sono raggiungibile fino a domenica, il 26/05/2013.

In casi di urgenze mandatemi un SMS sul mio numero di cellulare.
Permalink | Reply | 0 comments |
headers
wolfgang | 20 May 2013 23:07
Picon

Abwesenheit - Assenza

Ich bin bis Sonntag, 26.05.2013, wegen Urlaubs nicht erreichbar.

In dringenden Fällen schicken Sie bitte ein SMS an meine Handy-Nummer.

-----------------------

A causa di ferie non sono raggiungibile fino a domenica, il 26/05/2013.

In casi di urgenze mandatemi un SMS sul mio numero di cellulare.
Permalink | Reply | 0 comments |
headers
Frediano Ziglio | 20 May 2013 23:06
Picon

iconv works

Hi,
  trying to sort the problem of supporting protocol 7.2/7.3 in dblib/ctlib
I came to the problem of varchar(max). The problem was that dblib wants
conversion to single char while varchar(max) was implemented not converting
it. This was fine for ODBC which disable conversions in libTDS to support
getting raw data but not for dblib. To fix the issue a new iconv function
which deal with varchar(max) (which can be streamed having multiple chunks
so tds_get_char_data was not helpful in this case (as only support
contiguous data from the net). I then decided to write code which could
handle conversion from an input stream to an output stream so I can reuse
for  every conversion (for instance from bcp file to memory!).

I ended up with this branch:

http://gitorious.org/~freddy77/freetds/mars-freetds/commits/unify_iconv

I'm actually running tests again to publish on nightly.

The reason I didn't pushed is that although code is quite good there are
some things to decide and sort out! Structures/functions to deal with
streams are in include/freetds/stream.h. Input stream it's just a function
to read data while output have a buffer contained in it.

Good things of these patches:
- only a single code to convert characters, better for test and maintenance;
- bit less copy of data;
- allow dblib/ctlib to support up to protocol 7.3;
- allow bcp to support direct streaming, no fseek require

Things to sort out:
(Continue reading)

Permalink | Reply | 1 comment |
headers
Vann, David | 9 May 2013 15:13
Favicon

freeTDS configure works but make doesn't

Any help would be appreciated.

I'm trying to run freeTDS on AIX 5.3 64bit.  I've tried versions 0.91 and 0.92.79.  I using unixODBC driver
manager version 2.3.1.  It has compiled cleanly and is running.  It was compiled in 64 bit mode.  The ultimate
result is to run with Oracle 11gR2 which is also 64 bit.

.  The configure seems to work fine, but the make fails.

Export OBJECT_MODE=64
Export CFLAGS=-maix64
./configure --prefix=/usr/local --with-unixodbc=/usr/local --with-tdsver=8.0 --enable-msdblib
2>&1 | tee configure.log
-- This looks good, but when I run make I get errors.

You can see I enabled MSDBLIB however during the make it fails and it looks like it still wants to compile
Sybase.  It's all on fisql.c and I found the objects(.dbcoltype;.dbcollen;.dbcolname;etc)  it's
referenced in sybdb.h.  I'm not sure why it's compiling Sybase nor do I understand why it can't find the
objects referenced when they're in the TDS source directory.  I've tried setting the srcdir and that
didn't help.

Below is a snapshot of the make that fails.
libtool: link: /usr/local/TDS/freetds-0.91/compile gcc -D_THREAD_SAFE -maix64 -W
declaration-after-statement -o .libs/fisql fisql.o terminal.o edit.o handlers.o
interrupt.o  -L/usr/local/lib -L../../dblib/.libs -lsybdb ../../replacements/.li
bs/libreplacements.a -liconv -lcurses -lreadline -lpthreads -Wl,-blibpath:/usr/l
ocal/lib:/usr/lib:/lib
ld: 0711-317 ERROR: Undefined symbol: .dbcoltype
ld: 0711-317 ERROR: Undefined symbol: .dbcollen
ld: 0711-317 ERROR: Undefined symbol: .dbcolname
ld: 0711-317 ERROR: Undefined symbol: .dbdead
(Continue reading)

Permalink | Reply | 7 comments |
headers
Krish | 6 May 2013 11:53
Picon
Gravatar

Unable to connect: Adaptive Server is unavailable or does not exist

While trying to connect remote SQL Server:

$tsql -S localhost -U myuser

I got error like:

locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20009 (severity 9):
    Unable to connect: Adaptive Server is unavailable or does not exist
    OS error 61, "Connection refused"
There was a problem connecting to the server

The output of $tsql -C is as below:

Compile-time settings (established with the "configure" script)
                        Version: freetds v0.91
         freetds.conf directory: /usr/local/freetds/conf/freetds
 MS db-lib source compatibility: no
    Sybase binary compatibility: no
                  Thread safety: yes
                  iconv library: no
                    TDS version: 5.0
                          iODBC: no
                       unixodbc: no
          SSPI "trusted" logins: no
                       Kerberos: no

I have created tunnel for remote server like:
(Continue reading)

Permalink | Reply | 6 comments |
headers
Nick Walke | 2 May 2013 23:37
Picon
Gravatar

FreeTDS dates different between versions

We're rebuilding a web server that uses FreeTDS to connect to an MSSQL
server.  The old server is running FreeTDS 0.82 and the new server is
running version 0.91.  The date formatting seems to be off on the new
server.  When retrieving dates, they come back as something like "Feb 19
2013 12:00:00:000AM".  The old server would return them like "2013-04-01
00:00:00".  I've verified that the locale files are the same.  What can I
do on the new server to get it to return dates like on version 0.82?  The
servers are running different OSes if that makes a difference as well.

Nick
Permalink | Reply | 4 comments |
headers
graham.simpson | 1 May 2013 09:41

Quoted Identifiers FreeTDS unixODBC

Hello,

Have unixODBC 2.3.1 configured with FreeTDS to provide MS SQLSERVER 2000 
support via ODBC.

Connectivity and everything is fine except that we need a method to set 
quoted identifiers off.

We also use Microsoft sqlncli via unixODBC to provide MS SQLSERVER 
2005/2008/2012 support and this uses an odbc.ini setting of QuotedID = NO 
to do the job.

This setting does not work when driver is FreeTDS (also freetds.conf seems 
bypassed).

Is there a way to support QuotedID connection attribute using FreeTDS and 
unixODBC ?

Many thanks for any help,

GSi

************************************************************
HSBC Bank plc may be solicited in the course of its placement efforts for 
a new issue, by investment clients of the firm for whom the Bank as a firm 
already provides other services. It may equally decide to allocate to its 
own proprietary book or with an associate of HSBC Group. This represents a 
potential conflict of interest. HSBC Bank plc has internal arrangements 
designed to ensure that the firm would give unbiased and full advice to 
the corporate finance client about the valuation and pricing of the
(Continue reading)

Permalink | Reply | 1 comment |
headers
Gopi | 30 Apr 2013 19:22
Picon

FreeTDS registration with unixODBC

Hi All,

I installed unixODBC and FreeTDS on a solaris server. I m trying to
register the FreeTDS driver with unixODBC.

cat tds.driver.template
Description     = v0.91 with protocol v4.2
Driver          = /usr/local/lib/libtdsodbc.so

odbcinst -i -d -f tds.driver.template
odbcinst: iniOpen failed on tds.driver.template.

This is the error I come across on trying to register. Can anyone advice
how to move ahead on this?

Thanks,
Kriskon
Permalink | Reply | 3 comments |
headers
Randy Syring | 29 Apr 2013 20:15
Picon
Gravatar

Status of support for Time type

What's the status on FreeTDS being able to support the time data type 
(and other new date/time types in 2008)?

Thanks.

*Randy Syring*
Development | Executive Director
Direct: 502.276.0459
Office: 812.285.8766
Level 12 Technologies <https://www.lev12.com/>
/Principled People | Technology that Works/
Permalink | Reply | 13 comments |
headers
TJ | 19 Apr 2013 15:46

dbi:ODBC:DSN=... odbc.ini UID and PWD ignored ?

On Ubuntu 12.04 and 13.04 I'm seeing a failure to authenticate to an MS SQL Server when UID and PWD are
included from the DSN stanza in odbc.ini. When they are added to the connection string the
connection is successful.

Table 4.1 of "Connection attributes" says "The following table defines all possible ODBC connection
attributes for the FreeTDS ODBC driver. Which ones you'll need depends on how you set yourself up.
They may appear in your connection string, or in odbc.ini." but my experience doesn't seem to match that.

#  apt-cache policy freetds-common tdsodbc unixodbc  | grep -B1 Installed
freetds-common:
  Installed: 0.91-3
tdsodbc:
  Installed: 0.91-3
unixodbc:
  Installed: 2.2.14p2-5ubuntu4

I'm using a Perl script for testing which tries these variations of the connection string. The first works,
the second fails:

#!/usr/bin/perl

use DBI;

my $DSN = 'Northwind';
my $user = 'INT\TJ';
my $password = 'password';

my $dbh = DBI->connect("dbi:ODBC:DSN=$DSN;UID=$user;PWD=$password", {PrintError => 0});
my $dbh = DBI->connect("dbi:ODBC:DSN=$DSN", {PrintError => 0});
#...
(Continue reading)

Permalink | Reply | 4 comments |
headers
Frediano Ziglio | 8 Apr 2013 22:29
Picon

Cmake support added

I finally found some time to finish my cmake patch

See
https://gitorious.org/~freddy77/freetds/mars-freetds/commit/2b3f4b8e58193605862d2ffbb185a1ad040b6be9for
notes.

It does not completely work for Unix but is very useful for Windows users
as it can generated files for more used IDEs. It can be used even with
MingW (even cross one)

Frediano
Permalink | Reply | 0 comments |

Gmane