Progress 9.1D Full Version Fixed

I found this article on the progress database, but by the sounds of it you may need upgrade your progress version to get the functionality, but as I mentioned earlier someone has probably run into this issue before and could provide some real life experience.

I've searched online for this information but cannot find it. We have Vantage 6.10.543 running on a legacy Windows Server 2003 (32-Bit). Progress version is 9.1d. I want to get Vantage upgraded but that's another story.

Progress 9.1D Full Version

DOWNLOAD 🔥 https://urluso.com/2y1GmR 🔥

I have an old application that I manage that runs on top of a progress database. I'm trying to gather some information, for various reasons. At a minimum, I need to know when Progress 9.1 and 9.1D were released. I mention these two versions because we are using 9.1D and, I assume, the "D" revision is probably just the fourth iteration in miner updates since the initial release of 9.1.

Assuming that this db still exists on the original system knowing what OS it is would help. If this is a unix variant "find -name progress.cfg -print" should reveal the installation directory. Export an environment variable named DLC pointing at that dir -- i.e. export DLC/usr/dlc. There will also be a "bin" subdirectory. Put that in you PATH. Then type "showcfg". That should reveal what licenses you have available -- which goes a long ways towards narrowing down the options available to open the db and work with the data.

Not sure if it is the correct group ;-)

I have worked with Progress 6,7,8 and 9 some years ago and I have still a progress 9.1D version on my PC.

Now I have to compile some programs for a customer and I get above error message.

Regards,

Paul Fry

paul_fry@speakeasy.net RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)13 Mar 02 12:03We are on 9.1c and are using Merants SLQ92 driver(Supplied to us). I have just started some ASP apps and Visual Basic developement with it. So far I couldn't be happier. The speed is well beyond my expectations and all the errors I use to receive, seem to be fixed. I wrote more error checking than I wrote application.

The upgrade to 9.1C was easy. Infact we still have 9.0b running on the same server. Our database schema changes had some problems but that isn't Progress, it's our manufacturing software vendor's problem.

I will try to help you with any questions you might have.

There are still better and faster ways than ODBC. I have started to rewrite apps in Progress 4GL and I am looking at webspeed.

Regards,

Franklin RE: Need ODBC help New to Progress seven7 (Programmer)13 Mar 02 12:16Good to hear it about 9.1C!! Yes, I'm sure native connections (including WebSpeed) are much faster than ODBC even in 9.1C. Just to let you know, I have 14 years of experience developing apps in Progress: GUI and character. I have about .05 years experience with ASP (lol), but I want to learn it. Maybe we could trade expertise via email or this forum. I have a little bit of WebSpeed exposure from a free seminar about 2 years ago (yeah, big help!) but basically, SpeedScript is 99.5% Progress 4GL.

BTW, there is some kind of "hybrid webspeed/ASP" protocol or DLL that you might want to check out. Regards,

Paul Fry

paul_fry@speakeasy.net RE: Need ODBC help New to Progress lyric1uk (IS/IT--Management)19 Mar 02 11:57Hi

Hope maybe you can help us out a bit here?

We are experiencing performance problems with ODBC on 9.1B, using Crystal Reports & Merant 3.5 drivers. Did 9.1C help from an ODBC perspective? your help would be greatly appreciated.

Many Thanks

Sue Gouldbourne

RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)19 Mar 02 14:57Well you need to move to merants SQL92 driver that progress had written for them. It comes with the progress 9.1c install. I haven't pushed it with complicated crystal reports, but it has greatly improved the performance with other ODBC applications. This drops the old broker system and follows a set standard. RE: Need ODBC help New to Progress NeHe (Programmer)8 Apr 02 23:09I don't suppose you could offer some advice in regards to setting up the SQL92 driver. Is this the 4.1 driver recently released by Datadirect?

I'm stumped when it's asking for a port. Is this the database port? When I connect directly to the database port it says I can not connect because of license issues (although we have enough licenses). When I connect to the broker port used in the 3.6 driver I get an error :)

Probably a really stupid thing to ask about, and I'm sure it's not all that hard to resolve, but after talking with Datadirect, I was no more enlightened than before I spoke with them.

RE: Need ODBC help New to Progress seven7 (Programmer)9 Apr 02 08:50NeHe -

There should be a separate ODBC port number in the services file - here's a sample snipped from the /etc/services file of a current client:

rimprotscl 15810/tcp #RIMS34 SC Prototype Server

rimprotsclt 15820/tcp #RIMS34 SC Prototype tServer

rimoibprotscl 15830/tcp #ODBC SC Prototype

Check out also. That should help get you going!

