[Merant 3.60 32-bit Progress Sql92 Odbc Driver 20
Ainoha Sistek
I want to know how do I get Merant 32-bit Progress SQL92 ODBC Driver on my pc. I'm trying to connect progress 9.1D database using ODBC driver. But in my pc, I have no progress odbc driver.
How do I get this driver? Any link?
But if you for some reason prefer Merant you could always try searching Google. FWIW all of the results that I see look like dodgy "freeware" sites that are more likely to infect you with something than provide a working ODBC driver.
I haven't really tried linked server, but I don't think there would be a big issue. The ODBC driver has improved immensely in the last few versions. The ODBC driver usually ships with the client drivers, so it shouldn't be hard to get a hold of.
The main issue, as noted above, is that there is no hard limit on variable charcter lengths, so you could have data in a char(30) field that is 50 characters long. The ODBC driver doesn't like that. There are a couple of utilities that come with Progress that enable you to identify the longest data value you have, and you can change the setting within the Database management tool pretty easily.
Thanks. I'm the SQL Server guy at our company. I will need as much information as I can get in order get (spoon feed) our Progress "dba". I have a method in place driven by SQL Server DTS and linked servers to Progress, but am always looking for a better way that peraps could be done in Proress, pushing data to me. Can you please describe the following step you mentioned in more detail or with a simple example, referring to a table:
The choice of odbc might help. I used to work to for Openlink Software in support, and they did significant business because they had driver that could these. It can on a connection by connection based granularity set the length of the character data brought back, effectively ignoring the reported length.
It can also take the multivalue fields and pivot them to be columns, instead of a list that can also be updated through the driver. They could work with either SQL89 (or Progress native) formats or SQL92, an attempt by Progress to more SQL like, but sacrificing some features.
Hello. I'm using the MERANT 3.60 32-BIT Progress SQL92 v9.1D, I try to connect a Progress DB as a Linked Server in SQL Server 2005, I make the test conection and respond... "The test connection to the linked server succeeded"
I'm a little rusty on progress. Couldn't remember the system user name. It's a quirky DB, and you can get bit by a bunch of things. One of the DB "features" is multi-value fields, which are completely alien to an RDBMS. Also, in some cases the field "size" only deals with the display, and not the data stored. You can have a field defined as 20 chars, and store 50, if you feel like.
Also, once again, be sure this is an SQL92 format table you are going after. Progress can have a different type (SQL89) which is being phased out but is common in prepacked applications built on Progress. If it's SQL89, The driver you are using will not be able to get the data. I can't remember off hand how to tell.
I spent 3 years as Tech Support for an ODBC driver company (Openlinksw). A bunch of their business was replacing the merant/data direct drivers. Openlink had tools that could deal with the fast-and-loose nature of Progress a little. As a product, Progress wasn't bad. As an RDBMS.....a nightmare.
Regards,
Paul Fry
paul...@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...@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!!!
ne...@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.
The Tek-Tips staff will check this out and take appropriate action.