A voice in the wilderness calls: I am trying to make an ADODB connection in VB to a PROGRESS database (odbc connection: MERANT PROGRESS driver) in order to copy records from several tables over to a MSSQL database. The odbc connection is fine in connection manager, but any attempt to actually USE IT fails with numerous interesting but unhelpful error messages. The project entails moving the records to SQL, manipulating them into new tables, exporting to text files for import into another SQL database (Great Plains). I can produce text files from PROGRESS reporting utilities front-ends that can be imported by SQL through DTS, but this has to be a hands-off, automated daily process. Advice on this matter is not covered under our support agreement, and our consultant fund is way past dried up; I would very much appreciate any advice from anyone with any experience with PROGRESS.
Thanks! Susan Allen [EMAIL PROTECTED] Pfingsten Publishing, L.L.C. Cleveland, Ohio ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