7seven RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)9 Apr 02 08:59Well the port number is easy to find. Just look in the progress explorer tool. Under your database you should have a default and ODBC configuration group. The port number can be set in there. When you configure the SQL92 driver version 3.6 PGPRO915.DLL. It askes for the port use the port from the ODBC config group in progress explorer. RE: Need ODBC help New to Progress dsi (Programmer)11 Sep 02 10:56franklin1232:

I have just started to dive into this stuff. I am familiar with VB, but have no experience in database connections. We have a Syteline ERP system running on Progress 9.1C. We have a 3rd party application for extracting data that leaves a lot to be desired.

Outside of the fact that I am having trouble creating a new System DSN, I was hoping you would have some pointers to sample code. There are a couple of Merant connections already set up, so I was hoping to use those. Can you recommend any sites that have sample VB or VBA code for reading from a Progress DB?

Any help, pointers or suggestions would be greatly appreciated. RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)11 Sep 02 11:53Well using VB to access Progress isn't really specific to Progress software as it is to ODBC. What you want to find is sample VB code that uses ODBC and SQL to retrieve records. There are a ton of sites with these type of sample. EX: You might just want to start with the MSDN libary if you have it, or stop by your local Barnes and Noble and pick up Programming Visual Basic databases.

As far as your system DSN, What is the driver you are trying to use? When you create a new DSN it will ask you the driver and then you can see what .dll files are being used. I left Merant in the dust. Their drivers sucked.

My last suggestion would be to look at Progress 4GL coding. It provides a native connection to the database and a huge performance increase.

RE: Need ODBC help New to Progress NeHe (Programmer)18 Nov 02 16:04It's been awhile since my last post and I am still having problems connecting to the Progress Database via ASP.

We are currently running Progress 9.1C. Connecting with the Merant 3.70 driver.

I created an ODBC connection called Syteline5. With this I am able to pull data using Microsoft Access, Excel, etc.

I have also made a fileDSN that will allow me to connect and pull data in Excel, etc.

When I use any of the hundreds of freely available connection examples, I get the error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[MERANT][ODBC PROGRESS driver]Optional feature not implemented.

I have no idea how to get around this problem. Is anyone able to give me a working example, a link that has a solution, or some sort of HOPE :)

This is the code that generates the error above:

Session("DSName")="dsn=syteline5"

DSName = Session("DSName")

DbConn = Server.CreateObject("ADODB.Connection")

DbConn.Open (DSName)

Doesn't matter if it's dsn=syteline5 (system odbc) or filedsn=c:\syteline5.dsn, etc.

This is the DSN file:

[ODBC]

DRIVER=MERANT 3.70 32-BIT PROGRESS

UID=

GST=0

SR=1

ASC=0

DBOS=Windows

DBPA=e:\sytedb

DBAM=Direct

OIDH={server name}

OIDS=symixoib

OIDP=TCP

DB={database name}

Would love to hear from anyone!!!

nehe@connect.ab.ca

RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)18 Nov 02 16:17I used to get the error, but it isn't critical. It means some parameter in your connection isn't in use. If you trap the error and then just continue your code everything should work. Your using Jscript so I am not sure how this is done, but in VB it's ON ERROR RESUME NEXT. I wrote a little error trap to catch this error specifically so that any other errors don't get passed by as well. RE: Need ODBC help New to Progress custersb (Programmer)17 Dec 02 05:26Hello Franklin1232,

I'm building a program with Visual Basic to get information from Progress 9.1d, but I'm having problems to create a MERANT 3.6 link. I've tried to add a portnumber in winnt\system32\drivers\etc\services, but when I restart my computer I can't connect to the server here. I think I don't have the correct portnumber, because I just filled in a random number which wasn't used. Can you help me with this? RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)17 Dec 02 09:06Are you using a Progress on a Windows server? Well if your not this probally won't help. Go to the windows server and open the progress explorer tool. You should see your database in the left pane once you log in. You might have two configurations under the database. If so you need the one that is configured for ODBC. If you open them you can tell by the radio buttons at the top. If there is only one, then you are using the same configuration for both 4GL and ODBC connections. Right click and get the properties. The port number will be in the properties. Normally they are in the 3500-3600 range. RE: Need ODBC help New to Progress custersb (Programmer)18 Dec 02 02:58I'm creating a program on my workstation, before I put my program on the server. I'm testing it now, but I don't manage to get clear of the error in network daemon. Do you have any idea how to solve this? Can't I just add a portnumber like 3050, it gives no problems if I restart, but I still can't overcome the error in the network daemon RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)18 Dec 02 11:38The ODBC server daemon has to be listing on a port. If you have progress installed on your workstation it is still acting like a server. Putting a port number in you local host services doesn't do anything for you unless the server daemon or ODBC broker as Progress calls them is waiting for a connection on that port. You need to get to the server that is running the progress database and check what port numbers the ODBC broker is listening on. Then you can add that port number to your local services file. RE: Need ODBC help New to Progress custersb (Programmer)20 Dec 02 04:50I've used the knowlegde base of progress

