On 29 Mar 00, at 15:12, Jeremy Smyth wrote:
> Round 7 in our "Let's squeeze a few linux boxes into an MS-Partner site":
>> Is there anything I can use to run arbitrary SQL commands against an NT
> Oracle server?
>> I'm effectively looking for something like Oracle's own SQL worksheet, only
> it'll run on Linux. And I haven't a bog about getting a connect-string to
> work from linux to NT...
> (...and the less money I have to ask Mr IT manager for the better)
You could try and find the Oracle Client libraries and/or Enterprise
Manager for Linux (downloading the entire installation would probably be a
bit of overkill). Client libs will give you sqlplus, enterprise manager
should give you all the nifty gui tools.
You could get the oracle jdbc thin drivers (very small download) and run a
jdbc sql-worksheet-style java app (lots to choose from) if you've got a
JVM on the linux box.
Connect strings to NT should be the same as to any other platform. Hint:
copy tnsnames.ora and sqlnet.ora from the NT box if you're installing the
client libs on the linux box.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!