| Does ODBC connection from INFORMIX DB to MS ACCESS has committed read on the data? [message #462943] |
Mon, 28 June 2010 15:46  |
s.vishalkumar@gmail.com
Messages: 22
Registered: July 2007
|
Junior Member |
|
|
I have created an ODBC Connection between Informix Database and MS Access, and I am accessing those tables data using MS Access. Does this lock the tables, and if there are any updates to be made on those table, will those update jobs fail while I am using the data.
I have got few colleagues who say that, MS Access has a commited Read, and I need to set the flag to no, so that if there were any underlying process updates on these tables, the process would not break.
Can you please let me know if this really happens. I was under the assumption that If I am making an ODBC connection, then I am only reading it as an interface and all the other processes would scuccessfully run.
Any kind of help is greatly appreciated
[MERGED by LF]
[Updated on: Tue, 29 June 2010 14:55] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Does ODBC connection from INFORMIX DB to MS ACCESS has committed read on the data? [message #462947 is a reply to message #462944] |
Mon, 28 June 2010 16:22  |
s.vishalkumar@gmail.com
Messages: 22
Registered: July 2007
|
Junior Member |
|
|
Actually I have three different source systems from which I have migrate the data.
source1 : informix
source2 : visual foxpro
source3 : sql server 2005
I am accessing these data sources using ODBC connection I have made and then exporting the data as data files into Oracle which is the target.
But the question, I have asked has nothing to do with ORACLE.
It is a question regarding ODBC and MS Access. As I do not know where to post, I saw that there is more activity in this particular group, so I thought I would definitely get some input.
So, can you help me in resolving the issue.
Thanks,
Vishal;
|
|
|
|
|
|
|
|
|
|
| Re: Does ODBC connection from INFORMIX DB to MS ACCESS has committed read on the data? [message #462956 is a reply to message #462954] |
Mon, 28 June 2010 18:55 |
s.vishalkumar@gmail.com
Messages: 22
Registered: July 2007
|
Junior Member |
|
|
Lets say, you are accessing the informix tables data thru MS Access, and around 8:00 PM there is a process which updates these tables everyday. Now as I am reading the data the process might break as there will be locks on the table.
I am not sure if this is the case but, as I am reading the data and the data is committed, and it does not encourage any update processes to run.
This would be my definition. But that is what I want to know, does it really lock the tables when I am accessing the tables data theu ODBC connection.
All these days i was just thinking that ODBC connection is just like an interface to the original database, and the whole reason behind acccessing these tables is not to mess up the original tables.
Any kind of help is greatly appreciated.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
