Hi All,
I am close before throwing the machine out of the window.
I tried to establish a linked server on our SQL2000 server pointing to a DB.
EXEC sp_addlinkedser ver
@server = 'DB2',
@srvproduct = 'IBM OLE DB Provider for DB2 Servers',
@provider = 'IBMDADB2',
@provstr='DSN=J DE_PROD;UID=XXX X;PWD=XXX;DATAB ASE=JDE_PROD;'
EXEC sp_addlinkedsrv login 'DB2', false, NULL, 'XXX', 'XXXX'
If I query the LS using query analyzer or the Enterprise Manager both start
to hang, never responding again.
To be honest I am quite new to this topic but I read a lot and also tried a
lot ;)
Some articles talk about SNA Servers to be installed first, others about
some client tools.
I am confused by now...
Could anybody please be so kind and tell me how to connect the DB2 as a
linked server?
Is my statement wrong, and if so how should it look like? Why does the
application start to hang? Do I really need to install additional software
to do so?
Our DB2 expert also taked about software necessary to access the DB2
mainframe. Any ideas?
Thanks a lot in advance and belive me, any hints are highly appreciated ;)
Seize the Day
Andy
Andreas Bretl an***********@b rainlab.com 4 4674
"Bretl Andy" <an***********@ brainlab.com> wrote in message
news:2r******** *****@uni-berlin.de... Hi All, I am close before throwing the machine out of the window. I tried to establish a linked server on our SQL2000 server pointing to a DB.
EXEC sp_addlinkedser ver @server = 'DB2', @srvproduct = 'IBM OLE DB Provider for DB2 Servers', @provider = 'IBMDADB2', @provstr='DSN=J DE_PROD;UID=XXX X;PWD=XXX;DATAB ASE=JDE_PROD;'
EXEC sp_addlinkedsrv login 'DB2', false, NULL, 'XXX', 'XXXX'
If I query the LS using query analyzer or the Enterprise Manager both start to hang, never responding again. To be honest I am quite new to this topic but I read a lot and also tried a lot ;)
Some articles talk about SNA Servers to be installed first, others about some client tools. I am confused by now...
Could anybody please be so kind and tell me how to connect the DB2 as a linked server? Is my statement wrong, and if so how should it look like? Why does the application start to hang? Do I really need to install additional software to do so?
Our DB2 expert also taked about software necessary to access the DB2 mainframe. Any ideas?
Thanks a lot in advance and belive me, any hints are highly appreciated ;)
Seize the Day
Andy
Andreas Bretl an***********@b rainlab.com
This explanation might clarify the question of installing SNA/HIS client
components vs the IBM client drivers: http://groups.google.com/groups?hl=e...40cpmsftngxa07
Have you checked that you can successfully connect from the SQL Server
server to DB2 using some kind of DB2 client tool, or even just a script? If
that's OK, then at least you know the provider is installed and working, so
the issue is likely to be the linked server definition.
You might want to check the @provstr parameter - the syntax is specific for
each OLE DB provider, so you should make sure that it's really a valid
string for the IBM provider. There's a sample here: http://www.connectionstrings.com
Simon
First of all, Thanks a lot Simon for the hint,
unfortunately I still can not connect to the db2. But now I have another
errormessage never seen before:
"The provider reported an unexpected catastrophic failure."
This seems to happen during inizialisation? ?
I used the following registration:
EXEC sp_addlinkedser ver
@server = 'DB2',
@srvproduct = 'Microsoft OLE DB Provider for DB2',
@catalog = 'JDE_PROD',
@provider = 'IBMDADB2',
@provstr='Provi der=IBMDADB2;Da tabase=JDE_PROD ;HOSTNAME=xxxx; PROTOCOL=TCPIP; P
ORT=5000;uid=xx xx;pwd=xxxx;'
If I read the article correctly it should work using the DSN pointing to the
db2 which is installed on the SQL server.
But as mentioned, the error above occures or it seems that the
EnterpriseManag er hangs when accessing tabes in the linked-server.
Thanks a lot Simon,
Seize the Day
Andy
Andreas Bretl an***********@b rainlab.com
Bretl,
If you want to use the IBM provider then you need to have IBM's DB2 Connect
product installed on the SQL Server.
If you want to use the MS provider, then you need to have Host Integration
Server 2004 (latest version on SNA Server) installed on the SQL Server as a
"nodeless" install - this is basically a server install without choosing to
install the SNA Server service.
Do you have either of these pre-requisites installed and tested first?
(If you go the MS route it's worth posting future Q's in the Host Integration
Server newsgroup on the MS public servers - you're likely to get better help
there)
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index....partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
First of all thanks to all who tried heling me with this problem.
Actually it seemes to be a problem with the current fix-pack installation on
the JDE Database-Driver (DB2-ODBC).
Maybe it was damaged or really out of date so it could not communicate with
our SQL Server 2000.
After installing the current fixpack I was able to implement linked-server
over ODBC without problem.
What a hassle when they do not keep their system installation up to date.
Thanks again and have a geat week,
Andy Bretl an***********@b rainlab.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Subhas |
last post by:
Hi,
I have a linked server connection from SQL SERVER 2000 to Sybase
11.9.2 and can see all the tables and views in sybase database. But,
when I try to access a table from MSSQL SQL query analyser it is not
able to access one single table and gives the following error....
I am a newbie in SQL2000. Please help.
Server: Msg 7356, Level 16,...
|
by: Andy |
last post by:
Hi,
Please help, I'm getting desperate. Any ideas warmly welcomed!
I'm trying to read from a basic excel file (1000 or so rows from
column A) but am having problems. The code I am using is:
Declare @Return Int
SET NOCOUNT ON
Exec @Return= .. 'READ_XLS', 'EXCEL',
'Microsoft.Jet.OleDB.4.0' , 'e:\jsbackup\RACodes.xls',
|
by: pheonix1t |
last post by:
hello,
I'm trying to create a linked server from an SQL2000 to a Unify ELS
(very old, odbc is version 1) database on SCO unix.
The odbc driver is old but it works fine when used by applications for
creating reports.
What I want to do is make a linked server from the SCO box to the win2k
box. So, I'm using enterprise manager to create the...
|
by: Serdar Yegulalp |
last post by:
I'm in the process of migrating a lot of data (millions of rows, 4GB+
of data) from an older SQL Server 7.0 database to a new SQL Server
2000 machine.
Time is not of the essence; my main concern during the migration is
that when I copy in the new data, the new database isn't paralyzed by
the amount of bulk copying being one. For this...
|
by: Lyn Duong |
last post by:
Hi,
I have tried creating a linked server in microsoft sql 2000 to a db2
for vm database. I use a db2 v8 admin client, configure it via client
configuration setup and then in Microsoft SQL Server 2000 enterprise
manager, I create a linked server, I use ibm oledb driver for db2,
datasource = mydatabase, product=my database, provider =...
| |
by: David Hay |
last post by:
Need help, SQL Server 2000 latest patch, IBM I series Access for
Windows, 5.3, latest patch, it say's 5.7, but it's 5.3.
I need to use someoething other than MS ODBC for OLEDB drivers. I
need to be able do an insert/update/delete operation on a NON
journaled file.
Any help? other vendors for connectivity are not feasable.
Thanks!
|
by: Vaap |
last post by:
I did lot of googling to see if I can solve the SQL server not found
problem while trying to run ASP.Net community starter kit from an XP
machine to Windows 2003 server hosting SQL server 2000 database. Tried
all possible combinations but it still fails.
I have Windows 2003 server having SQL Server 2000 installed with SP2.
The installation...
|
by: bk |
last post by:
This is driving me crazy. I get "SQL Server is unavailable or does not
exist" error while developing asp.net application in vs2003's IDE
development mode but when I install the application on the server the
error disappears and everthing seems to be ok.
The error does not appear when I connect to the same databse on the
local sql2000...
|
by: basuritta |
last post by:
I am trying to add a SQL2000 subscriptor to a SQL2005 publisher and
distributor using the Management Studio.
I'm using a non-standard port in both ends, but I have set the port
for the TCP/IP protocol to the non-standard port in both the server
and client network configuration.
I can add the SQL2000 server to the Management Studio console...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |