Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

md — Wed, 05 Dec 2012 16:51:46 GMT

is there any way to use this a a perl driver? or will that be in a future release?

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Andreas J — Fri, 02 Nov 2012 12:20:21 GMT

Hi SQLNCli team,

One questions burning under my nails:

Is there any chance that Failover_Partner will be supported in future releases?

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Dave_Mc — Thu, 11 Oct 2012 22:15:02 GMT

We've had success with SELECT statements using the new driver, but INSERT statements are failing. We are attempting to replace a third-party driver with this new one from Microsoft on a Linux server running a commercial ETL suite. We can't see inside that commercial product, so we don't know the details of how it's trying to talk to ODBC.

Following are ODBC trace entries which seem to be associated with this failure. Can anyone help me with this? Thanks.

[ODBC][13568][1344537102.881073][SQLAllocHandle.c][540]

Entry:

Handle Type = 3

Input Handle = 0x1d1077c0

[ODBC][13568][1344537102.881137][SQLAllocHandle.c][1083]

Exit:[SQL_SUCCESS]

Output Handle = 0x1dded290

[ODBC][13568][1344537102.881222][SQLPrepare.c][196]

Entry:

Statement = 0x1dded290

SQL = [INSERT INTO TEST_CONSTITUENT_BBDW(ID,KEYNAME,KEYNAMEPREFIX,FIRSTNAME,MIDDLENAME,MAIDENNAME,NICKNAME) VALUES ( ?, ?, ?, ?, ?, ?,...][length = 132]

[ODBC][13568][1344537102.881268][SQLPrepare.c][371]

Exit:[SQL_SUCCESS]

[ODBC][13568][1344537102.881318][SQLFreeStmt.c][144]

Entry:

Statement = 0x1dded290

Option = 0

[ODBC][13568][1344537102.881342][SQLFreeStmt.c][196]Error: IM001

[ODBC][13568][1344537102.881387][SQLError.c][352]

Entry:

Statement = 0x1dded290

SQLState = 0x448f6b60

Native = 0x448f6b68

Message Text = 0x448f68e0

Buffer Length = 511

Text Len Ptr = 0x448f6b6e

[ODBC][13568][1344537102.881420][SQLError.c][389]

Exit:[SQL_SUCCESS]

SQLState = IM001

Native = 0x448f6b68 -> 0

Message Text = [[unixODBC][Driver Manager]Driver does not support this function]

[ODBC][13568][1344537102.881475][SQLError.c][352]

Entry:

Statement = 0x1dded290

SQLState = 0x448f6b60

Native = 0x448f6b68

Message Text = 0x448f68e0

Buffer Length = 511

Text Len Ptr = 0x448f6b6e

[ODBC][13568][1344537102.881501][SQLError.c][389]

Exit:[SQL_NO_DATA]

[ODBC][13568][1344537102.881526][SQLFreeStmt.c][144]

Entry:

Statement = 0x1dded290

Option = 1

[ODBC][13568][1344537102.881548][SQLFreeStmt.c][196]Error: IM001

[ODBC][13568][1344537102.881584][SQLError.c][352]

Entry:

Statement = 0x1dded290

SQLState = 0x448f6b60

Native = 0x448f6b68

Message Text = 0x448f68e0

Buffer Length = 511

Text Len Ptr = 0x448f6b6e

[ODBC][13568][1344537102.881613][SQLError.c][389]

Exit:[SQL_SUCCESS]

SQLState = IM001

Native = 0x448f6b68 -> 0

Message Text = [[unixODBC][Driver Manager]Driver does not support this function]

[ODBC][13568][1344537102.881645][SQLError.c][352]

Entry:

Statement = 0x1dded290

SQLState = 0x448f6b60

Native = 0x448f6b68

Message Text = 0x448f68e0

Buffer Length = 511

Text Len Ptr = 0x448f6b6e

[ODBC][13568][1344537102.881669][SQLError.c][389]

Exit:[SQL_NO_DATA]

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Daniil Megrabyan — Mon, 01 Oct 2012 08:23:19 GMT

It's nice to have original ODBC driver for Linux, but what should we do with non-unicode databases? There is a problem with queries like SELECT 'Some cp1251 data' as 'field1', eventually we've got mojibake as a result.

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Kevin — Wed, 05 Sep 2012 18:51:18 GMT

What happened to this project? Is it shelfed or still going? Are you still working on the 32 bit version and availability on other distros?

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Shekhar Joshi - Microsoft — Tue, 04 Sep 2012 15:10:36 GMT

We have released the RTM in Mar 2012.

You can download the driver from the link below

www.microsoft.com/.../details.aspx

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

John C — Tue, 04 Sep 2012 14:51:26 GMT

When is the planned production release of the new driver

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Brandon K — Thu, 09 Aug 2012 18:44:04 GMT

Hi Guys,

Great work on the Linux support... but come on! RHEL5 or 6 only? Special builds of unixODBC driver manager? 64-bit only?

That's hardly better than the FreeTDS that we've been tolerating for years.

Please get us a real ODBC driver that works with most default installs for unixODBC.

Thanks,

Brandon

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Steve Garrett — Tue, 17 Apr 2012 14:11:44 GMT

I installed the drivers on a clean version of RH EL 6.2. They work but I was hoping that the MS Native drivers would allow me to retrieve the text fields that are defined as nvar(max) they don't. When I try to select a nvar(max) type field I will first get an error saying that I need to allocate 4GB of memory for this operation but even if I allocate that much it just core dumps. So I still have to cast those field types to text which converts any unicode only characters to a ?. So I'm not sure what the native drivers give you that the FreeTDS drivers didn't. It certainly is more difficult to install the MS drivers since you have to have a special version of unixODBC to run it though.

re: Preview Release of the SQL Server [C/C++] ODBC Driver for Linux

Gregory Su - MSFT — Tue, 03 Apr 2012 17:12:37 GMT

Hi Someone,

Can you verify that you are using the released (RTM ) build ? Based on the error message, it sounds like you might be using CTP release or possibly have both versions installed.

Can you run the following commands and send me the output:

odbcinst -j

cat /etc/odbcinst.ini

Thanks,

- Greg