Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 17, 2015 at 02:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2015 at 08:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded