Select Statement and record locks

[maploosh]

I have a progress data base and also a SQL Server database. I am using c# to pull from the progress database and insert into the sql database. I am using simple select statements. The problem is sometimes when I run this application to refresh the data it pulls nothing because I am getting 'Record Lock' error when trying to pull from the progress database. Does anyone know a way around this?
Thanks
Matt

 

[Girish Girigowd]

Hi,
Well when you use SQL I assume you are using some ODBC connection to get to the database. When you set up your ODBC parameter if you would like the record locking not to affect your read, you should do a dirty read, this can be accomplished by setting the ODBC driver configuration to read uncommited records. More questions shoot me an email.
-Girish