ODBC connectivity to Oracle

[kaku13]

Hi,
I changed the entry in tnsnames.ora to point to a new Oracle database.
Originally the server was connecting to Oracle 8 server but the new server is
9i. Also the datasource used ODBC Socket as driver to connect to the old
database. The username/password remains unchanged. All I changed was the
hostname and SID in the tnsnames.ora file. But I get coldfusion error
"[Macromedia][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-12154:
TNS:could not resolve service name ".
I can tnsping successfully to the new server but online application throws the
above error. Is this is a problem with driver compatibility? How can I fix this?
Thanks

[paross1]

Did you Adda new ODBC datasource, or re-Configure it, using your ODBC Data
Source Administrator (Control Panel-->Administrative Tools-->ODBC Data
Sources)? You would need to do this to point your DSN to the new SID, since
that is part of the System DSN Add and Configure process.

Phil

[sdupre]

If you have Enterprise, use the build-in driver and upgrade to the latest (3.5)
[url]http://www.macromedia.com/go/42dcb10a[/url]

If you don't have Enterprise, for a better solution, try the JDBC driver from
Inet Software for a couple hundred bucks for 20 connections.
([url]www.inetsoftware.de[/url]). You're not going to get much performance from
sequelink/odbc.

Stephen Dupre
Macromedia QA