Recent content by rdekker

Since the search doesn't seem to work and I'm not sure in which forum I have to post this question, I'll try this one. We're using a Windows Server 2008 machine with IIS to connect to a Progress database-server (version is irrelevant because we've had this problem for a long time with different...

I have a strange problem connecting a catalog on an open connection. When I connect to database A first and then issue a connect 'pathtodbB' as catalogname (database B) it's fine but the other way around I get this error. So connecting to database B is fine but then issue a command connect...

We don't own one of the databases. I connect to three databases. One of these databases belongs to a sofwarecompany and we only have read access to it on the sql connection. The 4GL connection is also a write-connection. (maybe our DBA doesn't allow us to write via SQL I don't know).

I now have the query plan. I don't see anything special except for that one join was using a full table scan due to one missing join field to perform an index scan. I added the extra field and it's now using an index scan. Strangely enough when I perform the query on the total resultset it takes...

I have a large query joining eleven tables together with a resulset of 15000 records. By default (all records) the query has 6 predicates in the where clause. It will cost the databaseserver about ten seconds to cough up the recordset. When I add another predicate in the where clause the number...

The 3 stars are actually the characters A S and S but they are automatically replaced by the forumsoftware. Thanks for all your comments. I can't get it working however. My primary database is called "mutatie". In the directory where the database is located I created a file named...

I thought so, thanks!

Is it possible to use a single ODBC connection to query different Progress databases (running in different ports)? With SQL Server I can run queries over different databases as long as the account used for the connection has sufficient rights. Is this in any way possible for a Progress ODBC...

Ok thanks! We'll contact them today and see what happens.

Are you talking about the Openedge Explorer tool? Because we already knew that, but there is a webbased version available to do the things we need.

Is this possible? We're having some problems installing it. There seems to be a r10.2B install somewhere but we can't find it in the downloadcenter. Is there anybody who can help us? We have ordered a server with 16 GB of RAM which we want to use for the Progress databaseserver (currently...

This worked! Thanks a lot!

Sometimes when I run a query for creating a recordset and iterate through the records I receive this error: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Error in row. The problem is caused by the fact that one or more fields in the record holds more data than the display format...

ODBC - Server rejects connection on attach We've solved the problem mentioned above. It had to do with a second NIC in the server which was active. This was the problem apparently. We now have another problem sometimes. Anybody knows what could be the problem for the error mentioned below?

Progress version is 10.1C en OS is Windows 2003 Server.