ODBC - SQL State 08004
444893Jun 1 2005 — edited Jun 1 2005Hi all,
I have got the follwing problem:
Odbc test fails on one machine with the following error:
--------
unable to connect
SQL State=08004
ODBC-the service name could not beresolved
--------
- I have only one ORA Home
- I have copied the TNSNames.ora from a running machine
- I reinstalled everything (it is an automated install and it works for other boxes)
- With filemon from sysinternals I can see that the tnsnames.ora is opened
- There is no network activity during odbc test (but I can see a ping with netmon)
- TNSAdmin is set in registry
The only difference I can see between the boxes is that on the box where the error occurs I have also MSDE running.
I copied also the odbc.ini and oradbc.ini from a working box.
Oracle Client Version is 9.0.1
Somebody an Idea?