OLEDB COnnection String to Oracle

[Jon Spartan]

Does someone know the proper connection string for using OLE DB
connection to an oracle server ?

Jon Spartan

[Ray at]

Go here [url]http://www.connectionstrings.com/[/url] and then press Ctrl+D or Ctrl+B at
once!

Ray at home

"Jon Spartan" <jonu@ixtech.net> wrote in message
news:ll89hvkm4enu2fv41p3vqfjn91637tj5vq@4ax.com...

> Does someone know the proper connection string for using OLE DB
> connection to an oracle server ?
>
> Jon Spartan

[Jon Spartan]

Would it be possible to talk on tis via private email ?

I tired this, works nice, but I am having problems getting to
something in the DB and cannot figure out why.

I can get there from SQL no porble, but using an ASP db connections
only returns one portion of the intfromation I need.

I can email you the schema and the problem.

Jon

On Tue, 15 Jul 2003 20:57:07 -0400, Jon Spartan <jonu@ixtech.net>
wrote:

>Does someone know the proper connection string for using OLE DB
>connection to an oracle server ?
>
>Jon Spartan

[Ray at]

No private e-mails. That's what usenet is for. There may be someone else
having the same problem and he will come across this and find his solution,
assuming we can come up with one! :] But, if you'd like to e-mail me
privately and invite me out for a beer, feel free. ray at lane34 dot com.

Ray at home

"Jon Spartan" <jonu@ixtech.net> wrote in message
news:dj0bhvg9jo67osmr3hsr0mg7ikqe0qbp9a@4ax.com...

> Would it be possible to talk on tis via private email ?
>
> I tired this, works nice, but I am having problems getting to
> something in the DB and cannot figure out why.
>
> I can get there from SQL no porble, but using an ASP db connections
> only returns one portion of the intfromation I need.
>
> I can email you the schema and the problem.
>
> Jon
>
> On Tue, 15 Jul 2003 20:57:07 -0400, Jon Spartan <jonu@ixtech.net>
> wrote:
>

> >Does someone know the proper connection string for using OLE DB
> >connection to an oracle server ?
> >
> >Jon Spartan

>

[Peter Chong]

Oh well, you could download whole Oracle viewer Program from
download section of [url]www.exmlsoft.com[/url]
just edit Oraconn.asp to your DB space, User ID & Password...

Jon Spartan <jonu@ixtech.net> wrote in message news:<ll89hvkm4enu2fv41p3vqfjn91637tj5vq@4ax.com>. ..

> Does someone know the proper connection string for using OLE DB
> connection to an oracle server ?
>
> Jon Spartan

[Jon Spartan]

I am msssing some tables when I use an OLE DB connection to an Oracle
server.

My connecton string is -

'Provider=msdaora;DataSource=MyDataBase;UserId=Use rID;Password=UserPassword;'

I have a structure as soon in my Oracle Enterprise Manager as -

network -
databases

- MyDataBase

- schema

- table

- COMMON

- List Of Table Names

- MYDataBase

- List Of Table Names

- IMPORTANT

- List Of Table Names

When I use the OLE DB connection above I can see everything in
"MyDataBase", but nothing in COMMON or IMPORTANT.

If I make each of them a seperate connection using as DataSource =
MyDatabase another with DataSource = COMMON and another as DataSource
= IMPORTANT I can see the proper tables in MyDatabase, I see no tables
under the COMMON connection, nor any under the IMPORTANT connection.

Thus my question becomes - HOW do I see all the tables located under
each section ?

My linked server in SQL works just fine and I have no problems.
However in this case I need to do some things in the COMMOM and
IMPORTANT sections in ASP.

Any Advice ?

Jon Spartan


On Tue, 15 Jul 2003 20:57:07 -0400, Jon Spartan <jonu@ixtech.net>
wrote:

>Does someone know the proper connection string for using OLE DB
>connection to an oracle server ?
>
>Jon Spartan