odbc

  1. L

    Resolved How do I to grant read only SQL access to ODBC user

    Using the data dictionary, I created a new ODBC user. I do not want this user to have access to all tables and only want the user to have read only access to a few tables. I've created the script with the tables I want to grant access on using the example found in article P55080 on the progress...
  2. C

    Linked Server to ODBC

    Hi all out there, I have read many posts (inside and outside this forum) that deals with the error 7303 when trying to setup a linked Server object in SQL Server to reach a Progress database though the use of an ODBC driver. My situation: SQL Server 2016 on a 64-bit OS server (virtual) A...
  3. N

    ODBC connection causing DBI file grow

    Hi everyone It happened today that while connecting to the database and querying tables on our progress server the .dbi several files were created. Each of them was about 3GB large and because of it we nearly ran out of space. Is there any way to prevent these file growth (i.e to not be larger...
  4. B

    How to find out if record is locked

    Hello community, by a PHP Application i want to update a dataset inside a Progress-Table, that is working generally. But it is possible to work on the same dataset inside our EPR-System that locks the dataset. Now when i want to update the dataset this i get this error. SQL error...
  5. S

    Update records in Progress DB using SSIS

    Hello, I have a Progress DB as an ODBC source which i export data from to allow transformation and then import into a SQL DB. I would like to import cleansed data back into my Progress DB (update is most important but insert/delete could be useful too) Does anyone have experience of doing...
  6. P

    Connecting mssql database remotely in linux platform without running progress broker

    I want to connect ms sql which is hosted remotely in windows. But how can i connect this to progress, any solution without running broker in windows?
  7. V

    Propath for progress odbc broker

    Hi, We try to write in progress 9.1d with the odbc Merant 3.7 We have succeeded to write on some table. But table who have triggers give us an error message: System.Data.Odbc.OdbcException: ERROR [HY000] [MERANT][ODBC PROGRESS driver][PROGRESS]** "triggers\write\item.p" was not found. (293)...
  8. C

    Linked Server Progress to SSQL Server via ODBC

    I want to link a Progress DB to MS SQL Server. I use the guide on: Progress KB - How to link to a Progress / OpenEdge database from Microsoft SQL Server using a Progress / OpenEdge ODBC Driver ? Local on my Windows 8 notebook, I have also installed a MS SQL Management Studio. "1) Setup an ODBC...
  9. P

    Progress 9.1d Odbc Driver For Windows 2008 R2

    Hi, We have a need to connect from Windows2008 R2 server to a progress 91.d database on linux. This version of progress is 32 bit and windows version is 64 bit. Have been unable to install client networking which has the Merant odbc driver inbuilt on a windows2008 server. Any ideas on where i...
  10. R

    Question Odbc And Multi Tenancy

    I am looking at using OpenEdge Multi Tenancy database for a solution that requires connections via a) a SQL Server Linked server, and b) .Net ODBC connection. I am using Progress OpenEdge 11.6 Driver (actually 11.6.3). Using OpenEdge Explorer with Sports2000 database, I have: Enabled Multi...
  11. jysharma

    Question Segmentation Fault When Using Isql For Odbc Connection

    Hello, OS: Red Hat 4.1.2-54 Linux 2.6.18-92.el5 #1 SMP Tue Jun 10 18:49:47 EDT 2008 i686 i686 i386 GNU/Linux Progress OpenEdge Database Release 10.2B on Linux 32 bit ODBC Driver: pgoe1023.so (which was available with the database package) export LD_LIBRARY_PATH=/usr/dlc/odbc/lib:/usr/dlc/lib...
  12. ezequiel

    Question Connect To 11.6.2 From Libreoffice

    Hello, after a lot of years with Progress 9.1 we are just starting with 11.6.2 - 32 bits This happens in a Windows 8.1 computer. I made a local copy of a 10.2 database and converted it to 11.6 I created a ODBC 32-bits connection and works fine. In LibreOffice, created a .ODB using the...
  13. J

    Question _sqlsrv2 Low Cpu Very Long Running Query

    We're currently using Progress 10.2B via ODBC and recently ran into the following issue: Progress KB - Running SQL query with large WHERE IN clause crashes _SQLSRV2 on some UNIX systems The work around for us was to increase the -SQLStack parameter (2000 wasn't high enough to get us around our...
  14. C

    Question Interfacing PHP with Progress 8.1

    Good Day, I got this client who has a legacy application with stale data on progress. The db server is on Wint NT4 and the client is on Windows NT terminal. They want to access their data , for historical research sometimes, in another method then Windows NT terminal client. Right now, both...
  15. J

    Answered Progress 10.2B ODBC Savepoints?

    I see that it appears as of 10.2A progress started supporting database save points which is exactly what I was hoping to use in this php application. However, when I search through the dmsql and dmsrf documentation the only thing I can find referencing a savepoint is in the error code. I'm not...
  16. J

    Datadirect|Merant|Intersolv ODBC Driver for Progress 8.x

    Dear all, I am seeking any old SQL98 (OID/OIB) driver for Progress 8.x (8.3E, really). Could anyone upload it here? Or tell me how/where to find it? I'm kind of desperate, seriously. Thanks a million guys. PS: I cannot use the modern openlinkws/datadirect|sequelink drivers.
  17. B

    Question ODBCCommandBuilder generating incomplete SQL

    I'm having the same trouble as this person (no resolution): http://www.progresstalk.com/threads/openedge-net.94524/ I'm making a C# .NET program that can perform CRUD functions through ODBC on any one table in the Progress database as a quick and dirty maintenance tool. Attaching an...
  18. A

    Error ODBC Connection via PHP (solved)

    Hi, I am currently working on a ODBC connection via PHP to an OpenEdge. Well I actually gave up. I don't get it working. I am testing the connection fresh installed system: Linux debian 3.2.0-4-686-pae #1 SMP Debian 3.2.60-1+deb7u3 i686 Apache Version Apache/2.2.22 (Debian) PHP Version...
Top