|
 |
activex_data_objects thread: ODBC vs. OLEDB
Message #1 by "Tony" <one_dev@h...> on Wed, 20 Jun 2001 16:33:08 -0500
|
|
Has anyone experienced differences (issues) using ADO with an ODBC
connection vs OLEDB?
When try to execute a command (cmd.execute) using a ODBC for SQL Server
connection, I get an error saying the connection is busy with another
hstmt..........??? I have no idea what that means.
When I run the exact same code with an OLEDB connection, it works fine.
Problem is, I'm supposed to be using ODBC...
Any help or suggestions would be greatly appreciated.
Message #2 by "Tomm Matthis" <matthis@b...> on Thu, 21 Jun 2001 06:34:41 -0400
|
|
Why would you want to use ODBC? IMHO, Ole-Db is much faster, and much less
prone to weird errors ....
-- Tomm
> -----Original Message-----
> From: Tony [mailto:one_dev@h...]
> Sent: Wednesday, June 20, 2001 5:33 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] ODBC vs. OLEDB
>
>
> Has anyone experienced differences (issues) using ADO with an ODBC
> connection vs OLEDB?
>
> When try to execute a command (cmd.execute) using a ODBC for SQL Server
> connection, I get an error saying the connection is busy with another
> hstmt..........??? I have no idea what that means.
>
> When I run the exact same code with an OLEDB connection, it works fine.
> Problem is, I'm supposed to be using ODBC...
>
> Any help or suggestions would be greatly appreciated.
>
>
>
> matthis@b...
> $subst('Email.Unsub')
>
>
|
|
|
View Cart
