Re: connect oracle database error, vbscript.

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 13 May 2003 15:59:23 -0500
Message-ID: <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 =--- Received on Tue May 13 2003 - 22:59:23 CEST

This message: [ Message body ]
Next message: Jay Miller: "Problems with OCI in embedded app"
Previous message: KULJEET: "web.show_document to call report parameter form"
In reply to bigbinc: "connect oracle database error, vbscript."
Next in thread: TurkBear: "Re: connect oracle database error, vbscript."
Reply: bigbinc: "Re: connect oracle database error, vbscript."
Reply: TurkBear: "Re: connect oracle database error, vbscript."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message