Okay now I have the connection made. I have typed in the command prompt in the directory of my database:

proserve Proef -N tcp -H localhost -S 3050

and that did the trick!! Now I only have to get the connect via Visual Basic, but that's hopefully the easy part, because it did take a long time before my connection was established!!

Do you know how? RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)20 Dec 02 09:05Sure I know how to connect Visual Basic through ODBC to progress. What type of connection do you want to use? ADO is probally your best choice. Since it doesn't seem like you've done this before, your best bet is to use the ADO data control. On your visual basci controls bar right click and add components. Choice the Microsoft Active Data control. Then place it on you form. Use the connection string property and the connection builder to choose the ODBC entry you've created in your machines System DSN tab using the ODBC in the control panel.

If you have questions or get stuck after this just keep posting. RE: Need ODBC help New to Progress custersb (Programmer)23 Dec 02 02:48I've more experience in Visual Basic then in Progress and I'm able to get information from a Microsoft Access database, but I want to learn how to get the information from a Progress database. I know I have program a connection string for my connection to my Progress database, but my question now is how to write that connection in code. Please pass some code of it to me, so I can solve it easier. Thanks.. RE: Need ODBC help New to Progress custersb (Programmer)23 Dec 02 04:08Hi, I'm making progress with my connection to Progress :), but now I getting the error:

Table/View/Synonym not found (7519)

I've read through the progress Knowlegde Base, but I can't find a way to find my datafield. It is giving me the above error, but I want to select a field from the database with the help of the properties field of a textfield. The datasource I can select!! So that's not the problem. The knowledge base says I must use a prefix, but I don't know how I must add that prefix to my program. RE: Need ODBC help New to Progress custersb (Programmer)23 Dec 02 06:24Th error is solved, but now I want to get information from the database with SQL. I'm trying to search the name of the customer when I'm having the phone number. When I fill in a phone number I press a button, then a SQL statement has to return the name of the customer. My code:

Private Sub Command1_Click()

Dim db As Database

Dim rs As Recordset

Dim SQLString As String

Set db = OpenDatabase("Path to database")

SQLString = "SELECT customername From customertable Where((phonenumber)=" & Text3.Text & ")"

Set rs = db.OpenRecordset(SQLString)

If rs.BOF = True And rs.EOF = True Then

MsgBox ("Can't find number in database!!")

rs.Close

db.Close

Exit Sub

End If

Text1.Text = rs.Fields("Customername")

End Sub

Is this the right way to get it from the database, or what do I have to change? I'm getting the user type not defined at db As Database. RE: Need ODBC help New to Progress franklin1232 (IS/IT--Management)(OP)23 Dec 02 09:09Dim Db as DAO.Database

Dim RS as DAO.database

If you use DAO the openrecordset method works ADO uses something alittle different. Plus SQL 92 queries are not the same as Jet or Msaccess queries. I suggest getting the SQL92 guide from Progress's website.

There are a number of different dataset types out there. DAO, ADO, and RDO. By not defining the variable as a specfic type you get this error. I would really recommend getting a book or doing some research on these different types each has it's advantages and disadvantage. I will say that ADO is the newer and most recommended way. RE: Need ODBC help New to Progress Bernie5412 (Programmer)4 Mar 03 13:26I'm trying to connect to Progress via VBA ADO and the Merant SQL92 ODBC DSN I setup up. I get an error that says 'cant connect to the db, more info is needed on the connect string'.

Here is my vba code:

Set db = New Connection

db.Open "DSN=pv92SQL997base;owner=base,uid=cnsstaff;pw=****"

Do I need to put a Provider= on the connection string? Anyone know what the it should be for Meriant SQL92? Or is there another parameter I'm missing?

Thanks for the help.

RE: Need ODBC help New to Progress TimDude (IS/IT--Management)6 Mar 03 16:19Quick steps to get ADO/ASP/VB connections working.

REQ: WindowsServer, Progress 9.1C

Note: all of these answers are assuming a Windows Server, however, several ideas will work on other OS's

1. install a full progress installation on server running windows NT4.0Sp5 or Above.

2. make sure you have a progress client network license.

3. your progress server will need to be started to handle both TCP and SQL connections. (see manual/kb for instructions or use Progress Explorer to start/stop the servers)

4. the username that was logged into windows and created the progress DB you wish to connect to is the Main owner of the DB and needs to be used to complete a ADO/ASP ODBC connection. Use this user name in your connection string... see below.

5. since you did the full install you will find the Merant SQL-92 ODBC driver available for a data source. Make a SYSTEM DSN with this driver and enter the DS name, DS Description, hostname, portnumber(port number can be same as TCP port or can be changed in the server command parameters), and database name, leave userid blank.

