- Windows odbc client for progress databases how to#
- Windows odbc client for progress databases install#
- Windows odbc client for progress databases drivers#
- Windows odbc client for progress databases driver#
Our ERP implementation has been underway for over a year, a lot of customizing. My contributions: CR works great for us, Progress Explorer setup & ODBC connections also works fine. I'm currently reading the years of posts for this thread. We are running an ERP system from Epicor Vantage on Progress 9.1d, Merant SQL92 etc., Crystal Reports 8.5, ODBC, and ASP. RE: Need ODBC help New to Progress Bernie5412 (Programmer) 6 Mar 03 16:29
"select * from table."customer-name" where "cust-id"='3' " when accessing table names such as 'table.customer-name' its important to have the quotes around the hypened name. 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.Ģ.
ALWAYS remember to close your DB connection when you are done with it, and set it to nothing.ġ. Set rstemp = conntemp.Execute(mySQL) 'put results into record set 'ĭisplayODBCErrors() 'function from above'ġ. Set conntemp = server.createobject("nnection") TimĮxample.asp code(taken from progress kb with small changes) but the above should get you in the right direction. This took me a bit to get all the steps down. you will need to use ProMon to disconnect that user.ĩ. or this connection will tie up all your DB. Be sure you have enough servers in your server start. The first time you make a connection to the database there will be a delay of 2-3 seconds. asp file with some sort of data connection information.
Windows odbc client for progress databases driver#
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.Ħ.
Windows odbc client for progress databases install#
since you did the full install you will find the Merant SQL-92 ODBC driver available for a data source. Use this user name in your connection string. 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. (see manual/kb for instructions or use Progress Explorer to start/stop the servers)Ĥ. your progress server will need to be started to handle both TCP and SQL connections. make sure you have a progress client network license.ģ. install a full progress installation on server running windows NT4.0Sp5 or Above.Ģ. Note: all of these answers are assuming a Windows Server, however, several ideas will work on other OS'sġ. Quick steps to get ADO/ASP/VB connections working. Would love to hear from Need ODBC help New to Progress franklin1232 (IS/IT-Management) This is the code that generates the error above:ĭbConn = Server.CreateObject("ADODB.Connection")ĭoesn't matter if it's dsn=syteline5 (system odbc) or filedsn=c:\syteline5.dsn, etc. Is anyone able to give me a working example, a link that has a solution, or some sort of HOPE :)
Windows odbc client for progress databases how to#
I have no idea how to get around this problem.
Windows odbc client for progress databases drivers#
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) When I use any of the hundreds of freely available connection examples, I get the error message: I have also made a fileDSN that will allow me to connect and pull data in Excel, etc. With this I am able to pull data using Microsoft Access, Excel, etc. I created an ODBC connection called Syteline5. It's been awhile since my last post and I am still having problems connecting to the Progress Database via ASP.
0 kommentar(er)
