Home » RDBMS Server » Server Administration » oracle9iodbc error
oracle9iodbc error [message #59874] Tue, 30 December 2003 21:04 Go to next message
rajitha
Messages: 19
Registered: July 2002
Junior Member
i tried to connect erwin desing tool to oracle 9i thru odbc.i created one DSN and tested its ok but i am not able to connect to oracle.i tested all odbc providers for oracle microsoft odbc for oracle,
oracle for oracle92, odbc for oracle rdb,
but its not giving any errors
pls hlp
rajitha
Re: oracle9iodbc error [message #59884 is a reply to message #59874] Wed, 31 December 2003 01:52 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Can u explain little more that wht exactly is happening if it is not giving u any error? I think it should show some error if anything is going wrong at either side.
Re: oracle9iodbc error [message #59891 is a reply to message #59884] Thu, 01 January 2004 20:30 Go to previous messageGo to next message
rajitha
Messages: 19
Registered: July 2002
Junior Member
hi
my problem is i am using designer tool Erwin to modeling.When i am trying to connect oracle9i server i am not able to connect.its not showing any error.i am giving username,password and connect string.The sqlplus tool is working properly.its just gives one blink
no error message.the i created one DSN the tesing connection is working properly andagain i am not able to connect
pls hlp
Re: oracle9iodbc error [message #59894 is a reply to message #59891] Fri, 02 January 2004 00:19 Go to previous messageGo to next message
Srinivas
Messages: 138
Registered: June 2000
Senior Member
Hi..

What version of Erwin tool u r using ??

To connect to Oracle 9i, u need to have greater versions of ERwin 3.5

Provide connect string value (as in TNSNames.ora file)instead of DSN name.

Hope this helps.

Bye..
Srinivas
Re: oracle9iodbc error [message #59902 is a reply to message #59884] Fri, 02 January 2004 05:00 Go to previous messageGo to next message
rajitha
Messages: 19
Registered: July 2002
Junior Member
hi
my problem is i am using designer tool Erwin to modeling.When i am trying to connect oracle9i server i am not able to connect.its not showing any error.i am giving username,password and connect string.The sqlplus tool is working properly.its just gives one blink
no error message.the i created one DSN the tesing connection is working properly andagain i am not able to connect
pls hlp
Re: oracle9iodbc error [message #59917 is a reply to message #59894] Sat, 03 January 2004 23:51 Go to previous message
rajitha
Messages: 19
Registered: July 2002
Junior Member
i am using erwin4 i give the connect string in tnsnames but no errors or
nor connection
Previous Topic: discover Oracle 8i bg process sid on Windows NT
Next Topic: Export Issues
Goto Forum:
  


Current Time: Fri Sep 20 10:40:51 CDT 2024