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 |
|
lukemcc
Starting Member
2 Posts |
 Posted - 2007-10-03 : 16:38:01
|
| I have an application running SQL Server 2005. I have an external Database from an outside source that is running DB2(v9). To get data into SQL Server I need to pull data from DB2 using views on an odbc connection.Does anyone know of any performance issues or issues at all with SQL Server reading from DB2(v9) using an odbc connection?I don't want to even get started trying if there are known errors.Thanks for any help or suggestionsLuke |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-03 : 22:17:03
|
| Is db2 on same network with sql2k5? How many data involved? |
 |
|
|
lukemcc
Starting Member
2 Posts |
Posted - 2007-10-04 : 12:02:01
|
| Thanks for the reply,They are on seperate networks. I have SQL Server in my network.SQL server is going to need to pull in 2 million rows and 78 columns once every day. It's about 150mb. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 14:57:48
|
| Agree, especially cross networks. Sql may unable to see db2 directly at all. |
|
|
|
|
|
|
Exposing a DB2 View to SQL Server 2005