InterBase Store Procedure Call

  • Thread starter Thread starter Christopher Weaver
  • Start date Start date
C

Christopher Weaver

Has anyone here used VS 2003 to successfully call a stored procedure in
InterBase 7.5 using the ODBC driver that it ships with?

If so, how did you do it?

Thanks.
 
Christopher said:
Has anyone here used VS 2003 to successfully call a stored procedure
in InterBase 7.5 using the ODBC driver that it ships with?

If so, how did you do it?

Thanks.
Click to expand...

I have never used the ODBC driver, but the BDP Drivers provided in
Delphi 2005 work really well with InterBase.
 
I have never used the ODBC driver, but the BDP Drivers provided in
Delphi 2005 work really well with InterBase.
Click to expand...

Do they work with VS 2003 and do I have to buy D2005 to get them?

If you did use VS 2003, could you show me the syntax the you used? Perhaps
I'm doing something wrong.
 
Christopher Weaver said:
Do they work with VS 2003 and do I have to buy D2005 to get them?

If you did use VS 2003, could you show me the syntax the you used?
Perhaps I'm doing something wrong.
Click to expand...

Id avoid ODBC at all costs. Im using Firebird and its .NET provider is
excellent. Im not sure if the FB .NET provider will work with IB instead of
FB though.
 
Christopher said:
Do they work with VS 2003 and do I have to buy D2005 to get them?

If you did use VS 2003, could you show me the syntax the you used?
Perhaps I'm doing something wrong.
Click to expand...

yes they work fine in VS 2003, I believe the only way to get the
drivers is to get D2005. They use all of the standard ADO.NET
interfaces so they work great with .NET.
 
I have Borland.Data.Interbase and Borland.Data.provider but I have no
documentation and don't know how to install them in the VS Toolbox or if it
is possible. Are these the drivers that come with D 2005? Any docs on
these that you can direct me to would be great.
 
Christopher said:
I have Borland.Data.Interbase and Borland.Data.provider but I have no
documentation and don't know how to install them in the VS Toolbox or
if it is possible. Are these the drivers that come with D 2005? Any
docs on these that you can direct me to would be great.
Click to expand...


There are no doc that I know of on how to install them into VS.. But
you need install Borland.Data.Common.dll and Borland.Data.Provider.dll
assemblies just like you would any other assembly. Then the rest is
the similar to the rest of ADO.NET.

BdpConnection implements IDbConnection
BdpCommand
bdpDataReader
bdpDataAdapter

So you can look up, sqlConnection,SqlCommand, etc.. and it will be
similar.
 
Thanks Robert. Looks like I'll be writing it by hand and feeling my way
along.
 
Back
Top