SQL Server 2008 / Katmai

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
Fridolin Schwarz

SQL Server 2008 / Katmai

Post by Fridolin Schwarz » 11 Jun 2008, 11:34

 Posted by:  Fridolin Schwarz 


Dear NG,

has anyone experiences with the new version of SQL Server 2008?
We can´t pass Date/Time-Values in bind variables to or from a data base.
Currently we use the Katmai-CTP-pre release version. Is there a hope that
this behaviourr will change?

fridolin

Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2170
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

SQL Server 2008 / Katmai

Post by Jeff Luther » 11 Jun 2008, 17:17

 Posted by:  Jeff Luther 

"behaviourr will change" - I doubt it, since D/Ts vary widely among
datatbases, and incombatibility has been, over the years, a source of lots
of frustration. Here's what I know and have done:

-- This is also a current issue on the Unify forum with MySql as the
backend, so the issue is with other DBs as well;

-- It has also been a general issue on this forum in the past, so I would
suggest a search of this area, sourcecode, development, etc. to see what
issues/solutions others have come up with when trying to use D/Ts in TD
against a foreign DB (that is, other than SQLBase);

-- I once helped a client support D/T for Oracle's timestamp by using a
correctly-formatted string as the bind, just searched for any msgs. in this
NG area from me and see that there are several during January 16-18, 2008,
including some code samples. Take a look there and see how it got handled.
You may need to do something similar for SS.

As to how specifically to support SQL Server 2008, I don't know, but perhaps
there are a couple hints for you above and what else you find on the NG.

Best Regards,
Jeff @ PC Design
info. & samples: www.JeffLuther.net/unify/

Didier Tourneur

SQL Server 2008 / Katmai

Post by Didier Tourneur » 11 Jun 2008, 17:45

 Posted by:  Didier Tourneur 

I haven't tested sql 2k8.
I have just downloaded the rc0 , normaly I do some test in july.
I hope that the reactivity of Unify will be better than with the datetime
problem with Mysql

Didier

Didier Tourneur

SQL Server 2008 / Katmai

Post by Didier Tourneur » 03 Jul 2008, 18:51

 Posted by:  Didier Tourneur 

I have tested 2008 rc0 and actualy I haven't some problem with this
version.

i use td 4.2.

didier

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests