Skip to Content
0
Former Member
Mar 03, 2009 at 09:14 AM

which connection type to use when there is a insert operation.

18 Views

I have a requirement in our report which is as follows:

1.Insert some data to a temporary table

2.And then get data from that temporary table and display in the report.Both insert and select should happen in the same session.

I tried this using ODBC(RDO) connection by creating a system DSN.But it gives the below error :

"may not perform insert/delete/update inside a read only transaction"

I had set the Read-only connection for System DSN as 'False' but still getting the above error.

Which connection has to be used for the above scenerio?