all groups > sql server dts > april 2004 >
You're in the

sql server dts

group:

Data from Oracle


Data from Oracle Michael V
4/28/2004 5:41:03 AM
sql server dts: Need to have access to data in an oracle base from visual basic. Ideally I would just connect to
a database and get records from an oracle table using some kind of connection string

However - I dont' think this can be done without the oracle client installed on the machine fro
which i'm running my script - and it won't be

What is to be done ? Can I enclosse a tnsnames - file from oracle with application and then connect to
oracle without the total client

Or will I have to transfer data using dts to sql

Re: Data from Oracle Michael Vardinghus
4/28/2004 7:48:48 PM
Found something about linked server and actually think that will do the
trick a lot better than by transporting the data...

Tried it on my machine...seems to do the trick.



"Michael V" <anonymous@discussions.microsoft.com> skrev i en meddelelse
news:5EFF6247-CBCF-4ACA-BEA4-776297AA732C@microsoft.com...
[quoted text, click to view]

AddThis Social Bookmark Button