Quick 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' "