Home » Infrastructure » Windows » OLEDB and Excel
OLEDB and Excel [message #276170] Wed, 24 October 2007 04:41 Go to next message
NeluDima
Messages: 2
Registered: October 2007
Location: Vienna, Austria
Junior Member
Hi All,

I am currently use OLEDB in VBE to read some data from ORACLE into an excel query sheet with the following connect string
"OLEDB;Provider=MSDAORA;User ID=x;Password=x;Data Source=x;"
where UserId is a ReadOnly user.

Are the ORACLE Tables/Rows during the select (without "for update") locked ?

br nd
Re: OLEDB and Excel [message #276180 is a reply to message #276170] Wed, 24 October 2007 05:12 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, they are not.

Check this recent topic about the same subject.
Re: OLEDB and Excel [message #276251 is a reply to message #276180] Wed, 24 October 2007 09:06 Go to previous message
NeluDima
Messages: 2
Registered: October 2007
Location: Vienna, Austria
Junior Member
Thanks!
Previous Topic: oracle.exe running
Next Topic: sqlplus / as sysdba
Goto Forum:
  


Current Time: Thu Apr 17 00:34:09 CDT 2014

Total time taken to generate the page: 0.13845 seconds