6. create an .asp file with some sort of data connection information ... such as below...

7. The first time you make a connection to the database there will be a delay of 2-3 seconds.. after that it should fine.

8. Be sure you have enough servers in your server start. or this connection will tie up all your DB ... you will need to use ProMon to disconnect that user.

9. Thats it... the rest is pretty much SQL / VB ...

10. Good Luck....

This took me a bit to get all the steps down... but the above should get you in the right direction. Read subnotes as well.

Thanks and hopefully this will help .... Tim

example.asp code(taken from progress kb with small changes)

'function to get error codes and display

(see kb page for actual code)

'actual db connection string

myDSN = "dsn=mydbname;uid=dbowner;pwd=;"

mySET = "set schema 'pub'"

mySQL = "select * from table "

set conntemp = server.createobject("adodb.connection")

conntemp.open myDSN

conntemp.Execute(mySET)

set rstemp = conntemp.Execute(mySQL) 'put results into record set '

' HERE you would work with your data.

DisplayODBCErrors() 'function from above'

'close db connection

set rstemp = nothing

conntemp.Close

Subnotes:

Page Notes:

1. ALWAYS remember to close your DB connection when you are done with it, and set it to nothing.

SQL Queries:

1. its a good idea to use a "set schema 'pub'" as first command, this will eliminate the "Table/View/Synonym Error" that many have seen.

2. when accessing table names such as 'table.customer-name' its important to have the quotes around the hypened name. such as

"select * from table."customer-name" where "cust-id"='3' "

RE: Need ODBC help New to Progress Bernie5412 (Programmer)6 Mar 03 16:29Thanks , I'll give this a try. I'm doing this all in VB so I'll tr to extropolate from the asp code.

Thanks for the help

Bernie RE: Need ODBC help New to Progress harebrain (MIS)6 Mar 03 19:01In your VB program, add a project reference to "Microsoft ActiveX Data Objects 2.6 Library" (or whatever version of MDAC you have installed.) Then, in the above code, replace the line

set conntemp = server.createobject("adodb.connection")

with

Set conntemp = New Connection

You want to reference the ADO components on the machine your program runs on, rather than across the network on a Web server as you would with ASP.

--David RE: Need ODBC help New to Progress kikigirl (Programmer)30 May 03 14:45I've read in this thread that there is an update to the Merant 3.6 ODBC driver for Progress. I've searched Progress' website as well as Merant. Is there an update, to what version, and where can it be found?

Thanks! RE: Need ODBC help New to Progress Kassad (TechnicalUser)15 Jan 04 17:37Could someone tell me how to obtain the Progress Explorer Tool? I have software that uses a Progress database but the database is installed as part of software and I don't believe that the Explorer Tool is part of it. RE: Need ODBC help New to Progress DrBean (MIS)20 Jan 04 17:57I'm home!

We are running an ERP system from Epicor Vantage on Progress 9.1d, Merant SQL92 etc., Crystal Reports 8.5, ODBC, and ASP. I'm currently reading the years of posts for this thread.

My contributions: CR works great for us, Progress Explorer setup & ODBC connections also works fine. Our ERP implementation has been underway for over a year, a lot of customizing.

I have 5 years experience programming with PASCAL and about a year with ASP/VB/JavaScript. Plus, a knowledge of manufacturing methods

My questions:

1. I get an error trying to delete a record using Progress's SQL Explorer, even though it reads the record fine using the same where statement. Note: one of the fields in the where statement is blank. For more details see dbforums.com thread "Deleting Progress 9.1d ODBC ASP." I may copy the information here.

2. Using MS Access with a linked ODBC table, I blanked out a key field of several rows, but CR and Vantage, both, see my new "blank fields" as different than the "blank fields" created by Vantage. So, selecting by field="" only gives me the Vantage fields, not the MS Access edited fields.

I hope to be able to contribute to everyone's questions. RE: Need ODBC help New to Progress ceesql (Programmer)28 Jul 04 13:44Just finished reading the thread-Wow. We are in the midst of converting a Platinum DB (SQL) to Apprise (Progress V9.1D08). Part of this coversion is having to re-write all Crystal Reports 8.5. The registry has been updated to allow left joins; Using ODBC Merant 3.60 32-bit Progress SQL92 v 9.1D driver.

1)Currently using WinSQL to query tables in the database - is there a way to register the Progress DB in Sql 2000 Enterprise?

2) Notice that report processing is much slower and wonder if this might be caused by the way the tables are linked in the report.

googletag.cmd.push(function() { googletag.display('div-gpt-ad-1406030581151-2'); }); Red Flag This PostPlease let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

CancelRed Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.