troubleshooting Question

Oracle connection string in vb .net

Avatar of leorocha
leorocha asked on
Oracle DatabaseVisual Basic.NET
10 Comments1 Solution878 ViewsLast Modified:
This is my connection string:
            ordSelCon.ConnectionString = "Data Source=test.world;Integrated Security=no;User ID=GLF;Password=PRIMERA1"
            ordSelCon.Open()

This work fine in my windows form proyect.

Now, I'm developing a windows service inside the same solution. When I use the same connection string inside the service I get the follwing error: ORA-12154 TNS:could not resolve the connect identifier specified.

The TNSNAMES.ORA is on local machine.

It seems to be a permissions problem, I guess but I'm not sure. Also was tested using another account (with administrator privileges) and fails again.

Need help to solve this issue. Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros