This is the first time I've worked with Informix. I'm doing this export with LotusScript and an ODBC connection on my desktop. What should I do?
Also, I have a SQL Server database running on my local Notes server, where this application resides. I created a test table to which I can write this data, and when I try to write the rich text field data to a "text" data type in the SQL server table of my test database, it only writes some of the data, and only on some of the rich text field data. I'm using a string var to do this. Does this suggest a memory limitation for the string var I'm using in LotusScript?
Do you have comments on this Ask the Expert question and response? Let us know.
This was first published in June 2004