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