Re: connect oracle database error, vbscript.

From: bigbinc <bigbinc_at_hotmail.com>
Date: 14 May 2003 09:57:43 -0700
Message-ID: <d1b33313.0305140857.11f4e486_at_posting.google.com>


TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<i2n2cv0bi8ob87cmka93msit5iv6cltau1_at_4ax.com>...
> bigbinc_at_hotmail.com (bigbinc) wrote:
>
> >I am trying to connect to a oracle database
> >where the webserver is seperate from the oracle server. I am trying
> >to connect with these two strings.
> >
> >'connectStr = "Provider=OraOLEDB.Oracle.1;Server=PMT-ORACLE;Database=sde;Uid=dorsey;Pwd=dorsey;"
> >connectStr = "Provider=OraOLEDB.Oracle.1;Data
> >Source=gisoracle;Uid=dorsey;Pwd=dorsey;"
> >
> >adoCon.Open connectStr
> >
> >This is my one error.
> >
> >Error Type:
> >OraOLEDB (0x80004005)
> >ORA-12154: TNS:could not resolve service name
> >/Website/pipeseg/test/b.asp, line 31
>
> Which string causes the error..
> Anyway what it means is that the tnsnames.ora file on the web server does not have correct
> information for gisoracle or sde ( depending on which connection string you mean)
>
>
>
>
> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

It was a simple problem, thanks for the help, I am such the newbie. Received on Wed May 14 2003 - 18:57:43 CEST

Original text of this message