DataAdapter.fill Dataset with error: "Input string was not in a correct format"

07-13-2012, 10:47 AM

commodore64 commodore64 is offline

Newcomer

Join Date: Jul 2012

Posts: 2

DataAdapter.fill Dataset with error: "Input string was not in a correct format"

Hi all,
I have a problem when i fill a dataset with a query return via ODBC via Oracle.
The program work well from many month. I think, but I'm not sure, that the problem is the field "Price" that return in a record for the first time value 0,78 (so far it has been always greater than 1).
The code is:

Code:

    Dim cmd As New Odbc.OdbcCommand
    sql = "SELECT * FROM....
    cmd.CommandText = sql
    cmd.CommandType = CommandType.Text
    cmd.Connection = DB
     
     
    Dim da As New Odbc.OdbcDataAdapter
    da.FillLoadOption = LoadOption.OverwriteChanges
     
    da.SelectCommand = cmd
    da.Fill(ds, "TABLE11")

Please, can anyone help me? Thanks

07-14-2012, 12:22 PM

commodore64 commodore64 is offline

Newcomer

Join Date: Jul 2012

Posts: 2

Resolved

Hi,
I have resolved the problem changing the ODBC property "Numeric Setting" from "Use Oracle NLS setting" at "Use Microsoft regional setting".
I hope this post is useful for someone.
Bye

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules