THANK YOU, Jerry! I was about to give up hope. ----- Original Message ----- From: "Jerry Johnson" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 5:06 PM Subject: Re: OT PROGRESS Question
> Haven't used it in a few months. > > The people to ask are found on the peg mailing lists > > http://www.peg.com/ > > Good luck, > Jerry Johnson > > >>> [EMAIL PROTECTED] 11/19/02 04:48PM >>> > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
