If SQL Server objects to automatic conversion from internal format, you'll just have 
to play it's (Microsoft's) game, and provide a string in ODBC-compatible external 
format ("YYYY-MM-DD"), and use SQL.B.DEFAULT.

----- Original Message -----
From: Mark Warner <[EMAIL PROTECTED]>
Date: Wed, 04 Feb 2004 21:17:11 -0600
To: [EMAIL PROTECTED]
Subject: Universe Date Conversions Using the SQL.B.INTDATE

> I've been trying to get a date conversion to work for data being inserted
> into a SQL/Server table with no success.  When I use the SQL.B.INTDATE and
> SQL.DATE parameters in the SQLBindParameter statement, I get the following
> error:
> 
>  
> 
> Status for SQLExecute call is: -1 SQLSTATE,NATCOD are:S1C00  0 
> 
> Error text is: [IBM][SQL Client][ODBC][Microsoft][ODBC SQL Server
> Driver]Optional feature not implemented
> 
>  
> 
> I've tried multiple formats and combos with no success.  I'm running on
> IBM/U2 Release 10.0.10
> 
>  
> 
> As always with this group, that's for the great help..
> 
>  
> 
> Mark Warner
> 
<< winmail.dat >>

>
> -- 
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to