Oracle Issue - F1 Please

[Deadline]

Hi,
Actually I am required to write an program that will be scheduled to run once every night.

In that program I am making a connection to ORacle to fetch list of email addresses and Employee Names and insert that info into an Access database. In my machine I have a DSN to the Oracle Server but no Oracle Client COmponents. I am on Win 2000 platform. It works fine when running in my machine.

When I run the same program the server(WinNT 4 Server), where it is supposed to run actually, it returns me an error that reads like this -

Microsoft OLE DB Provider for Oracle-ORA-12154: TNS:could not resolve service name
--2147467259

The connectivity to Oracle server isn't an issue because, when I attempted to login using the SQL*Plus in the server using the same user name and password as in my code, it perfectly gets into it and I am able to make queries and stuff.

It works here and not there... What could be the reason ??


F1 me please...
Thank you very much.

RR

 

[Deadline]

UPDATE:

I discovered that my PC has Oracle Client components installed in it. But the shortcuts weren't present and hence it skipped my notice.

Here is my VB Connection string.

"Provider=MSDAORA.1;Password=xxxxx;User ID=xxx01;Data Source=hrsp;Persist Security Info=True"

Help please Thank you very much.

RR