Sep 17, 2008. No, it's not what you think--I do know how to start the 32 bit version of Data Sources Manager. The docs on the Progress Knowledgebase make things sound so simple--install the Client Networking portion of the client onto the 64 bit server, and then fire up the 32 bit version of the Data Sources Manager.

/ABDetail&rs:Command=Render&rc:Toolbar=true&Card_ID=8557MPS&Answerbook=V antage/Vista+8.0+-+General+Information+documents Ernie Lowell IT Specialist STERLING MACHINE. A Division of SENIOR Aerospace 4 Peerless Way Enfield CT. 06082 TELE: 860-741-2546 x136 FAX: 860-741-6119 ________________________________ From: darylmark via epicor-l [mailto:epicor-l@Groups.ITtoolbox.com] Sent: Wednesday, March 19, 2008 11:31 AM To: Ernest Lowell Subject: RE: [epicor-l] ODBC connection OpenEdge 10.1B Hi Ernie, Thanks for your feedback.

Could you send me the link to the knowledgebase in Epicor as I can't seem to find the area that I need to go into in order to find the document that you refer to below? I really appreciate it. Matthews IT Technician Polaris Connectors Inc Ph: 727-546-4285 dmatthews@polarisconnectors.com ________________________________ From: eglowell via epicor-l [mailto:epicor-l@Groups.ITtoolbox.com] Sent: Wednesday, March 19, 2008 11:22 AM To: Darryl Matthews Subject: RE: [epicor-l] ODBC connection OpenEdge 10.1B When I setup the ODBC connector to use Excel for reporting purposes, I had to do a registry hack to get it working. On the Epicor support site, look for document number 8557MPS. It seems the Open Edge driver does not correctly identify itself to the Microsoft ODBC menu. Ernie ________________________________ From: darylmark via epicor-l [mailto:epicor-l@Groups.ITtoolbox.com] Sent: Wednesday, March 19, 2008 11:07 AM To: Ernest Lowell Subject: RE:[epicor-l] ODBC connection OpenEdge 10.1B My ODBC shows an entry 'Progress OpenEdge 10.1.B Driver'.

When I click Finish to add a new entry, I get the error message: 'The setup routines for the Progress OpenEdge 10.1B driver ODBC driver could not be loaded due to system error code 126.' ' Clicking ok then gives me the message: 'Could not load the setup or translator library'. Anybody got some clues as to how I can resolve this problem? -----Original Message----- At 04:26 AM 2/27/2008, dobby via epicor-l wrote: >When you say install driver on disk from where I have used net setup>to install shared open edge 10.1b but after changing register and>files I can now see progress open edge in odbc but still not detecting driver? What you mean by 'not detect'?

If you can see it in ODBC then it *can* detect it. What is the exact error message you're getting? I'm thinking you're getting the very unhelpful error message about 'invalid attribute'. Or you're getting 'no driver available' which is an ODBC programming error, not a Progress one. Geoff Crawford email@removed. Hi Ernie, Thanks for your feedback. Could you send me the link to the knowledgebase in Epicor as I can't seem to find the area that I need to go into in order to find the document that you refer to below?

I really appreciate it. Matthews IT Technician Polaris Connectors Inc Ph: 727-546-4285 dmatthews@polarisconnectors.com ________________________________ From: eglowell via epicor-l [mailto:epicor-l@Groups.ITtoolbox.com] Sent: Wednesday, March 19, 2008 11:22 AM To: Darryl Matthews Subject: RE: [epicor-l] ODBC connection OpenEdge 10.1B When I setup the ODBC connector to use Excel for reporting purposes, I had to do a registry hack to get it working. On the Epicor support site, look for document number 8557MPS. It seems the Open Edge driver does not correctly identify itself to the Microsoft ODBC menu. Ernie ________________________________ From: darylmark via epicor-l [mailto:epicor-l@Groups.ITtoolbox.com] Sent: Wednesday, March 19, 2008 11:07 AM To: Ernest Lowell Subject: RE:[epicor-l] ODBC connection OpenEdge 10.1B My ODBC shows an entry 'Progress OpenEdge 10.1.B Driver'. When I click Finish to add a new entry, I get the error message: 'The setup routines for the Progress OpenEdge 10.1B driver ODBC driver could not be loaded due to system error code 126.'

' Clicking ok then gives me the message: 'Could not load the setup or translator library'. Anybody got some clues as to how I can resolve this problem? -----Original Message----- At 04:26 AM 2/27/2008, dobby via epicor-l wrote: >When you say install driver on disk from where I have used net setup>to install shared open edge 10.1b but after changing register and>files I can now see progress open edge in odbc but still not detecting driver? What you mean by 'not detect'? If you can see it in ODBC then it *can* detect it.

What is the exact error message you're getting? I'm thinking you're getting the very unhelpful error message about 'invalid attribute'.

Bifinett Kh 2230 Manual Treadmill. Or you're getting 'no driver available' which is an ODBC programming error, not a Progress one. Geoff Crawford email@removed. When I setup the ODBC connector to use Excel for reporting purposes, I had to do a registry hack to get it working.

