Re: ODBC & Transactions?

Mike Miller wrote:
>
> > Mumble, can you show us the exact VB code you are using to
> > send these queries? Maybe it can help... (well, it would be
> > excellent if you could post a stripped down test case starting
> > from connection, query execution, etc. that shows the behaviour
> > you are experiencing)
>
> '**********************************************************
>
> Dim adoConnection As ADODB.Connection
> Dim strADOConnection As String
>
> '**********************************************************
>
> Sub ConnectDB()
>
> ' Create the ADO object
> Set adoConnection = CreateObject("ADODB.Connection")
>
> ' Set up the connection string to the database
> strADOConnection = "DSN=PostgreSQL"
>
> ' Open the connection
> With adoConnection
> .ConnectionString = strADOConnection
> .Open
> End With
>
> End Sub
>
> '**********************************************************
>
> Sub DisconnectDB()
>
> ' Close connection
> With adoConnection
> .Close
> End With
>
> ' Clean up
> Set adoConnection = Nothing
>
> End Sub
>
> '**********************************************************
>
> Function SQLCommand(strSQL As String) As Integer
>
> ' Variables
> Dim adoCommand As ADODB.Command
> Dim lngRecordsAffected As Long
>
> ' Create the ADO command object
> Set adoCommand = CreateObject("ADODB.Command")
>
> ' Set the connection, the command and execute it
> With adoCommand
> .ActiveConnection = strADOConnection

How about
.ActiveConnection = adoConnection
?

regards,
Hiroshi Inoue