Well, I can't even connect to the host. A get an error message U2DB1004.
I reckon you guys really need to make this a lot easier if you want people tto
use this and buy the other modules.
In the documentation it says something about a JDBC driver that needs to be
installed but isn't included in t
I sometimes use an I-descriptor to create a composite key in a sub-table made
up from the Id of the mv-record and the position of the values in the array.
i.e 123456*1 for the first set of values and 123456*2 for the second and so on.
That way I get a unique key for every row. Or you could of co
You are right, exporting to SQL Server isn't as easy as importing from SQL
Server. I even doubt that exporting data from UD files directly into SQL Server
tables is possible at all without some really fancy programming in foreign
tongues like C# or similar.
The main reason for that is that SQL S
Bill,
I have seen UD 7.2 talk to SSIS without any problems at U2U in Liverpool last
year. So I know it does work.
When I asked if it would also work with 5.2 everybody told me to upgrade.
UniData 5.2 is a dinosaur and no longer supported to boot!
I guess it is the old Informix OLEDB Provider an
Thanks Jeff,
I might give that a try.
Even though the creating views bit doesn't sound too appealing.
I actually have been thinking to start off by leaving it as is and pull the
data from SS 2000 instead of UD 5.2 directly since the table structure is
exactly the same and the updating of the SS
Thanks Bill,
I don't think it is an ODBC problem since SSIS connection managers unlike DTS
don't use ODBC. They use OLEDB and connect even without the IBM U2 ODBC driver
installed.
I maybe have to add that both SQL Server 2000 and 2008 run under Windows 2003,
so I don't think this is an OS iss
Les,
I didn't say ALL developers become dinosaurs (even if Jerry seems to think so)
and PHBs are ALWAYS smart.
The fact that you are in this group probably makes you an exception already.
There are many reasons to stick with the same outfit for a long time; Family,
friends, habit to name just a