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

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, they are not.

Check this recent topic about the same subject.

Report message to a moderator

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!

Report message to a moderator

Previous Topic: oracle.exe running
Next Topic: sqlplus / as sysdba
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 11 23:06:07 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.