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 |
|
kgundava
Yak Posting Veteran
66 Posts |
 Posted - 2011-07-18 : 14:28:55
|
| Hi All, I am Connecting to the oracle via linked server from Oracle.I am using ODBC to connect to it.But when i execute a Except query i am getting the below error.Msg 7305, Level 16, State 2, Line 1 Cannot create a statement object using OLE DB provider "MSDASQL" for linked server Pleas Let me know what might be the issueThanks.... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-18 : 15:04:19
|
| You need to use an Oracle provider |
 |
|
|
kgundava
Yak Posting Veteran
66 Posts |
Posted - 2011-07-18 : 15:13:19
|
| Thanks for the reply.unfortunately i would have to use the ODBC Provider for the Communicating with oracle server(requirement). Please let me know the reason for the error if possible. Thanks. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-18 : 21:15:44
|
| Any "requirement" that "requires" you don't use an Oracle provider also "requires" that you don't talk to Oracle.You should download and install the Oracle driver. What version of Oracle?MS and Oracle each have one. I'll use the Oracle one. Also, is this a 32 or 64 bit system? |
|
|
|
kgundava
Yak Posting Veteran
66 Posts |
Posted - 2011-07-19 : 13:54:34
|
| We are using the Linked server for data validation and hence we want both oracle and attunity databases to use the same api to access the data.so we picked ODBC.That the reason why i have to use ODBC to connect to oracle.Also we are on a 32 bit machine.Thanks.... |
|
|
|
kgundava
Yak Posting Veteran
66 Posts |
Posted - 2011-07-19 : 13:54:35
|
| We are using the Linked server for data validation and hence we want both oracle and attunity databases to use the same api to access the data.so we picked ODBC.That the reason why i have to use ODBC to connect to oracle.Also we are on a 32 bit machine.Thanks.... |
|
|
|
|
|
|
Linked server error!!HELP!!!