oracle9iodbc error [message #59874] |
Tue, 30 December 2003 21:04 |
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 |
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 |
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 |
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 |
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
|
|
|
|