| Author |
 Topic  |
|
|
snaayk
Senior Member
USA
1061 Posts |
 Posted - 27 February 2003 : 13:37:54
|
I was wondering if there was a way to link up with a db2 server that is running. I don't administer it or even really know who does. I currently login using a qmf panelto run queries and export reports.
I found this connect string:
oConn.Open = "Provider=DB2OLEDB;" & _
"Network Transport Library=TCPIP;" & _
"Network Address=xxx.xxx.xxx.xxx;" & _
"Initial Catalog=MyCatalog;" & _
"Package Collection=MyPackageCollection;" & _
"Default Schema=MySchema;" & _
"User ID=MyUsername;" & _
"Password=MyPassword"
But I am not sure what to make of it. I currently login and have to type in commands at a menu to get where I can run queries.
I am hoping to run a dts package out of MSSQL and import some data into mssql.
Anybody have any experience with this?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 February 2003 : 15:22:01
|
| I don't have experience with DB2, but anyway it shouldn't be too hard. I've checked that DTS does not have a OLEDB driver for DB2, but I guess you should have one available with DB2 and you could install it. Once you get the driver installed (OLEDB or ODBC) it's just as if you were importing from any of your usual sources. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
seahorse
Senior Member
USA
1075 Posts |
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 28 February 2003 : 12:15:39
|
quote:
Originally posted by ruirib
I don't have experience with DB2, but anyway it shouldn't be too hard. I've checked that DTS does not have a OLEDB driver for DB2, but I guess you should have one available with DB2 and you could install it. Once you get the driver installed (OLEDB or ODBC) it's just as if you were importing from any of your usual sources.
I can't find the oledb driver, no one seems to have one. I will continue to search... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 28 February 2003 : 15:27:55
|
quote:
Originally posted by ruirib
In SQL Online books there is a reference to a Star SQL driver, but it seems to be part of a commercial software package.
Thats what I seem to find online, commercial drivers. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 01 March 2003 : 22:28:10
|
hehe, according to them they provided it when the system was bought. SO! give it again! But we're such a huge company and there are so many chiefs and few indians that it's almost impossible to find the person who has the ability to request a driver. Few (if any) have tried what I'm trying. They usually export to excel and go from there.
I'm trying to automate the whole report process through dts. I 'm creating a script run the report export to a delimited file then have dts ftp the report from the mainframe and import into SQL. I've got it all done save the FTP part (keeps freezing). I was hoping to avoid the running of the report, export, ftp and import....oh well. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 March 2003 : 07:58:29
|
| I've been to the IBM DB2 site and it seems that they have a free Personal Edition for Windows machines. I guess that should include Windows drivers, though I cannot be sure. Maybe you can give it a try. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 02 March 2003 : 10:52:04
|
quote:
Originally posted by ruirib
I've been to the IBM DB2 site and it seems that they have a free Personal Edition for Windows machines. I guess that should include Windows drivers, though I cannot be sure. Maybe you can give it a try.
didnt notice, I'll take a look. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
