February 13, 2006 at 7:48 pm
I am trying to pull data from IBM DB2 tables into SQL Server 2000 with DTS. I am getting an error from my sequelink odbc driver that we use to connect to the DB2 tables. It says the table name is too long and has a maximum length of 18 and the DB2 table name is 20 characters. Is there a way to get around this? This is only my second DTS package I have tried to do.
Rob
February 14, 2006 at 6:56 am
Have you installed the latest DB2 client on the machine running the SQL Server? Or what version are you using of the DB2 client, mine is version 8.
February 14, 2006 at 9:07 pm
I know that we are using version 7. We currently connect through Websphere, but I also have an Intersolv 3.10 32-bit Sequelink ODBC driver installed on my machine. Where can I get an update client for Version 7?
Rob
February 15, 2006 at 4:16 am
I don't exactly know how to solve but you can cahnge the name of your table?
February 15, 2006 at 5:48 am
Your vendor who sold you DB2 or IBM should b able to help get the correct client driver. Otherwise you could get a DB2 DBA to build a view of the table with a shorter name for you if you need a quick solution to use.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply