Connection string issue with Win 7

[kawi6rr]

We’ve been using this DB for years now on Win XP; we are being switched out with new Win 7 machines. For some reason this code below gives me the following error in Win 7 but has been working fine for years in Win XP.
connectStr = "Provider=msdaora;Data Source=HIDW.WORLD;User Id=xxxxx;Password=xxxxx"
Error:
Run-time error ‘-2147467259 (80000-4005)’:
ORA-121454: TNS: could not resolve the connect identifier specified
Is there something I need to do in the code for Win 7? Any help is appreciated, thanks.

 

[jdraw]

Talk to your Oracle DBA. I have a feeling that the TNSnames entry has been moved to a new location, or hasn't been set for your new WIN 7 configuration. Perhaps it's on a drive that is mapped, and you don't have the mapping.....

 

[kawi6rr]

Thanks for the response. I actually checked the tnsnames file and added in the connection string that's needed. I was even able to create an ODBC connection on the machine and it tested correctly.

I was hoping it was just that Win 7 is more locked down then XP and people were having similar issues. All the searching I did concerning the error pointed to what you suggested but I checked and that doesn't seem the issue for this one.

 

[kevlray]

You did not say whether you were using 32-bit or 64-bit. I think most of Oracle drivers are 32 bit. We have had issues with an application looking for the 64-bit driver and it not being there. I know there are some 'fixes' for Windows 7 64-bit. I do no know if this applies in your case.

 

[kawi6rr]

Thanks for the response I'll find out!