[Firebird-odbc-devel] (no subject)

[Jeff <in...@we...>]

Hi there, I'm facing a problem while trying to enter data into my table.

=20

=20

Versions

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Firebird 1.5

ODBC Provider 1.0.1.90

Visual Studio 2003

=20

=20

Code

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Public Sub InsertRow(ByVal myConnection As String)

        If myConnection =3D "" Then

            myConnection =3D "DRIVER=3DFirebird/InterBase(r); =
UID=3DSYSDBA;PWD=3Dmasterkey;DBNAME=3DC:\mydb\AAA.FDB;"

        End If

        Dim myConn As New OdbcConnection(myConnection)

        Dim myInsertQuery As String =3D "insert into TELEPHONENUMBERS =
(NAME, LASTNAME, COMPANY, TELEPHONENUMBER, FAXNUMBER, TELEXNUMBER, =
EMAILADDRESS, WEBSITE, MOBILENUMBER) values (@NAME, @LASTNAME, @COMPANY, =
@TELEPHONENUMBER, @FAXNUMBER, @TELEXNUMBER, @EMAILADDRESS, @WEBSITE, =
@MOBILENUMBER)"

        Dim myOdbcCommand As New OdbcCommand(myInsertQuery)

=20

        myOdbcCommand.Parameters.Add("ID", 1)

        myOdbcCommand.Parameters.Add("NAME", 2)

        myOdbcCommand.Parameters.Add("LASTNAME", 3)

        myOdbcCommand.Parameters.Add("COMPANY", "bbb")

        myOdbcCommand.Parameters.Add("TELEPHONENUMBER", 4)

        myOdbcCommand.Parameters.Add("FAXNUMBER", 5)

        myOdbcCommand.Parameters.Add("TELEXNUMBER", 6)

        myOdbcCommand.Parameters.Add("EMAILADDRESS", 7)

        myOdbcCommand.Parameters.Add("WEBSITE", 8)

        myOdbcCommand.Parameters.Add("MOBILENUMBER", 9)

=20

        myOdbcCommand.Connection =3D myConn

        myConn.Open() '<<<=3D=3D=3D=3D=3D Where the error happens!

        myOdbcCommand.ExecuteNonQuery()

        myOdbcCommand.Connection.Close() End Sub

=20

=20

Table structure

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

     ID integer,

     NAME integer,

     LASTNAME integer,

     COMPANY blob sub_type 0 segment size 80,

     TELEPHONENUMBER integer,

     FAXNUMBER integer,

     TELEXNUMBER integer,

     EMAILADDRESS integer,

     WEBSITE integer,

     MOBILENUMBER integer

=20

=20

Error

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred =
in system.data.dll

=20

Additional information: System error.

=20

=20

Would you please help me with that?

=20

=20

=20