http://blog.gmane.org/gmane.comp.db.tds.freetds hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.tds.freetds/14524 <pre>I have downloaded and freetds-0.91 and when I run ./configure I get no errors. However when I try to make I get the following: Making all in include make all-am echo '#define FREETDS_SYSCONFDIR "/usr/local/etc"' &gt;freetds_sysconfdir.h Target "all-am" is up to date. Making all in src Making all in replacements source='iconv.c' object='iconv.lo' libtool=yes DEPDIR=.deps depmode=aix /bin/sh ../../depcomp /bin/sh ../../libtool --tag=CC --mode=compile cc -qlanglvl=extc89 -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../src/replacements -D_FREETDS_LIBRARY_SOURCE -D_REENTRANT -D_THREAD_SAFE -DDEBUG=1 -D_THREAD_SAFE -g -c -o iconv.lo iconv.c libtool: compile: cc -qlanglvl=extc89 -DHAVE_CONFIG_H -I. -I../../include -I../../include -I../../src/replacements -D_FREETDS_LIBRARY_SOURCE -D_REENTRANT -D_THREAD_SAFE -DDEBUG=1 -D_THREAD_SAFE -g -c -M iconv.c -DPIC -o .libs/iconv.o "iconv.c", line 484.7: 1506-356 (W) Compilation unit is empty. source='gettimeofday.c' obje</pre> Kevin Coyle 2012-05-25T18:01:49 http://comments.gmane.org/gmane.comp.db.tds.freetds/14519 <pre>Hi We are doing a test using FreeTDS on Solaris moving a Fortran/C application from Sybase to MS-Sql server. Recently we ran into a problem I'm hoping to get a hint on how to solve. Simplified we are doing: - Update IMAGECOLTAB set IMAGECOL=NULL - Select IMAGECOL from IMAGECOLTAB - Get Pointer to IMAGECOL from dbtextptr - Get TimeStamp from dbtexttimestamp - Do dbwritetext with length of image to be written and NULL in last parameter - Loop text and do dbmoretext The problem is that we are getting tds_put_string: "writetext bulk IMAGECOLTAB.IMAGECOL 0x00000000000000000000000000000000 timestamp = 0x0000000000000000 with log" Invalid text, ntext, or image pointer value 0x00000000000000000000000000000000. Any idea on what we are doing wrong? I have checked code that we have in another program where we used dblib against Ms-Sqlserver, and I see more or less the same code. Below is a simplified C code for my function, and the resulting tds log file.</pre> Trygve Liland 2012-05-25T12:15:33 http://comments.gmane.org/gmane.comp.db.tds.freetds/14515 <pre>Hello. Is there any way to handle TDS errors from PHP code? Here's what I'm trying to do: I'm working on user authorization using MsSql database login and password. The same login that is used to connect to MsSql database. Currently I'm just connecting to database and checking if the connection worked. If credentials are correct, everything works fine. But, if either login of password is wrong, my PDO connection just dies with this error: FreeTDS: db-lib: exiting because client error handler returned INT_EXIT for msgno 20002 And that also crashes my php session. Is there any way I can implement that client error handler on my PHP side, or it should had already been dealt by PDO_DBLIB? </pre> Николай Кудрявцев 2012-05-24T10:32:37 http://comments.gmane.org/gmane.comp.db.tds.freetds/14514 <pre>Hello, I am new to FREETDS. I'm working on as DBA Admin and owner of database on SQL 2000 sp3 We are currently using PHP version is 5.2.6 running on OSX Server using FreeTDS&lt;http://www.freetds.org/&gt; (ver 0.82) to communicate with MS SQL Server 2000. Can someone confirm my understanding of TDSfree? It's an API that works with SQL Server... Underneath the hood - it uses TDS specification to access the SQL Server database. (Therefore it does not need to have SQL Server Native Client drives, etc installed on machine housing webserver/php ) Separately: I wanted to ask the group if anyone has setup TDSfree with SQL 2012? Thank you for any help and info This message is the property of Kamehameha Schools and any attachments are confidential to the intended recipient at the e-mail address to which it has been addressed. If you are not the intended recipient, you may not copy, forward, disclose or use any part of this message or its attachments. If you received this transmission in error please notify </pre> Norman Chan 2012-05-24T00:15:46 http://comments.gmane.org/gmane.comp.db.tds.freetds/14507 <pre>Hi, I created a new freetds repo at https://gitorious.org/~freddy77/freetds/mars-freetds. No, I'm not mad and it's not a fork. However I don't like to have my personal branches on the official repo. One of the main reason is to share mars branch (actually the only additional branch). Currently all tests passes even with mars code !!! But not all enabling mars... and upper layers do not currently support it and there are no specific tests! So... quite useless branch :) Apart from odbc support (the only library which support it) blob1 test fails with mars enabled due to the fact that if client does not limit packets sending speed server drop connection. I think this is another point to add to the James page on why do not use mars !! The other test that fails is cursor4 due to different protocol for transaction if mars is enabled (perhaps another small point to add to above page). Currently another problem is error reporting. If server drop connection all sessions should receive a network error. Fredia</pre> Frediano Ziglio 2012-05-19T16:53:55 http://comments.gmane.org/gmane.comp.db.tds.freetds/14504 <pre>For anyone interested in the git repository, I just pushed my first commit with git push ssh://git&lt; at &gt;gitorious.org/freetds/freetds.git It seemed work. I'm still getting the hang of git. There are two changes: 1. fix code that induces warnings in clang. All innocuous. 2. remove txt2man. All man pages are now in -mdoc format. It was a few hours' work. The man pages now look a little better and we lose one dependency. With a little cleverness, we could have them in PDF format, too. The warnings were mostly about using // as a comment, something I'm guilty of. These became either /**/ or #if 0. The most significant changes are to md4.c and md5.c. Each had a line memset(ctx, 0, sizeof(ctx)); now memset(ctx, 0, sizeof(*ctx)); The line intends to clear memory before returning to prevent sensitive data from remaining in memory. It was clearing sizeof(void*) instead of the whole structure. --jkl </pre> James K. Lowden 2012-05-18T21:50:31 http://comments.gmane.org/gmane.comp.db.tds.freetds/14502 <pre>Hi! I think there is a bug in FreeTDS regarding SYBUNIQUE column type... I'm accessing a MS SQLServer 2008 using freetds-0.91/ctlib. The server table has "uniqueidentifier" columns (which correspond to SYBUNIQUE / CS_UNIQUE_TYPE). With "ct_bind" i set the datatype to CS_UNIQUE_TYPE. However, "ct_fetch" doesnt return any data (copied=0) :-( Using "tdsdump", i see the following lines in the tracefile: 01:19:57.072719 7027 (ct.c:1736):_ct_bind_data(): column 25 is type 36 and has length 16 01:19:57.072725 7027 (ct.c:1907):_ct_get_client_type(type 36, user 0, size 16) 01:19:57.072730 7027 (cs.c:523):cs_convert(0x8d8d2e0, 0xbfc76fcc, 0xb74a1bc4, 0xbfc76f20, 0x8e85438, 0x8e85450) 01:19:57.072735 7027 (ct.c:2018):_ct_get_server_type(40) 01:19:57.072740 7027 (ct.c:2018):_ct_get_server_type(40) 01:19:57.072745 7027 (cs.c:569):converting type 36 (16 bytes) to type = 36 (16 bytes) 01:19:57.072750 7027 (cs.c:583):cs_convert() srctype == desttype 01:19:57.072755 7027 (cs.c:697):error: unrecognized t</pre> Willi Langenberger 2012-05-16T10:52:57 http://comments.gmane.org/gmane.comp.db.tds.freetds/14500 <pre>Hi, some days ago I discovered (and fixed) a small buffer overflow in both 0.91 and development code. Change at https://gitorious.org/freetds/freetds/commit/e5fe918627ab00e99faadd2c2ee0022f0be7dc98. It's a small read overflow (probably leading only to a crash) but still a buffer overflow. Frediano </pre> Frediano Ziglio 2012-05-15T17:14:30 http://comments.gmane.org/gmane.comp.db.tds.freetds/14497 <pre>Hi guys, I have a unix server which has PHP 5.2.13 installed, and it has access to two SQL servers (one is running MSSQL SERVER 2000 and the other MSSQL 2005). It uses FreeTDS - details: * Version: freetds v0.91 * freetds.conf directory: /usr/local/etc * MS db-lib source compatibility: no * Sybase binary compatibility: no * Thread safety: yes * iconv library: yes * TDS version: 7.1 * iODBC: no * unixodbc: yes * SSPI "trusted" logins: no * Kerberos: no And I'm using unixODBC-2.3.1 The MSSQL 2000 server is fine, I can run all SQL statements and use mssql_num_rows and mssql_fetch_assoc much as you would with MySQL. However, the MSSQL 2005 server won't work with mssql_num_rows or mssql_fetch_assoc - you have to use odbc_fetch_row. That's not really an issue, I assume it's just due to the different server versions. However, I have a huge issue with the MSSQL 2005 server connection: I cannot select a field AS another nam</pre> Neil Whitaker 2012-05-15T10:56:42 http://comments.gmane.org/gmane.comp.db.tds.freetds/14496 <pre>I have a unix server which has PHP 5.2.13 installed, and it has access to two SQL servers (one is running MSSQL SERVER 2000 and the other MSSQL 2005). It uses FreeTDS - details: - Version: freetds v0.91 - freetds.conf directory: /usr/local/etc - MS db-lib source compatibility: no - Sybase binary compatibility: no - Thread safety: yes - iconv library: yes - TDS version: 7.1 - iODBC: no - unixodbc: yes - - SSPI "trusted" logins: no - Kerberos: no And I'm using unixODBC-2.3.1 The MSSQL 2000 server is fine, I can run all SQL statements and use mssql_num_rows and mssql_fetch_assoc much as you would with MySQL. However, the MSSQL 2005 server won't work with mssql_num_rows or mssql_fetch_assoc - you have to use odbc_fetch_row. That's not really an issue, I assume it's just due to the different server installs. However, I have a huge issue with the MSSQL 2005 server connection: I cannot select a field AS another name! For example: SELECT [EnquiryID] AS "The_Key" FRO</pre> neil< at >hencam.co.uk 2012-05-15T10:50:16 http://comments.gmane.org/gmane.comp.db.tds.freetds/14488 <pre>I have a FreeTDS/odbc source that appears to be trying to resolve the server and instance of "servername.domain\db1" as a server instead of a server called "servername.domain" and an instance "db1" I know this should work because I have two linux servers using the same exact odbc source. Server A works. Server B doesn't. SERVER A: ------------------------------------------------------- A Redhat server. Using a data source in odbc.ini, I can connect to a particular MS SQL server and instance with the following server name in the source definition: Server = Servername.domain\db1 Some info from that server: $ tsql -C Compile-time settings (established with the "configure" script): Version: freetds v0.64 MS db-lib source compatibility: yes Sybase binary compatibility: unknown Thread safety: yes iconv library: yes TDS version: 4.2 iODBC: no unixodbc: </pre> Dave Schultz 2012-05-08T18:43:29 http://comments.gmane.org/gmane.comp.db.tds.freetds/14487 <pre>Have freetds 0.91 compiled on a CentOS box and trying to connect to SQL Server 2008 in freetds.conf have [shortname] host=123.123.123.123 instance = tester tds version = 8.0 tsql -S shortname -U user will connect right away however tsql -H 123.123.123.123 -U user just ticks away until I get a timeout error Is it because I'm not passing the instance when I use -H? --is there a way to do that? What I really want to do is talk to the DB server using an ant build script, but it was breaking. Any help appreciated, </pre> Morizono, Hiroki 2012-05-08T13:58:10 http://comments.gmane.org/gmane.comp.db.tds.freetds/14486 <pre>Hello, I am connecting to a Microsoft SQL Server 2008 database using unixODBC and FreeTDS on PHP. Everything was going well until the ORM library that I'm using (Doctrine) attempted to perform a select statement while cycling through the result set of another query. I received the error: "SQLSTATE[24000]: Invalid cursor state: 0 [FreeTDS][SQL Server]Invalid cursor state (SQLExecute[0] at ../pdo_odbc/odbc_stmt.c:254)" After doing some research, it appears that this behavior is by-design in FreeTDS (http://www.freetds.org/faq.html#pending). Is this error that I'm getting because of this implementation detail? If so, are there any plans to change this behavior? If not, does anyone have any recommendations for a driver I could use with PHP that would allow this behavior? Under normal circumstances, I would simply adjust the code myself. However, since I'm using someone else's library, I don't exactly have this luxury. Any suggestions are appreciated. Thank you! </pre> Jeremy Livingston 2012-05-08T03:18:21 http://comments.gmane.org/gmane.comp.db.tds.freetds/14480 <pre> I'm having some trouble figuring out how to use ODBC functions like SQLConnect() with freetds. I've looked through the FAQ, and searched the web for examples, and even grep'd through the freetds tarball I downloaded (freetds-stable.tgz) for a header with the SQLConnect function prototype, but I can't find anything. I feel I'm missing something obvious, but I can't quite figure out what. Can someone point me in the right direction here? Thanks, eric </pre> Haszlakiewicz, Eric 2012-05-07T17:20:32 http://comments.gmane.org/gmane.comp.db.tds.freetds/14479 <pre>I am using haskell bindings to unixodbc and freetds. They work fine with freetds 0.82 and unixodbc 2.3.0 But upgrade to freetds 0.91 and unixodbc 2.3.1 breakes it. Now it gives me a SQL_NO_TOTAL error on text larger than 4096 bytes. I submitted bug to hdbc-odbc lib here: https://github.com/hdbc/hdbc- odbc/issues/4 I looked through the code of haskell bindings and it does not handle SQL_NO_TOTAL. Just returns an error. Can anyone tellme what changed either in freetds or in unixodbc to cause it to return SQL_NO_TOTAL instead of just the length of the field ? Can we bring the old functionality back ? Or if not, how to correctly respond to SQL_NO_TOTAL ? Regards, Vagif Verdi </pre> Vagif Verdi 2012-05-07T04:42:18 http://comments.gmane.org/gmane.comp.db.tds.freetds/14475 <pre>http://www.freetds.org/scan-build/ The above analysis was produced by the Clang "static-build" tool based on a recent version of the development branch. A spot-check shows several false positives but some bona fide errors e.g. http://www.freetds.org/scan-build/report-06549p.html#EndPath There are 206 potential errors indicated. If you would like to contribute to the project, it would be very helpful simply to sort those 206 into two kinds: 1. errors 2. non-errors If several people do this, we will have good feedback for both the FreeTDS and Clang projects. In the case of Clang, perhaps we can classify the non-errors. For instance, I noticed that variables initialized as a function output parameter isn't recognized as initialization, and a pointer is detected as NULL after being tested with assert(3) (although arguably the assert is insufficient). Patches are also welcome, of course. :-) FreeTDS is an interesting test case for the Clang static analyzer by virtue of its portability. Recent AIX</pre> James K. Lowden 2012-05-03T22:36:34 http://comments.gmane.org/gmane.comp.db.tds.freetds/14468 <pre>Hi, I am new to freetds and have some questions about intermittent error below that we get from our monitoring system that uses freetds for SQLServer connect check: ALERT : Unable to connect to instance ERROR TEXT : OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (35) Server &lt;server_name_here&gt;, database Message String: SQL Server connection timed out. Every time when I get above alert - I can successfully connect to SQLServer - do not see any errors around that time in SQLServer log - moreover even SQLServer default trace file does not show any activity happening around that time for some affected servers - issue affects different servers at different times (I do not see any pattern) - other databases on the affected instance that are checked also by monitoring system do not have same connection issue - it is always one-off and intermittent issue (next run of monitoring check scheduled every 15 mins does not have this connection issue) Question are 1) Wh</pre> box.eugene 2012-05-01T01:33:34 http://comments.gmane.org/gmane.comp.db.tds.freetds/14465 <pre>Hi all, Sorry if this question was asked before in this mailing list, but we need to install FreeTDS on an AIX 7.1. So far we could only compile on AIX 6.1, configure does not seem to be prepared for AIX 7.1 ... What is the status about AIX 7.1 support? Is it legal to compile on AIX 6.1 and copy the binaries on 7.1? Is there any guide to build FreeTDS on AIX 6.1? Thanks! Seb </pre> Sebastien FLAESCH 2012-04-27T14:41:55 http://comments.gmane.org/gmane.comp.db.tds.freetds/14461 <pre>Hello, I was wondering if someone might be able to help me. We are using SUSE 11 SP1 64 bit, SQL Server 2008 R2, unixODBC 2.2.12 driver and FreeTDS 0.91 and PHP 5.3.8. When retrieving a row with diacritics we get a php out of memory error where it is trying to read all of the memory in the system. Looking at the logs for FreeTDS we are getting the following error: util.c:104:logic error: cannot change query state from IDLE to PENDING If we skip reading any fields with diacritics the data is read without any issue. I've searched around and could not find any information about this. We do have the text size set in the config file but this does not seem to resolve the issue. Any help would be greatly appreciated. Thanks, -Nate Nathan Sarr Senior Software Engineer River Campus Libraries University of Rochester Rochester, NY 14627 (585) 275-0692 nsarr&lt; at &gt;library.rochester.edu &lt;mailto:nsarr&lt; at &gt;library.rochester.edu&gt; </pre> Sarr, Nathan 2012-04-26T14:14:56 http://comments.gmane.org/gmane.comp.db.tds.freetds/14460 <pre>Hello – We have compiled 0.91 Free TDS on AIX 6.1. Freebcp is working, but fisql and tsql are both coring with a segmentation fault. Here are the steps we did: ◄ cd /datatransfer/ftp/freetds_0.91/freetds-0.91 ◄ ./configure CC=xlc_r --prefix=/rating/freetds --disable-debug --disable-shared ◄ rm -rf /rating/freetds ◄ make &amp;&amp; make install There are some linker warnings occurring with the compile: (ld): resolve ld: 0711-224 WARNING: Duplicate symbol: .bcopy ld: 0711-228 WARNING: Duplicate symbols were found while resolving symbols. The following duplicates were found: Symbol Source-File(Object) OR Import-File{Shared-object} ------------------------- ------------------------------------------------- .bcopy {/usr/lib/libreadline.a[libreadline.so.6]} ** Duplicate ** moveeq.s(/usr/lib/libc.a[moveeq.o]) ... ld: 0711-768 WARNING: Object fisql.o, section 1, function .strcat: The branch at address 0x78c is not followed by a reco</pre> Mccabe, Lisa L 2012-04-25T15:00:11 http://comments.gmane.org/gmane.comp.db.tds.freetds/14453 <pre> Hello ! I am trying to use Freetds Connection Pool but something is wrong and I can not get any result back from the pool. I have the following configurations: $cat /usr/local/etc/pool.conf [global] min pool conn = 5 max pool conn = 10 max member age = 120 [mypool4] user = myuser password = myuser database = MyDatabase server = 1XX.1XX.X.XXX port = 6668 TDS_Version = 4.2 $cat /usr/local/etc/freetds.conf [hype] host = 127.0.0.1 port = 6668 tds version = 4.2 And start the Pool server: $tdspool mypool4 &amp; And seting up an entry in my .odbc: [pool2] Driver = /usr/local/lib/libtdsodbc.so Description = Sybase JDBC Server Trace = Yes ServerName = hype Port = 6668 TDS_Version = 4.2 When I run the following command: $¨ isql -v pool2 myuser myuser I never get a response from the Pooling server. I can see that the Pool server rec</pre> freetds< at >mittran.com 2012-04-24T13:27:27 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.tds.freetds