ODBC and insert statement...

[Jimmy]

I am using ODBC namespace to communicate with my legacy system. since there
are no stored procedure supported in the legacy system, I would like to know
which object I should use to insert a new record to legacy system using ODBC
namespace objects.
Whenever I use SQL Server as backend I have used command object and called
the stored procedure to update the database.
Please advce.
Jimmy

 

[William Ryan eMVP]

You can still use the command object..just set its CommandType property to
..Text

 

[Miha Markic [MVP C#]]

Hi William,

You can still use the command object..just set its CommandType property to
.Text

You probably mean .StoredProcedure as op was using stored procs.