Invalid Number error with OLE DB provider and Oracle

B

Bryan

Hello, I am running into a problem using the OLE DB
provider for Oracle with my VB.NET application.
Basically, if the user modifies their regional settings on
their PC to switch the decimal separator and the group
separator, my code throws an error whenever I try to
insert or update a record in my database, where one of the
fields involved is a decimal value with non-zero digits
after the decimal point. I am using parameterized
queries, which fixed this problem when running my app
against SQL Server. I should note that I use the managed
data provider for SQL Server, rather than OLE.

Is there a way to fix this problem? Will I need to move
to one of the managed providers for Oracle? If so, do any
of the managed providers support Oracle 8.0.4?

Any suggestions will be greatly appreciated,
Bryan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top