Frediano Ziglio | 21 May 06:55 2015
Picon

Third release candidate for 0.95

Hi,
  I packaged 0.95rc3 version.

It includes:
- more fixes for tests under Windows;
- some small build problem with not default options;
- fix for login with extended characters;
- ODBC SQLFreeStmt fix if connection is busy from other statements.

Last fix was quite intrusive but was not an easy problem to fix.
Thanks Joel for the report.

Regards,
  Frediano
Frediano Ziglio | 21 May 00:32 2015
Picon

Re: Connecting to a specific database with DB-Library

2015-05-20 22:38 GMT+01:00 Geoff Montee <geoff.montee <at> gmail.com>:
> Hi,
>
> Some tds_fdw users are having issues connecting to Microsoft Azure.
>
> At the moment, if a tds_fdw user wants to connect to a particular
> server and database, then tds_fdw connects to the server using
> dbopen(), and then switches to the database using dbuse().
>
> The problem is that apparently Microsoft Azure doesn't support the
> syntax "USE databasename;", which is what dbuse() does behind the
> scenes.
>
> Is there a way to supply a connecting database name to dbopen() or
> another similar DB-Library function? In the Doxygen reference manual,
> I don't see any function or macro to add a database name to LOGINREC
> (i.e. something with a name like setldatabase()).
>
> I was thinking that users could just change the default database for a
> particular user on the server side to avoid the problem, but
> apparently Azure doesn't support that either.
>
> Thanks,
>
> Geoff Montee

Hi,
  i think DBSETLDBNAME is what you want.

Frediano
(Continue reading)

Geoff Montee | 20 May 23:38 2015
Picon

Connecting to a specific database with DB-Library

Hi,

Some tds_fdw users are having issues connecting to Microsoft Azure.

At the moment, if a tds_fdw user wants to connect to a particular
server and database, then tds_fdw connects to the server using
dbopen(), and then switches to the database using dbuse().

The problem is that apparently Microsoft Azure doesn't support the
syntax "USE databasename;", which is what dbuse() does behind the
scenes.

Is there a way to supply a connecting database name to dbopen() or
another similar DB-Library function? In the Doxygen reference manual,
I don't see any function or macro to add a database name to LOGINREC
(i.e. something with a name like setldatabase()).

I was thinking that users could just change the default database for a
particular user on the server side to avoid the problem, but
apparently Azure doesn't support that either.

Thanks,

Geoff Montee
Randy Syring | 17 May 16:13 2015
Picon

Two versions of user guide?

Are there two versions of the user guide on the site?

http://www.freetds.org/choosingtdsprotocol.htm (has updated info about 
obsolete versions)
http://www.freetds.org/userguide/choosingtdsprotocol.htm (not the same info)

*Randy Syring*
Husband | Father | Redeemed Sinner

/"For what does it profit a man to gain the whole world
and forfeit his soul?" (Mark 8:36 ESV)/
Ben David | 16 May 21:55 2015

Version Not Updating; Connection Not Connecting

Dear FreeTDS Mailing List,

Thanks for the list!  I've been reading it a lot to no avail, so I thought I would finally post.  The basic story
for creating this is that we have a SQL Anywhere 12 database on the network here at work we are trying to
connect to from another workstation - the plan is to utilize PHP PDO with FreeTDS/ODBC as the connector.

I installed FreeTDS to accomplish this in part, but I am having an incredibly difficult time getting it to
work.  Here is my system config:

CentOS:               7
FreeTDS:              4.2 (trying to get it to use version 8.0)
PHP:                      5.4.16

The following configuration was adapted from a thread on this forum after multiple failed attempts
otherwise, I thought it would be a better place to start than my other attempts:

---

My current freetds.conf:

[global]
  tds version = 8.0
  client charset = UTF-8
  dump file = /tmp/freetds.log
  dump file append = yes
  debug flags = 0xffff
  debug level = 10
  text size = 64512
[mssql_tds]
  host = 101.215.76.250
(Continue reading)

Frediano Ziglio | 11 May 20:29 2015
Picon

New release candidate

Hi,
  I packaged 0.95rc2 version.

It includes lot of fixes for tests under Windows and some unixODBC
compatibility problem.

Regards,
  Frediano
Alistair Roberts | 11 May 01:29 2015
Picon

SQL 2014 Support

Hi,

Is there any issues using FreeTDS and SQL 2014?

Thanks

Alistair
Velichko Yuriy | 7 May 20:58 2015
Picon

Is there a plan of full implementation of dbcolinfo

​Hello!

I want to figure out what tables takes a part in the query result. As I
understood, the function dbcolinfo may help. According to the docs, to
fetch the table name I have pass param CI_CURSOR ​to this function. But
according to FreeTDS docs:

 (CI_CURSOR is defined by the vendor, but is not yet implemented).

​
Is there a hope that this feature will be implemented?

Or maybe somebody knows how to solve this problem in another way?
​
_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Frediano Ziglio | 5 May 20:33 2015
Picon

New release candidate available

Hi,
  after 4 years of development we are proud to start preparing a new
release of FreeTDS leading to 0.95.

You can find a link at main page www.freetds.org or from the ftp site
ftp://ftp.freetds.org/pub/freetds/stable/release_candidates/.

Feel free to test and give any feedback. You can find a quite detailed
list of changes in NEWS file but just as a sum:
- MSSQL 2008 protocol;
- better support for Windows builds;
- MARS support where available;
- IPv6;
- improved applications (freebcp, datacopy);
- support for newer protocols in ctlib and dblib;
- ton of enhancement and optimizations.

Regards,
   Frediano
Ramiro Morales | 2 May 23:14 2015
Picon

alloca() usage, building master pre-0.95 on Windows

Hi all,

When trying to build the tools binaries with Visual studio 2008 (VC9)
(actually a free subset called the Microsoft Visual C++ Compiler
Package for Python 2.7) after tds.lib, db-lib and ctlib.lib have been
built successfully (Thanks Frediano and Larry!), this happens:

C:\>nmake -nologo -fNmakefile CONFIGURATION=release PLATFORM=win32 apps
        cl  -nologo     -W3 -EHsc -TC -Gm  -errorReport:prompt -D
"_MBCS" -D "_LIB" -D "WIN32"  -D MSDBLIB  -D "_CRT_SECURE_NO_WARNINGS"
-D _CRT_NONSTDC_NO_DEPRECATE -D _WIN32_WINNT=0x0400 -I "include" -I
"win32" -I "include\x64" -MD  -O2 -D "_NDEBUG" -Zi
-Fesrc\apps\win32\release\bsqldb.exe
-Fd"src\apps\win32\release\vc80.pdb"  src\apps\bsqldb.c -link
-LIBPATH:src\dblib\win32\release db-lib.lib Ws2_32.lib shell32.lib
bsqldb.c
...
db-lib.lib(token.obj) : error LNK2019: unresolved external symbol
_alloca referenced in function _tds_process_nbcrow
src\apps\win32\release\bsqldb.exe : fatal error LNK1120: 1 unresolved externals
NMAKE : fatal error U1077:
'"C:\Users\Me\AppData\Local\Programs\Common\Microsoft\Visual C++ for
Python\9.0\VC\Bin\cl.EXE"' : return code '0x2'
Stop.

This is because there is one usage of alloca() in src/tds/token.c.

With this toolchain, alloca() is available, not as a C runtime library
function but is inserted inline by the compiler instead. Problem is:
To get it to work and not generate the link-time error above, the
(Continue reading)

Ed Avis | 28 Apr 11:14 2015

freebcp transaction isolation level when 'bcp out'

I run freebcp to make scheduled hourly backups of some tables.  These are not
a replacement for the normal database backup, but can be handy as a way to
quickly recover from minor screwups or as a way to grep the history of a table
over time.

The tables being dumped are usually small and append-only - so new rows are
added to them from time to time but rows are not updated and rarely deleted.

Sometimes I find that the freebcp process gets blocked by some other process
adding rows to one of these tables.  I would be quite happy to do

    set transaction isolation level read uncommitted

That would stop freebcp being blocked (or blocking anything else).  It means
that you can see rows which have been added by some other process and not yet
committed, but for this particular application this is not an issue.  I am
happy to make that tradeoff in order to make the hourly dumps not get in the
way of anything else.

So I would like a way to tell freebcp what transaction isolation level to use.
I see in bcp.c that it simply works by

    tds_submit_queryf(tds, "select * from %s", dbproc->bcpinfo->tablename)

in other words there is no special magic for 'bcp out' - really it is just
a convenience to dump the rows in the same format that can later be 'bcp in'.

Could freebcp have an option to run some extra SQL before the 'select'?

    freebcp database..table out outfile -c \
(Continue reading)


Gmane