SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:13 PM
| ||||
| ||||
 PROGRESS import of field freezes SQL Server hi, I've got a SQL 2005 with an odbc connection to a PROGRESS database. We can transfer data from the progress to the sql but there is 1 field we can not transfer. This field, proclaimed by the PROGRESS administration, is a field wich can contain an empty string or up to 8 characters. But when we try to do a 'select problemfield, goodfield1,goodfield2 from pub.table' in the import and export wizard and try to preview this select, SQL Server freezes for a loooooong time resulting in an error "defined by component". We have tried to put the problem field into the select clause, with the where clause without the where clause... always the same result. The datatype that we use is a varchar(8) or more but it always freezes. Does anyone have an idea? Note: when progress exports to a flat file and we import that flat file, this works without any problems. So instead of using the odbc connection to transfer the data overnight, we would like to use flat files and import them with Integration S. Good solution or not?      |
Linear Mode
