Re: connect oracle database error, vbscript.

bigbinc_at_hotmail.com (bigbinc) wrote:

>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.

Everybody was a newbie once...
We learn more from things that do not work then we do from those that do

----== 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 Wed May 14 2003 - 19:04:11 CEST