Re: What an error message...

>Now, I get the following error:
>A serious error occurred.
>ODBC Engine is unable to supply native error code and error
>description.

Okay, I fixed this error by not testing this procedure from another
procedure. However, there is still a problem when I uncomment the
CityName argument.

When I try calling the stored procedure from Pervasive's .NET data
provider, I get the following exception:

"Input string was not in a correct format"

I'm passing a simple string, "Test". However, when I look at the
parameter for the command object it's properties are as follows:
DbType: Int32
Precision: 10
PsSqlType: Integer
Scale: 0
Size: 4

I used CommandBuilder to generate the command and parameters. I was
expecting to see VarChar as the DbType? But then again, the other
parameters used Decimal as the DbType - so I don't know what to think
anymore

.

Relevant Pages

  • Re: dataadapter update problem, (please help!)
    ... Okay so now we need to figure out what the command text's are of the various ... >>> some day i''m gona pay this forum back for all the help i''m getting ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Tar Question on the -T option
    ... > Okay, so of course its just tar, taking input from the find command. ...
    (comp.unix.admin)
  • Re: Add a context menu item to Windows Explorer (Win98) with VB6?
    ... Okay, it's really not all that complicated. ... Proprietary format, exe files, ... will accept a command line from the shell to do whatever it is you want to ... | Write a VB6 program. ...
    (microsoft.public.vb.general.discussion)
  • Re: Good Linux distro for old computer
    ... needs 12MB of RAM (okay, that was stupid. ... Also when I typed a command it took the computer a minute or so to ...
    (comp.os.linux.hardware)
  • Command pattern: Interaction allowed?
    ... In a command of the command pattern, would you say that interactions or ... What is not okay - I know. ... model then the business model has to trigger the UI somehow (callbacks, ...
    (comp.object)