Bob Witney wrote:
P'raps we are not being clever enough to break them :-)
If only our problem was that we were too clever... Seemingly, although
we've been at a retreat all day & haven't fully tested this out, it's
actually a matter of some bad data -- we fixed a lot of fields so that
they are presented as varchar rather than char, which had been giving us
other problems, but left the ID field alone because it should always be
6 digits. Well, when I stripped everything from the query except for ID
it failed at the same number but with a different error, that it had
expected 6 digits but hadn't received them, so it bailed. We've seen
that before, but the error message when we had several fields in the
query didn't point that way; I'm not sure why.
I'll post when we verify this over the weekend or Monday, but I'm pretty
sure that's the case. Many thanks again for all the replies, and to note
-- we're stuck at S7 for now for other reasons (likely moving to Oracle
on Linux, actually, and therefore the jdbc drivers which I know have a
different syntax; we will have S2K in house in the not too distant
future), and we'e also going to be exploring the various other data
export options, XML actually being the most likely in this case as this
is a once weekly re-dump to rectify any misses which may have taken
place from a perl script we have which fires off for certain programmed
actions & updates the S7 server with DBI:Proxy.
Again, many thanks.
Bob
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Don Kibbey
Sent: 17 June 2005 13:17
To: [email protected]
Subject: Re: [U2] IBM ODBC vs Ardent ODBC driver
I gave up on the ODBC stuff a while back. I now build my SQL tables
by producing text files on the HP/UniVerse machine and then launching
a DTS job with an ftp module that pulls the data down to the SQL
server and imports it that way.
Much less twidling with drivers this way.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