On the Epicor support site, look for document number 8557MPS. It seems the Open Edge driver does not correctly identify itself to the Microsoft ODBC menu. Ernie ________________________________ From: darylmark via epicor-l [mailto:epicor-l@Groups.ITtoolbox.com] Sent: Wednesday, March 19, 2008 11:07 AM To: Ernest Lowell Subject: RE:[epicor-l] ODBC connection OpenEdge 10.1B My ODBC shows an entry 'Progress OpenEdge 10.1.B Driver'. When I click Finish to add a new entry, I get the error message: 'The setup routines for the Progress OpenEdge 10.1B driver ODBC driver could not be loaded due to system error code 126.'

' Clicking ok then gives me the message: 'Could not load the setup or translator library'. Anybody got some clues as to how I can resolve this problem? -----Original Message----- At 04:26 AM 2/27/2008, dobby via epicor-l wrote: >When you say install driver on disk from where I have used net setup>to install shared open edge 10.1b but after changing register and>files I can now see progress open edge in odbc but still not detecting driver? What you mean by 'not detect'?

If you can see it in ODBC then it *can* detect it. What is the exact error message you're getting? I'm thinking you're getting the very unhelpful error message about 'invalid attribute'.

Or you're getting 'no driver available' which is an ODBC programming error, not a Progress one. Geoff Crawford email@removed. My ODBC shows an entry 'Progress OpenEdge 10.1.B Driver'. When I click Finish to add a new entry, I get the error message: 'The setup routines for the Progress OpenEdge 10.1B driver ODBC driver could not be loaded due to system error code 126.' ' Clicking ok then gives me the message: 'Could not load the setup or translator library'. Anybody got some clues as to how I can resolve this problem? -----Original Message----- At 04:26 AM 2/27/2008, dobby via epicor-l wrote: >When you say install driver on disk from where I have used net setup>to install shared open edge 10.1b but after changing register and>files I can now see progress open edge in odbc but still not detecting driver?

What you mean by 'not detect'? If you can see it in ODBC then it *can* detect it.

What is the exact error message you're getting? I'm thinking you're getting the very unhelpful error message about 'invalid attribute'.

Progecad 2011 Professional Italiano Download Firefox. Or you're getting 'no driver available' which is an ODBC programming error, not a Progress one. Geoff Crawford email@removed.

Hi, I am using SSIS to transfer a Database from progress to Sql server. I am using OpenEdge 10.1B ODBC driver to connect to progress. Here Progress is Source and a Sqlserver is the destination I have created a Linked server from my Destination Sqlserver to the Progress Database. Now how can i Transfer the whole Progress Database to Sql server using SSIS.

Can i user Transfer Database Task to import Progress DB to SQL Server. Please let me know how i can use the Linked server as my source?? Regards Ranjeeta. Hi my name is Mauro and i am new of SSIS sql server 2008 r2. I am writing to you because i read you are the only programmer that did a SSIS to transfer data From Openedge Progress DB to a SQL SERVER Database. Me too i have installed OpendEdge Odbc Driver for Progress,,,,10.2b and not 10.1b as you,in you example of three years ago.

My problem that i received an error when i create a connection manager to connect to DB PROGRESS. The error is that. Test connection failed because of an error in initializing provider error [IM14] [Microsoft] [Driver Manager ODBC] Errors found! The specified DSN contains an architecture mismatch between the Driver and Application.' If i try to connect to my OPENEDGE Progress DB from Powerpivot of Excel or with Reporting Services.i can do it.

I also copied and paste all data connection to connection manager connection string,,,but nothing. I selected.NET Providers /Odbc data Provider Then i selected DSN to my OpenEdge Progress that i create previuosly. SORRY i wrote. I hope you can give me any suggestions. Ciao many thanks for your kind reply. For this, me too i have the same doubt.

I used also LINKED SERVER but with it, i encountered a syntax problem i was not able to solve. The problem is written below. I have a query with a field name with MINUS character and this it does not like to LINKED SERVER. WHAT CAN I DO???? Do you ha ve any suggest to override the MINUS problem???

For this reason, i am trying to solve problem with reading directly PROGRESS OPENEDGE In any way i write below my query in LINKED SERVER too, in BOLD font the name field with MINUS. The query give me the error written below after the query. It seems LINKED SERVER treat character '-' as a keyword or reserved word. In any way.i am blocked about these problems. T H A N K S in advance if you have any suggest.

Thanks too much. Quoting name of field as you suggested, i solved my problem. I have to write a.docx to remeber all particular syntax querying data from an OPENEDGE database.

Besides this problem i encountered a problem with 3 problems: SQL WIDTH of field different from format of the field. ( I solved this using DBTOOL utility of PROGRESS RDMS) field as EXTENT (similar to array) i found only in OPEND EDGE PROGRESS DB. ( I solved this, treating these kind of fields, Finally this problem to query name of field with MINUS CHARACTER. T H A N K S a lot. Do you suggest to write all problems i encontered pull data to an OPEND EDGE PROGRESS using LINKED SERVER????????? Regards and many thanks AGAIN!!!!!

I FEEL better.:-). You can't post new topics. You can't post topic replies. You can't post new polls. You can't post replies to polls. You can't edit your own topics. You can't delete your own topics.

You can't edit other topics. You can't delete other topics. You can't edit your own posts. You can't edit other posts. You can't delete your own posts.

You can't delete other posts. You can't post events. You can't edit your own events. You can't edit other events. You can't delete your own events. You can't delete other events. You can't send private messages.

You can't send emails. You can read topics. You can't vote in polls. You can't upload attachments.

You can download attachments. You can't post HTML code. You can't edit HTML code. You can't post IFCode. You can't post JavaScript. You can post emoticons. You can't post or upload images.