How to set lockmode in odbc connection.

[khizar khan]

Hi,

It will be of very great help if any body can let me know how to set "set lockmode session where readlock=nolock" when connection via odbc.

one way is to do it with ING_SET set in config.ing. is there anyother way?

thanks for your help.

--
Thanks and Regards,
Khizar

[Russell Neal]

Hi Khizar,

 

I am guessing you found the note about config.ing in a document in our knowledge base about the Intersolv ODBC driver.  This is for a very old version of ingres, config.ing was replaced by config.dat and we stopped using the Intersolv driver at about Ingres 2.0.  I am going update these KB documents!

You have not actually said what version of Ingres or ODBC you are using - that is always a good thing to include when asking a question like this. 

 

If you want to set the lockmode permanently on the server, issue this command (on the server):

ingsetenv ING_SET "set lockmode session where readlock=nolock"

 

If you want to set the lockmode dynamically from within the client application, use the ODBC API SQLSetConnectOption ('set lockmode session where readlock=nolock') or SQLExecDirect ('set lockmode session where readlock=nolock')

 

If you have any problems with the above, feel free to log a support issue.

 

Hope this helps.

 

Thanks and regards,

 

Russell Neal
Technical Consultant
Ingres Corporation
russel...@ingres.com

PHONE 1800 614 435
www.ingres.com

This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.

 

---

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of khizar khan
Sent: Tuesday, August 11, 2009 12:47 AM
To: openroa...@googlegroups.com
Subject: [openroad-users] How to set lockmode in odbc connection.

[Russell Neal]

Hi Khizar,

 

I have been advised that my previous e-mail was not quote correct.

To set the lockmode permanently for all connections, remote and local, including ODBC, run cbf on the server, go down to "DBMS server" and press configure, then set system_readlock to nolock and save.

 

Thanks and regards,

 

Russell Neal
Technical Consultant
Ingres Corporation
russel...@ingres.com

PHONE 1800 614 435
www.ingres.com

This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.

 

---

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Russell Neal
Sent: Monday, August 17, 2009 4:45 PM
To: openroa...@googlegroups.com
Subject: [openroad-users] Re: How to set lockmode in odbc connection.

[khizar khan]

Thanks Neal,

I am using ingres 3.5 (3.5.00.76) version of odbc driver.

Yes, in future I will ensure to add information of drivers or software versions I am using. Thanks a lot for your help.

Regards,
Khizar