Search results

Thank you very much OSBORNE. With your help , i solved my problem. I add also an useful link of Progress Inc too.. Regards to you and all members of this useful site... Thanks again. Progress KB - How to escape the tilde '~' and other special characters in Progress?

Hi to all. I have some problems to replace a character in a field of a table. I use Progress v.10.2.b In that field there is a \ character at the end of the field (CHR(134)) I need to replace \ character with a blank character. I was able to do that only quoting the string , but this...

Thanks Cringer for your reply.

Hi to all. I use Progress 10.2.B version in a Character Gui environment .. Our software is working on AIX IBM OS-System. We'd like to read data directly on a Windows Server ,, SQL SERVER 2014 Bi version. In this server we have a DB about Logistic software ... What is the best solution ??? I...

I tried to investigate what best index to use. I add WITH INDEX clause in SQL query to specify best index ... I ran during user activity query 5 times,,,never blocked with violation primay ley error,.... Will see ...thanks again to all of you... ................ ................. From pub.gpdc...

Thank a lot for your suggestions. I will see how much is it this PRO2 product ..i am not IT manger so i could buy everything even if it should be very useful... Regards.

Thanks The Mad Dba. I will investigate on the error... How can i know real index used ??? I am reading via ODBC with query Sql posted ... can i specify an index using SQL (never done..) I think my problem during working days is near what are you explaining to me... I am interested also to...

You are right Tom...thanks a lot. You and other good Progress Specialist ...are my unique bible to solve any strange problems. All times i disturb you with a post...you Always reply ...that's good... Regards.

Thanks Mr.Bascom. I read record from OpenEdge and i write in a table Sql Server... I put other logs in SSIS and you are right...it is a Sql server problem... Sorry for disturb... Thanks...extra logs helped me to understand where is error'origin.. I do not know why ... but i hope to find out...

I add also that if i check the record ...that record is really was touched or is in touching by an user the same day .. For this it is really very strange message...

Sorry i forgot to post error message i encountered.. ======================= Errore Pacchetto: Imp_Clienti Codice: -1071636471 Descrizione: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server...

Thanks Chris for your suggestions.... I will investigate better and about Openedge Pro2 ... Thanks again ...

Thanks Mr.Bascom. I read data from an Openedge DB 10.2B version, I use 32 bit ODBC driver, because Visual Studio is a 32BIT application. My code inside a SSIS package of SQL SERVER 2008 R2. DSN Isolation Level READ UNCOMMITED as told Progress Help Desk and i do nout use WITH NOLOCK hint,,, I...

Hi Chris.. thanks for your kind reply ... I only need to read records to populate a Sql server table ... It is a customers table with 5.000.000 records... I use Openedge 10.2b and i think it is not a driver problem. When i read records in the night , no concurrency there is,,and so no problems...

Good morning to all of you. I have this problem. I need to pull data from a OpenEdge DB version 10.2.b...using ODBC driver and SSIS of SQL SERVER 2008 R2 .. No problem if there are no locks. If there is a record lock , the package fails with error. My db dsn is setted with Default Isolation...

Thanks to all of you for kind replies. I try to explain my need. We use an italian Retail software written in Progress 10.2B Version. It runs on AIX system. I work as It help-desk and programmer. Our company has 1300 sessions every days working in real time. Our company has 80 stores. Our...

Hi to all. I am studying VST Tables. I am interested on table _Lock I need to know every possible values i can have in fields : _Lock._Lock-flags. I found this useful article http://knowledgebase.progress.com/articles/Article/21639 that explain how this field is set in PROMON Utility.. How...

Good evening. Thanks for your useful advice. I will try to study about REST services...even if i think i will have to use web services with WSDL. Thanks again.

Good evening. Thanks for your kind reply. I think i will use WSDL ... I did not know anything about REST services.. I will try to study about them... My first example is using WSDL... Now begin difficult part...try to consume real thirdy party web services.. Will see.. Thanks again.

Good Evening. Thanks for your kind reply. I read about it...i will try to understand better ... This website is very useful... I will try to write real web services against real request... Thanks again..