Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pavan27
Starting Member
8 Posts |
 Posted - 2007-05-23 : 15:10:38
|
| hai to every one,i have one problem. when i am trying to connect oracle dtabase thourgh sql server import wizard.i am trying to import data from oracle to sql server 2000.i entered server name = orclusername =scottpassword=tigeri checked for test the connection i am getting the error.ora 12170 tns : connect time occuredwhat could be the problem. how can i rectify itpavanAssociate Oracle DBA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-23 : 22:50:26
|
| Can you connect to Oracle with sql plus or odbc from sql server? |
 |
|
|
pavan27
Starting Member
8 Posts |
Posted - 2007-05-24 : 12:07:15
|
| yes i am connecting oracle with sql plus..i don't know what is the problem . any suggestionspavanAssociate Oracle DBA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 13:11:56
|
| Which provider did you use? Tried with odbc provider? |
|
|
|
|
|
|
ora 12170 tns : connect time occured