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 |
|
Gyro
Starting Member
2 Posts |
 Posted - 2002-05-27 : 04:29:29
|
| does anyone know how to configure a DB2 server link in a SQL2000 Server? I've read the manual, but i can't seem to do it right.i posted my command below.sp_addlinkedserver @server='AS400', @srvproduct='Client Access ODBC data source', @provider = 'MSDASQL', @datasrc = 'Model530' @provstr ='uid=mfgofr;pwd=smepws' this should work, but it hangs up when i try to execute a query on it. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-05-27 : 07:36:44
|
| Try to establish the connection using the Enterprise Manager not T-SQL. There you can get a graphical display of an OK connection (link) between servers. If the link is OK and the query still hangs up, then you have a problem in the query sintax. |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-05-27 : 08:39:45
|
| We had significant problems trying to established connections to DB2 on OS/390 (the mainframe), to the extent that at one point in time, executing a sql statement from QA against the DB2 caused a SQL server abend , and required server re-boots. We got workarounds by making use of different DB2 drivers - can't recall exactly what we installed to get new drivers- I'll get back with that when I can.Eventually we did get the process working, but the project decided upon a different mechanism... |
|
|
|
Gyro
Starting Member
2 Posts |
Posted - 2002-05-27 : 20:47:48
|
| i've tried it in em already, but i got the same response. it hangs!we are running our as400 on os400 v3r7. we're using client access v3r2m2. this might help when you try to look for the driver. we don't have ca-express because of our old version of ca. we can't buy drivers because it's to much. =)Edited by - Gyro on 05/27/2002 21:15:52 |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-06-04 : 07:34:39
|
| Hmmm - we installed from the following. I don't know if this will helpl you at all, but here ya go. REMEMBER - THIS WAS DONE FOR OS 390 - I'm uncertain if this has a driver capable for the AS400 (I didn't actually do this process, but was informed of it afterwards).********1. Install SNA Server 4 ClientOnly install the SNA 4 Client component from the installation CD. Ignore any SNA Server setup/configuration questions.2. Install SNA Server 4 Client Service Pack 4Install the SNA Server 4 Client Service Pack 4 from the Microsoft Select CD collection or download the SNA Client SP4 from the Web.Install the service pack as per the Readme.txt file contained in the SP4 documentation. This entails running the update.exe in the .\clients\winnt\i386 directory – DO NOT run the setup.exe in this directory.3. Enable the DB2 OLE DB driverAfter the SP4 install the DB2 OLE DB Driver is not installed as yet. Run the setup menu option from the Main SNA menu under start programs and click on the DB2 OLE DB Driver and then Continue to install. |
|
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-06-04 : 12:04:16
|
| Found this on a FORUM SEARCH. It's from one of ROBVOLK's old postings referencing the IBM support website.http://www-3.ibm.com/software/data/db2/udb/ad/v7/oledb.htmlIt includes references to Microsoft walk-thru examples of setting up OLEDB providers to DB2.Edited by - kevin snow on 06/04/2002 12:06:09 |
|
|
|
|
|
|
|
|
DB2 Linked Server