l*****O
发帖数: 402 | 1 Just installed oracle client 11g.
sqlplus is accessing the db fine.
even visual studio 2008 server explorere data source connection fine
however whiling using openquery to access the oracle database, it keeps
giving me the error Message 7303.
sp_testlinkedserver fails too. So I guess the connection is not there.
What's the problem?
Please help~~~ bow~~~ | v*****r
发帖数: 1119 | 2 You probably need to follow this to troubleshoot.
http://support.microsoft.com/kb/280106 | l*****O
发帖数: 402 | 3 Thank you. Uninstalled 11g, installed 10g. Now it works. I guess it must
have something to do with the OracleOLE DB provider coming with 11g. By the
way, visual studio 2008 Server Explorer Data source connection doesn't work
with 10g provider now.
I use MS SQL Server 2005. So maybe 2005 compatible with 10g. 2008 compatible
with 11g.
【在 v*****r 的大作中提到】
: You probably need to follow this to troubleshoot.
: http://support.microsoft.com/kb/280106
|
|
