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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-04-11 : 13:31:27
|
| I am unable to acces Oracle from legacy DTS designer, here is what I have done, 1. I have kept my old DTS packages in SQL2K5 legacy DTS container 2. Now I am unable to access oracle; it gives provider error3. I am able to connect oracle from SQLPLUS How can I troubleshoot this problem?------------------------I think, therefore I am - Rene Descartes |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-11 : 13:38:30
|
| What is the equivalent of ODBCAD32.EXE for OLEDB providers?------------------------I think, therefore I am - Rene Descartes |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-11 : 14:15:57
|
| Is it 64-bit SQL server? |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-11 : 14:19:31
|
| yes!------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-11 : 14:22:33
|
| They don't have a provider like 32-bit server.But they have a workaround for Oracle provider.Check oracle Forum.You should get it |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-11 : 14:26:27
|
| Thanks. I will check this. ------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-12 : 00:25:12
|
| Microsoft has released ODBC providers(MSDASQL) in 64-bit edition of SQL server.Check it out |
|
|
|
|
|
|
Unable to access Oracle from legacy DTS designer.