Hi,
When I'm using SQL server 2005, and ODBC drive ※SQL Native Client§ I get an error when executing the below given code. Error Message: ※Transaction cannot start because more than one ODBC connection is in use.§
But this works well with SQL Server 2000 with ODBC drive "SQL Native Client" and in SQL server 2005 also when I used ODBC drive ※SQL Server§.
I used aTrgConn.Execute(※Begin Transaction§) and it's working properly. But unfortunately I cannot use this method, because I want to run the same code with Oracle ODBC as well.
Is this a known issue in SQL Native client drive with SQL server 2005 Do you know a solution for this
Please Help..............
Thanks in advance.
Code:
Dim aTrgConn As New ADODB.connection
Dim aCmdIns As New ADODB.Command
Dim aCmdUpd As New ADODB.Command
aTrgConn.Open sConnStr
Set aCmdIns.ActiveConnection = aTrgConn
Set aCmdUpd.ActiveConnection = aTrgConn
aTrgConn.BeginTrans