PowerBuilder11.0 : SQL Azure : SQL Server Native Client 10.0

[Former Member]

while connecting powerbuilder application to SQL Azure using ODBC(DSN) getting this error on datawindow update.

ERROR [22008] [Microsoft][SQL Server Native Client 10.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.

Any help will be greatly appreciated.

Thank you
Arun Kumar Pal

[Former Member]

You need the following in your connection string:

Constant String PBDateTimeFmt = "DateTime=''{ts '\'yyyy-mm-dd hh:mm:ss.fff\''}''"

I have a SQL Azure connection example on my website:

Topwiz Software - SQLAzure

[Former Member]

Hi;

• What's the statment you want to fire?
• What the table schema you are targetting on?
• Do you use datetime, datetime2 or smalldatetime datatype?

best regards

[Former Member]

used smalldatetime in table