I have followed the examples from MS. to create the link between my MSSQL200
5
and Oracle 10g
I have all of the Oracle client installed on the server.
I have a net service defined.
Here is what I ran to create link:
EXEC sp_addlinkedserver 'OraLinkServer2', 'Oracle', 'MSDAORA', 'HPRD89'
EXEC sp_addlinkedsrvlogin 'OraLinkServer2', 'False' ,Null, 'spwr07', 'spwr07
'
Here is the query:
select count(*) from OraLinkServer2..sysadm.SUN_PUBT
Here is the error:
OLE DB provider "MSDAORA" for linked server "OraLinkServer2" returned
message "ORA-12154: TNS:could not resolve the connect identifier specified
".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDAORA" for
linked server "OraLinkServer2".
What am I doing wrong all the oracle tools connect just fine. I need SQL2005
to connect?
Thanks
GregHob,
I've had the same problem. I used the openquery syntax to work around
the problem. This also has the advantage of pushing the work to the
Oracle Server.
So.. try:
select * from
openquery(OraLinkServer2,
' select count(*) from SUN_PUBT
'
)
No -- you don't need the formating and returns -- I just use them to
make it easy for me to read the Oracle Commands separate from the
MS-SQL commands.
If you find a better solution, please post it.
You also might want to read:
http://www.sqlservercentral.com/col...br />
art3.asp
It has the best set of instructions for getting the Instant Client to
work.
Good luck,
Peter Ryan
Hob_Naggers wrote:
> I have followed the examples from MS. to create the link between my MSSQL2
005
> and Oracle 10g
> I have all of the Oracle client installed on the server.
> I have a net service defined.
> Here is what I ran to create link:
> EXEC sp_addlinkedserver 'OraLinkServer2', 'Oracle', 'MSDAORA', 'HPRD8
9'
> EXEC sp_addlinkedsrvlogin 'OraLinkServer2', 'False' ,Null, 'spwr07', 'spwr
07'
>
> Here is the query:
> select count(*) from OraLinkServer2..sysadm.SUN_PUBT
> Here is the error:
> OLE DB provider "MSDAORA" for linked server "OraLinkServer2" returned
> message "ORA-12154: TNS:could not resolve the connect identifier specified
> ".
> Msg 7303, Level 16, State 1, Line 1
> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
> linked server "OraLinkServer2".
> What am I doing wrong all the oracle tools connect just fine. I need SQL20
05
> to connect?
> Thanks
> Greg|||Hob,
I've had the same problem. I used the openquery syntax to work around
the problem. This also has the advantage of pushing the work to the
Oracle Server.
So.. try:
select * from
openquery(OraLinkServer2,
' select count(*) from SUN_PUBT
'
)
No -- you don't need the formating and returns -- I just use them to
make it easy for me to read the Oracle Commands separate from the
MS-SQL commands.
If you find a better solution, please post it.
You also might want to read:
http://www.sqlservercentral.com/col...br />
art3.asp
It has the best set of instructions for getting the Instant Client to
work.
Good luck,
Peter Ryan
Hob_Naggers wrote:
> I have followed the examples from MS. to create the link between my MSSQL2
005
> and Oracle 10g
> I have all of the Oracle client installed on the server.
> I have a net service defined.
> Here is what I ran to create link:
> EXEC sp_addlinkedserver 'OraLinkServer2', 'Oracle', 'MSDAORA', 'HPRD8
9'
> EXEC sp_addlinkedsrvlogin 'OraLinkServer2', 'False' ,Null, 'spwr07', 'spwr
07'
>
> Here is the query:
> select count(*) from OraLinkServer2..sysadm.SUN_PUBT
> Here is the error:
> OLE DB provider "MSDAORA" for linked server "OraLinkServer2" returned
> message "ORA-12154: TNS:could not resolve the connect identifier specified
> ".
> Msg 7303, Level 16, State 1, Line 1
> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
> linked server "OraLinkServer2".
> What am I doing wrong all the oracle tools connect just fine. I need SQL20
05
> to connect?
> Thanks
> Greg|||Hi Peter,
Thanks for the response, but I finally found the problem yesterday. The real
problem was not with SQL server, but rather it was a problem with the Oracle
config.
Though i had the TNSNames.ora file configured correctly the SQLNET.ora file
was where the problem lay. It was configured for ezconnect instead of
tnsnames. After this was ironed out the linking of the oracle db into sql wa
s
easy. One weird not though I found after getting the config right. When
querying the linked db. It is case sensitive with regards to column and tabl
e
names, even though on the Oracle side it is not case sensitive. I'm guessing
it has something to do with the translation being provided by the providers.
Thanks
Greg
"pryan64" wrote:
> Hob,
> I've had the same problem. I used the openquery syntax to work around
> the problem. This also has the advantage of pushing the work to the
> Oracle Server.
> So.. try:
> select * from
> openquery(OraLinkServer2,
> ' select count(*) from SUN_PUBT
> '
> )
> No -- you don't need the formating and returns -- I just use them to
> make it easy for me to read the Oracle Commands separate from the
> MS-SQL commands.
> If you find a better solution, please post it.
> You also might want to read:
> http://www.sqlservercentral.com/col... />
ypart3.asp
> It has the best set of instructions for getting the Instant Client to
> work.
> Good luck,
> Peter Ryan
> Hob_Naggers wrote:
>|||Hi Peter,
Thanks for the response, but I finally found the problem yesterday. The real
problem was not with SQL server, but rather it was a problem with the Oracle
config.
Though i had the TNSNames.ora file configured correctly the SQLNET.ora file
was where the problem lay. It was configured for ezconnect instead of
tnsnames. After this was ironed out the linking of the oracle db into sql wa
s
easy. One weird not though I found after getting the config right. When
querying the linked db. It is case sensitive with regards to column and tabl
e
names, even though on the Oracle side it is not case sensitive. I'm guessing
it has something to do with the translation being provided by the providers.
Thanks
Greg
"pryan64" wrote:
> Hob,
> I've had the same problem. I used the openquery syntax to work around
> the problem. This also has the advantage of pushing the work to the
> Oracle Server.
> So.. try:
> select * from
> openquery(OraLinkServer2,
> ' select count(*) from SUN_PUBT
> '
> )
> No -- you don't need the formating and returns -- I just use them to
> make it easy for me to read the Oracle Commands separate from the
> MS-SQL commands.
> If you find a better solution, please post it.
> You also might want to read:
> http://www.sqlservercentral.com/col... />
ypart3.asp
> It has the best set of instructions for getting the Instant Client to
> work.
> Good luck,
> Peter Ryan
> Hob_Naggers wrote:
>
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Monday, March 26, 2012
Monday, March 19, 2012
Linked Server Fails after MDAC 2.8 upgrade
We installed the MDAC 2.8 upgrade and our existing
Microsoft OLE DB Provider for Oracle stopped working.
Other providers were fine, i.e. SQL Server (linking to
another mssql server).
Has anyone had this issue? Or does anyone have any
ideas as to what changed in 2.8 that would affect this
linked server?
Thanks in advance,
MarkI think that may be something related with distributed transactions.
I have some applications that stopped to work when I upgrade to MDAC 2.8.
Trying to solve this I discover that just returning the sql server odbc
driver files to version 2.7 the applications could work correctly... anyway
I think that is a bug in MDAC 2.8
Agrinei
"Mark D" <anonymous@.discussions.microsoft.com> wrote in message
news:816301c4076c$80de9630$a601280a@.phx.gbl...
> We installed the MDAC 2.8 upgrade and our existing
> Microsoft OLE DB Provider for Oracle stopped working.
> Other providers were fine, i.e. SQL Server (linking to
> another mssql server).
> Has anyone had this issue? Or does anyone have any
> ideas as to what changed in 2.8 that would affect this
> linked server?
> Thanks in advance,
> Mark
Microsoft OLE DB Provider for Oracle stopped working.
Other providers were fine, i.e. SQL Server (linking to
another mssql server).
Has anyone had this issue? Or does anyone have any
ideas as to what changed in 2.8 that would affect this
linked server?
Thanks in advance,
MarkI think that may be something related with distributed transactions.
I have some applications that stopped to work when I upgrade to MDAC 2.8.
Trying to solve this I discover that just returning the sql server odbc
driver files to version 2.7 the applications could work correctly... anyway
I think that is a bug in MDAC 2.8
Agrinei
"Mark D" <anonymous@.discussions.microsoft.com> wrote in message
news:816301c4076c$80de9630$a601280a@.phx.gbl...
> We installed the MDAC 2.8 upgrade and our existing
> Microsoft OLE DB Provider for Oracle stopped working.
> Other providers were fine, i.e. SQL Server (linking to
> another mssql server).
> Has anyone had this issue? Or does anyone have any
> ideas as to what changed in 2.8 that would affect this
> linked server?
> Thanks in advance,
> Mark
Linked server error in SSMS
Hi all
I have installed Sql Server 2005 + Sp2 developer edition. Once trying to add
a linked server in SSMS Server Objects => Linked Servers => New Linked
Server I'm getting the error immediately saying " Cannot show requested
dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
under Linked servers is also empty. However I could add a linked server
successfully using t-sql sp_addlinkedserver. I got the feeling that some
files are corrupt on my PC, but I don't know which. I tried to uninstall and
put the server back again and it did not help either. I installed Sql Server
from the same disk onto the other machine and it works fine. Has anybody got
an idea how to resolve my problem?
Many thanks
DariusDarius
Hmm, I tried succefully create a linked server throu SSMS to SQL Server
2000. Pehaps something got corrupted during the installation of SSMS...
"Darius" <nospam@.mail.com> wrote in message
news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hi all
> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
> add a linked server in SSMS Server Objects => Linked Servers => New Linked
> Server I'm getting the error immediately saying " Cannot show requested
> dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
> under Linked servers is also empty. However I could add a linked server
> successfully using t-sql sp_addlinkedserver. I got the feeling that some
> files are corrupt on my PC, but I don't know which. I tried to uninstall
> and put the server back again and it did not help either. I installed Sql
> Server from the same disk onto the other machine and it works fine. Has
> anybody got an idea how to resolve my problem?
> Many thanks
> Darius
>
>|||Hi Uri
I believe something is corrupted on my PC (drivers, etc.), I successfully
can create linked server on the other machines. The error appears straight
after I click on "New Linked Server", it does not even show any dialog box..
I reinstalled the Sql Server from the scratch but there were no difference.
Just don't know where to start looking at...
Darius
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
> Darius
> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
> 2000. Pehaps something got corrupted during the installation of SSMS...
>
> "Darius" <nospam@.mail.com> wrote in message
> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
>> add a linked server in SSMS Server Objects => Linked Servers => New
>> Linked Server I'm getting the error immediately saying " Cannot show
>> requested dialog. Cannot find table 0. (System.Data)". Additionally
>> Providers tree under Linked servers is also empty. However I could add a
>> linked server successfully using t-sql sp_addlinkedserver. I got the
>> feeling that some files are corrupt on my PC, but I don't know which. I
>> tried to uninstall and put the server back again and it did not help
>> either. I installed Sql Server from the same disk onto the other machine
>> and it works fine. Has anybody got an idea how to resolve my problem?
>> Many thanks
>> Darius
>>
>>
>|||Hi
Have you tried to search on "Google" for this error message?
"Darius" <nospam@.mail.com> wrote in message
news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
> Hi Uri
> I believe something is corrupted on my PC (drivers, etc.), I successfully
> can create linked server on the other machines. The error appears straight
> after I click on "New Linked Server", it does not even show any dialog
> box.. I reinstalled the Sql Server from the scratch but there were no
> difference. Just don't know where to start looking at...
> Darius
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>> Darius
>> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
>> 2000. Pehaps something got corrupted during the installation of
>> SSMS...
>>
>> "Darius" <nospam@.mail.com> wrote in message
>> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
>> add a linked server in SSMS Server Objects => Linked Servers => New
>> Linked Server I'm getting the error immediately saying " Cannot show
>> requested dialog. Cannot find table 0. (System.Data)". Additionally
>> Providers tree under Linked servers is also empty. However I could add a
>> linked server successfully using t-sql sp_addlinkedserver. I got the
>> feeling that some files are corrupt on my PC, but I don't know which. I
>> tried to uninstall and put the server back again and it did not help
>> either. I installed Sql Server from the same disk onto the other machine
>> and it works fine. Has anybody got an idea how to resolve my problem?
>> Many thanks
>> Darius
>>
>>
>>
>|||yep, this is the first thing I do before posting to newsgroups. Anyway, will
post the solution when/if I manage to solve that problem.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxr7xplgHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hi
> Have you tried to search on "Google" for this error message?
>
> "Darius" <nospam@.mail.com> wrote in message
> news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> Hi Uri
>> I believe something is corrupted on my PC (drivers, etc.), I successfully
>> can create linked server on the other machines. The error appears
>> straight after I click on "New Linked Server", it does not even show any
>> dialog box.. I reinstalled the Sql Server from the scratch but there were
>> no difference. Just don't know where to start looking at...
>> Darius
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>> Darius
>> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
>> 2000. Pehaps something got corrupted during the installation of
>> SSMS...
>>
>> "Darius" <nospam@.mail.com> wrote in message
>> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have installed Sql Server 2005 + Sp2 developer edition. Once trying
>> to add a linked server in SSMS Server Objects => Linked Servers => New
>> Linked Server I'm getting the error immediately saying " Cannot show
>> requested dialog. Cannot find table 0. (System.Data)". Additionally
>> Providers tree under Linked servers is also empty. However I could add
>> a linked server successfully using t-sql sp_addlinkedserver. I got the
>> feeling that some files are corrupt on my PC, but I don't know which. I
>> tried to uninstall and put the server back again and it did not help
>> either. I installed Sql Server from the same disk onto the other
>> machine and it works fine. Has anybody got an idea how to resolve my
>> problem?
>> Many thanks
>> Darius
>>
>>
>>
>>
>
I have installed Sql Server 2005 + Sp2 developer edition. Once trying to add
a linked server in SSMS Server Objects => Linked Servers => New Linked
Server I'm getting the error immediately saying " Cannot show requested
dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
under Linked servers is also empty. However I could add a linked server
successfully using t-sql sp_addlinkedserver. I got the feeling that some
files are corrupt on my PC, but I don't know which. I tried to uninstall and
put the server back again and it did not help either. I installed Sql Server
from the same disk onto the other machine and it works fine. Has anybody got
an idea how to resolve my problem?
Many thanks
DariusDarius
Hmm, I tried succefully create a linked server throu SSMS to SQL Server
2000. Pehaps something got corrupted during the installation of SSMS...
"Darius" <nospam@.mail.com> wrote in message
news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hi all
> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
> add a linked server in SSMS Server Objects => Linked Servers => New Linked
> Server I'm getting the error immediately saying " Cannot show requested
> dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
> under Linked servers is also empty. However I could add a linked server
> successfully using t-sql sp_addlinkedserver. I got the feeling that some
> files are corrupt on my PC, but I don't know which. I tried to uninstall
> and put the server back again and it did not help either. I installed Sql
> Server from the same disk onto the other machine and it works fine. Has
> anybody got an idea how to resolve my problem?
> Many thanks
> Darius
>
>|||Hi Uri
I believe something is corrupted on my PC (drivers, etc.), I successfully
can create linked server on the other machines. The error appears straight
after I click on "New Linked Server", it does not even show any dialog box..
I reinstalled the Sql Server from the scratch but there were no difference.
Just don't know where to start looking at...
Darius
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
> Darius
> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
> 2000. Pehaps something got corrupted during the installation of SSMS...
>
> "Darius" <nospam@.mail.com> wrote in message
> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
>> add a linked server in SSMS Server Objects => Linked Servers => New
>> Linked Server I'm getting the error immediately saying " Cannot show
>> requested dialog. Cannot find table 0. (System.Data)". Additionally
>> Providers tree under Linked servers is also empty. However I could add a
>> linked server successfully using t-sql sp_addlinkedserver. I got the
>> feeling that some files are corrupt on my PC, but I don't know which. I
>> tried to uninstall and put the server back again and it did not help
>> either. I installed Sql Server from the same disk onto the other machine
>> and it works fine. Has anybody got an idea how to resolve my problem?
>> Many thanks
>> Darius
>>
>>
>|||Hi
Have you tried to search on "Google" for this error message?
"Darius" <nospam@.mail.com> wrote in message
news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
> Hi Uri
> I believe something is corrupted on my PC (drivers, etc.), I successfully
> can create linked server on the other machines. The error appears straight
> after I click on "New Linked Server", it does not even show any dialog
> box.. I reinstalled the Sql Server from the scratch but there were no
> difference. Just don't know where to start looking at...
> Darius
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>> Darius
>> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
>> 2000. Pehaps something got corrupted during the installation of
>> SSMS...
>>
>> "Darius" <nospam@.mail.com> wrote in message
>> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
>> add a linked server in SSMS Server Objects => Linked Servers => New
>> Linked Server I'm getting the error immediately saying " Cannot show
>> requested dialog. Cannot find table 0. (System.Data)". Additionally
>> Providers tree under Linked servers is also empty. However I could add a
>> linked server successfully using t-sql sp_addlinkedserver. I got the
>> feeling that some files are corrupt on my PC, but I don't know which. I
>> tried to uninstall and put the server back again and it did not help
>> either. I installed Sql Server from the same disk onto the other machine
>> and it works fine. Has anybody got an idea how to resolve my problem?
>> Many thanks
>> Darius
>>
>>
>>
>|||yep, this is the first thing I do before posting to newsgroups. Anyway, will
post the solution when/if I manage to solve that problem.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxr7xplgHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hi
> Have you tried to search on "Google" for this error message?
>
> "Darius" <nospam@.mail.com> wrote in message
> news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> Hi Uri
>> I believe something is corrupted on my PC (drivers, etc.), I successfully
>> can create linked server on the other machines. The error appears
>> straight after I click on "New Linked Server", it does not even show any
>> dialog box.. I reinstalled the Sql Server from the scratch but there were
>> no difference. Just don't know where to start looking at...
>> Darius
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>> Darius
>> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
>> 2000. Pehaps something got corrupted during the installation of
>> SSMS...
>>
>> "Darius" <nospam@.mail.com> wrote in message
>> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have installed Sql Server 2005 + Sp2 developer edition. Once trying
>> to add a linked server in SSMS Server Objects => Linked Servers => New
>> Linked Server I'm getting the error immediately saying " Cannot show
>> requested dialog. Cannot find table 0. (System.Data)". Additionally
>> Providers tree under Linked servers is also empty. However I could add
>> a linked server successfully using t-sql sp_addlinkedserver. I got the
>> feeling that some files are corrupt on my PC, but I don't know which. I
>> tried to uninstall and put the server back again and it did not help
>> either. I installed Sql Server from the same disk onto the other
>> machine and it works fine. Has anybody got an idea how to resolve my
>> problem?
>> Many thanks
>> Darius
>>
>>
>>
>>
>
Linked server error in SSMS
Hi all
I have installed Sql Server 2005 + Sp2 developer edition. Once trying to add
a linked server in SSMS Server Objects => Linked Servers => New Linked
Server I'm getting the error immediately saying " Cannot show requested
dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
under Linked servers is also empty. However I could add a linked server
successfully using t-sql sp_addlinkedserver. I got the feeling that some
files are corrupt on my PC, but I don't know which. I tried to uninstall and
put the server back again and it did not help either. I installed Sql Server
from the same disk onto the other machine and it works fine. Has anybody got
an idea how to resolve my problem?
Many thanks
DariusDarius
Hmm, I tried succefully create a linked server throu SSMS to SQL Server
2000. Pehaps something got corrupted during the installation of SSMS...
"Darius" <nospam@.mail.com> wrote in message
news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hi all
> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
> add a linked server in SSMS Server Objects => Linked Servers => New Linked
> Server I'm getting the error immediately saying " Cannot show requested
> dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
> under Linked servers is also empty. However I could add a linked server
> successfully using t-sql sp_addlinkedserver. I got the feeling that some
> files are corrupt on my PC, but I don't know which. I tried to uninstall
> and put the server back again and it did not help either. I installed Sql
> Server from the same disk onto the other machine and it works fine. Has
> anybody got an idea how to resolve my problem?
> Many thanks
> Darius
>
>|||Hi Uri
I believe something is corrupted on my PC (drivers, etc.), I successfully
can create linked server on the other machines. The error appears straight
after I click on "New Linked Server", it does not even show any dialog box..
I reinstalled the Sql Server from the scratch but there were no difference.
Just don't know where to start looking at...
Darius
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
> Darius
> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
> 2000. Pehaps something got corrupted during the installation of SSMS...
>
> "Darius" <nospam@.mail.com> wrote in message
> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>|||Hi
Have you tried to search on "Google" for this error message?
"Darius" <nospam@.mail.com> wrote in message
news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
> Hi Uri
> I believe something is corrupted on my PC (drivers, etc.), I successfully
> can create linked server on the other machines. The error appears straight
> after I click on "New Linked Server", it does not even show any dialog
> box.. I reinstalled the Sql Server from the scratch but there were no
> difference. Just don't know where to start looking at...
> Darius
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>|||yep, this is the first thing I do before posting to newsgroups. Anyway, will
post the solution when/if I manage to solve that problem.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxr7xplgHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hi
> Have you tried to search on "Google" for this error message?
>
> "Darius" <nospam@.mail.com> wrote in message
> news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
>
I have installed Sql Server 2005 + Sp2 developer edition. Once trying to add
a linked server in SSMS Server Objects => Linked Servers => New Linked
Server I'm getting the error immediately saying " Cannot show requested
dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
under Linked servers is also empty. However I could add a linked server
successfully using t-sql sp_addlinkedserver. I got the feeling that some
files are corrupt on my PC, but I don't know which. I tried to uninstall and
put the server back again and it did not help either. I installed Sql Server
from the same disk onto the other machine and it works fine. Has anybody got
an idea how to resolve my problem?
Many thanks
DariusDarius
Hmm, I tried succefully create a linked server throu SSMS to SQL Server
2000. Pehaps something got corrupted during the installation of SSMS...
"Darius" <nospam@.mail.com> wrote in message
news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hi all
> I have installed Sql Server 2005 + Sp2 developer edition. Once trying to
> add a linked server in SSMS Server Objects => Linked Servers => New Linked
> Server I'm getting the error immediately saying " Cannot show requested
> dialog. Cannot find table 0. (System.Data)". Additionally Providers tree
> under Linked servers is also empty. However I could add a linked server
> successfully using t-sql sp_addlinkedserver. I got the feeling that some
> files are corrupt on my PC, but I don't know which. I tried to uninstall
> and put the server back again and it did not help either. I installed Sql
> Server from the same disk onto the other machine and it works fine. Has
> anybody got an idea how to resolve my problem?
> Many thanks
> Darius
>
>|||Hi Uri
I believe something is corrupted on my PC (drivers, etc.), I successfully
can create linked server on the other machines. The error appears straight
after I click on "New Linked Server", it does not even show any dialog box..
I reinstalled the Sql Server from the scratch but there were no difference.
Just don't know where to start looking at...
Darius
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
> Darius
> Hmm, I tried succefully create a linked server throu SSMS to SQL Server
> 2000. Pehaps something got corrupted during the installation of SSMS...
>
> "Darius" <nospam@.mail.com> wrote in message
> news:uU8j%23TlgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>|||Hi
Have you tried to search on "Google" for this error message?
"Darius" <nospam@.mail.com> wrote in message
news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
> Hi Uri
> I believe something is corrupted on my PC (drivers, etc.), I successfully
> can create linked server on the other machines. The error appears straight
> after I click on "New Linked Server", it does not even show any dialog
> box.. I reinstalled the Sql Server from the scratch but there were no
> difference. Just don't know where to start looking at...
> Darius
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHjRvelgHHA.4260@.TK2MSFTNGP03.phx.gbl...
>|||yep, this is the first thing I do before posting to newsgroups. Anyway, will
post the solution when/if I manage to solve that problem.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uxr7xplgHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hi
> Have you tried to search on "Google" for this error message?
>
> "Darius" <nospam@.mail.com> wrote in message
> news:eK2yKolgHHA.3852@.TK2MSFTNGP04.phx.gbl...
>
Linked Server Error
Hello,
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following erro
r:
****************************************
***+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
****************************************
**
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.Gabriel --
See if this thread helps at all:
http://www.mcse.ms/message979460.html
same thread, different format:
http://www.newsarch.com/archive/new...
54.html
Gabriel Giraldo wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a n
ew
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following er
ror:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returne
d
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>|||It has been awhile since I worked with the AS/400. Based on the error
message, I would look at the client software installed on the SQL end. The
second thing to look at is the syntax used to attempt to get data. As long a
s
the SQL is fully ANSI standard, you should be fine on both ends; if not, the
likelihood of error increases.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a n
ew
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following er
ror:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returne
d
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following erro
r:
****************************************
***+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
****************************************
**
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.Gabriel --
See if this thread helps at all:
http://www.mcse.ms/message979460.html
same thread, different format:
http://www.newsarch.com/archive/new...
54.html
Gabriel Giraldo wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a n
ew
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following er
ror:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returne
d
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>|||It has been awhile since I worked with the AS/400. Based on the error
message, I would look at the client software installed on the SQL end. The
second thing to look at is the syntax used to attempt to get data. As long a
s
the SQL is fully ANSI standard, you should be fine on both ends; if not, the
likelihood of error increases.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a n
ew
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following er
ror:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returne
d
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
Friday, March 9, 2012
Linked server AS400/DB2 trouble again
Hi !
I'm trying to create Linked Server to AS400 DB2 on SQL Server 2000.
Using IBMDA400 (IBM AS400 OLEDB Provider installed from Client Access).
Got an error 7399: OLEDB Provider returned UNKNOWN error.
exec SP_AddLinkedServer
@.Server=AS_SERVER,
@.SrvProduct='IBM AS400 OLEDB Provider',
@.Catalog='QGPL',
@.Location='AS_SERVER',
@.Provider=IBMDA400,
@.Datasrc=AS_SERVER,
@.Provstr='Provider=IBMDA400.1;Password="";User ID=AS_USER;Data Source=AS_SERVER;Transport Product=Client Access;SSL=DEFAULT;Libraries=QGPL;Connect Timeout=90;Host Code Page=037'
Attempted different combinations of theese params...
After that created remote login on AS400.
Please help or correct my LinkedServerProperties...
Regards,
PVHave you looked at this old posting:
dbForums - BD2OLEDB (http://dbforums.com/t477702.html)
I'm trying to create Linked Server to AS400 DB2 on SQL Server 2000.
Using IBMDA400 (IBM AS400 OLEDB Provider installed from Client Access).
Got an error 7399: OLEDB Provider returned UNKNOWN error.
exec SP_AddLinkedServer
@.Server=AS_SERVER,
@.SrvProduct='IBM AS400 OLEDB Provider',
@.Catalog='QGPL',
@.Location='AS_SERVER',
@.Provider=IBMDA400,
@.Datasrc=AS_SERVER,
@.Provstr='Provider=IBMDA400.1;Password="";User ID=AS_USER;Data Source=AS_SERVER;Transport Product=Client Access;SSL=DEFAULT;Libraries=QGPL;Connect Timeout=90;Host Code Page=037'
Attempted different combinations of theese params...
After that created remote login on AS400.
Please help or correct my LinkedServerProperties...
Regards,
PVHave you looked at this old posting:
dbForums - BD2OLEDB (http://dbforums.com/t477702.html)
Monday, February 20, 2012
Linked server - Access Denied
I have a problem that I am having a heck of a time figuring out.
I have a new install of SQL Server 2005 on a new install of Windows 2003.
I installed the Informix CSDK 2.90.xxx and set up connections to our test
informix database
I created a linked server to an Informix database using OLEDB and it works
if the service account is the Local System account or a domain admin.
If I change the account to a domain user, I get an access denied error when
running a query against the linked server. I added the domain user account
to the local administrator group and still get access denied.
Everything else that I tried seems to work, just a problem with the linked
server. I have made sure that the service account user has read & execute
at a minimum on the Informix OleDB dll. Even went so far as temporarily
giving everyone full control on the Informix client directory, to make sure
is was not a file permission problem.
any HELPwould be greatly appreciated!
The actual message I receive is:
Where ifxoledbc is the informix OleDB driver, and coristest is the link
server name
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Ifxoledbc" for linked server "coristest" reported an
error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Ifxoledbc" for
linked server "coristest".Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
I have a new install of SQL Server 2005 on a new install of Windows 2003.
I installed the Informix CSDK 2.90.xxx and set up connections to our test
informix database
I created a linked server to an Informix database using OLEDB and it works
if the service account is the Local System account or a domain admin.
If I change the account to a domain user, I get an access denied error when
running a query against the linked server. I added the domain user account
to the local administrator group and still get access denied.
Everything else that I tried seems to work, just a problem with the linked
server. I have made sure that the service account user has read & execute
at a minimum on the Informix OleDB dll. Even went so far as temporarily
giving everyone full control on the Informix client directory, to make sure
is was not a file permission problem.
any HELPwould be greatly appreciated!
The actual message I receive is:
Where ifxoledbc is the informix OleDB driver, and coristest is the link
server name
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Ifxoledbc" for linked server "coristest" reported an
error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Ifxoledbc" for
linked server "coristest".Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)