I s there a good explanation in the web for beginners like me?
See the subject sp_addlinkedserver in the Books Online.
Jim
"Geri Reshef" <GeriR@.Dubek.co.il> wrote in message
news:OTGIc%238%23EHA.3336@.TK2MSFTNGP11.phx.gbl...
>I s there a good explanation in the web for beginners like me?
>
sql
Showing posts with label linked. Show all posts
Showing posts with label linked. Show all posts
Friday, March 23, 2012
HOW TO CONNECT SQL SERVER TO ORACLE 9I
How to connect linked sql for Oracle 9i?
Hi
Try
http://msdn.microsoft.com/library/de...oserlook .asp
http://msdn.microsoft.com/library/de...qd_12_07s5.asp
http://msdn.microsoft.com/library/de...r_ora cle.asp
You will need to install SQL*Net , the Oracle client tools should be on your
original oracle disks. Oracle also has their own OLEDB provider.
John
"Sergio Toro" <anonymous@.discussions.microsoft.com> wrote in message
news:1d6f701c453ec$d56108b0$a101280a@.phx.gbl...
> How to connect linked sql for Oracle 9i?
Hi
Try
http://msdn.microsoft.com/library/de...oserlook .asp
http://msdn.microsoft.com/library/de...qd_12_07s5.asp
http://msdn.microsoft.com/library/de...r_ora cle.asp
You will need to install SQL*Net , the Oracle client tools should be on your
original oracle disks. Oracle also has their own OLEDB provider.
John
"Sergio Toro" <anonymous@.discussions.microsoft.com> wrote in message
news:1d6f701c453ec$d56108b0$a101280a@.phx.gbl...
> How to connect linked sql for Oracle 9i?
HOW TO CONNECT SQL SERVER TO ORACLE 9I
How to connect linked sql for Oracle 9i?Hi
Try
acleusing_the_oracle_provider__a_closerl
ook.asp" target="_blank">http://msdn.microsoft.com/library/d...l
ook.asp
_07s5.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_07s5.asp
acleoverview_of_the_ole_db_provider_for_
oracle.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
oracle.asp
You will need to install SQL*Net , the Oracle client tools should be on your
original oracle disks. Oracle also has their own OLEDB provider.
John
"Sergio Toro" <anonymous@.discussions.microsoft.com> wrote in message
news:1d6f701c453ec$d56108b0$a101280a@.phx
.gbl...
> How to connect linked sql for Oracle 9i?
Try
acleusing_the_oracle_provider__a_closerl
ook.asp" target="_blank">http://msdn.microsoft.com/library/d...l
ook.asp
_07s5.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_07s5.asp
acleoverview_of_the_ole_db_provider_for_
oracle.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
oracle.asp
You will need to install SQL*Net , the Oracle client tools should be on your
original oracle disks. Oracle also has their own OLEDB provider.
John
"Sergio Toro" <anonymous@.discussions.microsoft.com> wrote in message
news:1d6f701c453ec$d56108b0$a101280a@.phx
.gbl...
> How to connect linked sql for Oracle 9i?
Wednesday, March 21, 2012
how to connect linked server to ibm db2
I'm trying to connect linked server to ibm db2 server
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
Zarko
See if the following articles help:
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/default...b;EN-US;218590
Configuring Microsoft ODBC Driver for DB2
http://support.microsoft.com/default...b;EN-US;216428
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1084958081.819215@.internet.fina.hr...
I'm trying to connect linked server to ibm db2 server
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
Zarko
|||Narayana Vyas Kondreddi wrote:
> See if the following articles help:
> INF: Configuring Data Sources for the Microsoft OLE DB Provider for
> DB2 http://support.microsoft.com/default...b;EN-US;218590
> Configuring Microsoft ODBC Driver for DB2
> http://support.microsoft.com/default...b;EN-US;216428
no help! :-((((((((((
anyone tried it?
--
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radim
|||You probably need an ODBC driver for DB2, which you will define as a
data source to access DB2. Try with StarSQL (www.starquest.com), fast
and easy to setup.
Bob
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message news:<1084965176.448813@.internet.fina.hr>...
> Narayana Vyas Kondreddi wrote:
>
> no help! :-((((((((((
> anyone tried it?
> --
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
Zarko
See if the following articles help:
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/default...b;EN-US;218590
Configuring Microsoft ODBC Driver for DB2
http://support.microsoft.com/default...b;EN-US;216428
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1084958081.819215@.internet.fina.hr...
I'm trying to connect linked server to ibm db2 server
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
Zarko
|||Narayana Vyas Kondreddi wrote:
> See if the following articles help:
> INF: Configuring Data Sources for the Microsoft OLE DB Provider for
> DB2 http://support.microsoft.com/default...b;EN-US;218590
> Configuring Microsoft ODBC Driver for DB2
> http://support.microsoft.com/default...b;EN-US;216428
no help! :-((((((((((
anyone tried it?
--
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radim
|||You probably need an ODBC driver for DB2, which you will define as a
data source to access DB2. Try with StarSQL (www.starquest.com), fast
and easy to setup.
Bob
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message news:<1084965176.448813@.internet.fina.hr>...
> Narayana Vyas Kondreddi wrote:
>
> no help! :-((((((((((
> anyone tried it?
> --
how to connect linked server to ibm db2
I'm trying to connect linked server to ibm db2 server
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
ZarkoSee if the following articles help:
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590
Configuring Microsoft ODBC Driver for DB2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1084958081.819215@.internet.fina.hr...
I'm trying to connect linked server to ibm db2 server
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
Zarko|||Narayana Vyas Kondreddi wrote:
> See if the following articles help:
> INF: Configuring Data Sources for the Microsoft OLE DB Provider for
> DB2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590
> Configuring Microsoft ODBC Driver for DB2
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428
no help! :-((((((((((
anyone tried it?
--
--
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radim|||You probably need an ODBC driver for DB2, which you will define as a
data source to access DB2. Try with StarSQL (www.starquest.com), fast
and easy to setup.
Bob
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message news:<1084965176.448813@.internet.fina.hr>...
> Narayana Vyas Kondreddi wrote:
> > See if the following articles help:
> >
> > INF: Configuring Data Sources for the Microsoft OLE DB Provider for
> > DB2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590
> >
> > Configuring Microsoft ODBC Driver for DB2
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428
>
> no help! :-((((((((((
> anyone tried it?
> --
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
ZarkoSee if the following articles help:
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590
Configuring Microsoft ODBC Driver for DB2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message
news:1084958081.819215@.internet.fina.hr...
I'm trying to connect linked server to ibm db2 server
I'm confused about parameters:
product name?
data source (probably is name of the server?)
provider string?
tia
Zarko|||Narayana Vyas Kondreddi wrote:
> See if the following articles help:
> INF: Configuring Data Sources for the Microsoft OLE DB Provider for
> DB2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590
> Configuring Microsoft ODBC Driver for DB2
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428
no help! :-((((((((((
anyone tried it?
--
--
svi komentari i razmisljanja su moja kao pojedinca i nikako se ne smiju
povezivati sa tvrtkom u kojoj radim|||You probably need an ODBC driver for DB2, which you will define as a
data source to access DB2. Try with StarSQL (www.starquest.com), fast
and easy to setup.
Bob
"Zarko Jovanovic" <RmEaMkOnViEoTHvIoSmind_less@.bigfoot.com> wrote in message news:<1084965176.448813@.internet.fina.hr>...
> Narayana Vyas Kondreddi wrote:
> > See if the following articles help:
> >
> > INF: Configuring Data Sources for the Microsoft OLE DB Provider for
> > DB2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;218590
> >
> > Configuring Microsoft ODBC Driver for DB2
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428
>
> no help! :-((((((((((
> anyone tried it?
> --
Monday, March 12, 2012
How to config a linked server from SQL to DB2
I have a DB2 database 7.2.
(
Server Host Name = SVR1,
Database name = PROD,
schema name = db2admin,
Port number = 50000)
How can I config a linked server to this DB2 database from
SQL. I check the doc find the sample like this:
EXEC sp_addlinkedserver
@.server='DB2',
@.srvproduct='Microsoft OLE DB Provider for DB2',
@.catalog='DB2',
@.provider='DB2OLEDB',
@.provstr='Initial Catalog=PUBS;Data
Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
Port=50000;Package Collection=admin;Default Schema=admin;'
I have a little bit confuse with the connect string
@.provstr, anybody can tell me how to mapping my DB2
information to this @.provstr?
I try this wouldn't work
@.provstr='Initial
Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
Address=SVR1;Network Port=50000;Package
Collection=db2admin;Default Schema=db2admin;'
I got error message: Error 7403: Could not locate registry
entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
[Non-interface error: Provider not registered]
Thanks,
HGDo u have DB2 client installed in your machine,
Thanks
Hari
MCDBA
"HG" <Hansen.gu@.aegoncanada.ca> wrote in message
news:008401c3ae0b$069335d0$a101280a@.phx.gbl...
> I have a DB2 database 7.2.
>
> Server Host Name = SVR1,
> Database name = PROD,
> schema name = db2admin,
> Port number = 50000)
> How can I config a linked server to this DB2 database from
> SQL. I check the doc find the sample like this:
> EXEC sp_addlinkedserver
> @.server='DB2',
> @.srvproduct='Microsoft OLE DB Provider for DB2',
> @.catalog='DB2',
> @.provider='DB2OLEDB',
> @.provstr='Initial Catalog=PUBS;Data
> Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
> Port=50000;Package Collection=admin;Default Schema=admin;'
>
> I have a little bit confuse with the connect string
> @.provstr, anybody can tell me how to mapping my DB2
> information to this @.provstr?
> I try this wouldn't work
> @.provstr='Initial
> Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
> Address=SVR1;Network Port=50000;Package
> Collection=db2admin;Default Schema=db2admin;'
> I got error message: Error 7403: Could not locate registry
> entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
> [Non-interface error: Provider not registered]
> Thanks,
> HG|||Yes, I do have DB2 client installed locally.
>--Original Message--
>Do u have DB2 client installed in your machine,
>Thanks
>Hari
>MCDBA
>"HG" <Hansen.gu@.aegoncanada.ca> wrote in message
>news:008401c3ae0b$069335d0$a101280a@.phx.gbl...
>> I have a DB2 database 7.2.
>> Server Host Name = SVR1,
>> Database name = PROD,
>> schema name = db2admin,
>> Port number = 50000)
>> How can I config a linked server to this DB2 database
from
>> SQL. I check the doc find the sample like this:
>> EXEC sp_addlinkedserver
>> @.server='DB2',
>> @.srvproduct='Microsoft OLE DB Provider for DB2',
>> @.catalog='DB2',
>> @.provider='DB2OLEDB',
>> @.provstr='Initial Catalog=PUBS;Data
>> Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
>> Port=50000;Package Collection=admin;Default
Schema=admin;'
>>
>> I have a little bit confuse with the connect string
>> @.provstr, anybody can tell me how to mapping my DB2
>> information to this @.provstr?
>> I try this wouldn't work
>> @.provstr='Initial
>> Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
>> Address=SVR1;Network Port=50000;Package
>> Collection=db2admin;Default Schema=db2admin;'
>> I got error message: Error 7403: Could not locate
registry
>> entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
>> [Non-interface error: Provider not registered]
>> Thanks,
>> HG
>
>.
>
(
Server Host Name = SVR1,
Database name = PROD,
schema name = db2admin,
Port number = 50000)
How can I config a linked server to this DB2 database from
SQL. I check the doc find the sample like this:
EXEC sp_addlinkedserver
@.server='DB2',
@.srvproduct='Microsoft OLE DB Provider for DB2',
@.catalog='DB2',
@.provider='DB2OLEDB',
@.provstr='Initial Catalog=PUBS;Data
Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
Port=50000;Package Collection=admin;Default Schema=admin;'
I have a little bit confuse with the connect string
@.provstr, anybody can tell me how to mapping my DB2
information to this @.provstr?
I try this wouldn't work
@.provstr='Initial
Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
Address=SVR1;Network Port=50000;Package
Collection=db2admin;Default Schema=db2admin;'
I got error message: Error 7403: Could not locate registry
entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
[Non-interface error: Provider not registered]
Thanks,
HGDo u have DB2 client installed in your machine,
Thanks
Hari
MCDBA
"HG" <Hansen.gu@.aegoncanada.ca> wrote in message
news:008401c3ae0b$069335d0$a101280a@.phx.gbl...
> I have a DB2 database 7.2.
>
> Server Host Name = SVR1,
> Database name = PROD,
> schema name = db2admin,
> Port number = 50000)
> How can I config a linked server to this DB2 database from
> SQL. I check the doc find the sample like this:
> EXEC sp_addlinkedserver
> @.server='DB2',
> @.srvproduct='Microsoft OLE DB Provider for DB2',
> @.catalog='DB2',
> @.provider='DB2OLEDB',
> @.provstr='Initial Catalog=PUBS;Data
> Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
> Port=50000;Package Collection=admin;Default Schema=admin;'
>
> I have a little bit confuse with the connect string
> @.provstr, anybody can tell me how to mapping my DB2
> information to this @.provstr?
> I try this wouldn't work
> @.provstr='Initial
> Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
> Address=SVR1;Network Port=50000;Package
> Collection=db2admin;Default Schema=db2admin;'
> I got error message: Error 7403: Could not locate registry
> entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
> [Non-interface error: Provider not registered]
> Thanks,
> HG|||Yes, I do have DB2 client installed locally.
>--Original Message--
>Do u have DB2 client installed in your machine,
>Thanks
>Hari
>MCDBA
>"HG" <Hansen.gu@.aegoncanada.ca> wrote in message
>news:008401c3ae0b$069335d0$a101280a@.phx.gbl...
>> I have a DB2 database 7.2.
>> Server Host Name = SVR1,
>> Database name = PROD,
>> schema name = db2admin,
>> Port number = 50000)
>> How can I config a linked server to this DB2 database
from
>> SQL. I check the doc find the sample like this:
>> EXEC sp_addlinkedserver
>> @.server='DB2',
>> @.srvproduct='Microsoft OLE DB Provider for DB2',
>> @.catalog='DB2',
>> @.provider='DB2OLEDB',
>> @.provstr='Initial Catalog=PUBS;Data
>> Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
>> Port=50000;Package Collection=admin;Default
Schema=admin;'
>>
>> I have a little bit confuse with the connect string
>> @.provstr, anybody can tell me how to mapping my DB2
>> information to this @.provstr?
>> I try this wouldn't work
>> @.provstr='Initial
>> Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
>> Address=SVR1;Network Port=50000;Package
>> Collection=db2admin;Default Schema=db2admin;'
>> I got error message: Error 7403: Could not locate
registry
>> entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
>> [Non-interface error: Provider not registered]
>> Thanks,
>> HG
>
>.
>
Subscribe to:
Posts (Atom)