Recent content by saroren

This is our startup script for multiple database (two database). 1) The first database need secondary broker 2) The second database just needs 4gl connection Will the below parameter work? Any input will be highly appreciated . proserve db1 -B 653600 -c 350 -L 300000 -n 460 -Mn 101 -Ma 5...

Progress Version Number: 10.1C So far we have been using single database. Now we want to connect to multiple database. I had created the second database and When i connect to multiple database i get the follwing error. ** SETUSERID/USERID functions require one connected db or db argument...

Hi JJames100, Look for these Solution ID in the KB. P33660 - Title: "Error "Database is not started" when connecting to 9.1D databse through SQL-92." ID: P18512 Title: "Cannot make any ODBC or JDBC connection to SQL-92 Database" Go to http://knowledgebase.datadirect.com/ Search...

Its is working for me now. But i dont remember what fixed it. But make sure these are done. We have Progress Database in HP Unix Server. I am using Delphi (from my Windows PC) to connect to Progress Database. 1) create a entry in the service file in unix server /etc/services...

I am trying to get running numbers in Select statment. 1 job1 2 job2 3 job3 4 job4 I tried sql like this select num = (select count(*) from pub.ws_det b where b.ws_nbr <= a.ws_nbr) , a.ws_nbr from pub.ws_det a Also i tried select (select count(*) from pub.ws_det b where...

select tr_nbr , "act-ship" from pub.tr_hist , pub.job where tr_type = 'ISS-SO' and tr_effdate >= '10/01/06 ' and job.workorder like tr_nbr; Above Query gives me syntax error. its because of "and job.workorder like tr_nbr" . Is there any other way to change it. Thanks

Front End - Delphi Backend - Progress Database ODBC - SQL92 I need to find no of items shipped each day. So i am using select count(*), tr_effdate from tr_hist, where tr_type = "ISS-SO" and tr_effdate >= 06/01/06 and tr_effdate <=...

Hi, Thanks Again. I found that i got the ODBC connection which does't use SQL-92. So went i tried to use the DataDirect 4.1 odbc for SQL-92 V9.1e, if give me error "Database not started". (8933) I tried all the solutions from the KB, but still the same error. So right now i...

Hi, When i try the following command sqlexp <Database> -H <LocalHost> -S <Service> I get the error Error: [JDBC Progress Driver]:Database not started. (8933) Please Help!!!! Thanks

Hi, Need help Again !!!!! When i try the following command sqlexp <Database> -H <LocalHost> -S <Service> I get the error Error: [JDBC Progress Driver]:Database not started. (8933) Please Help!!!! Thanks

Thanks Alfiee. Got one more question. Is there any thing i need to do to start the SQL92 I am not able to do a select * from pub.customer ; Please let me know. Thanks

thanks Alfiee, Got the Clinet Networking and now able to connect to the Progress Database from my Client.

Anyone Please Help!!!!! :confused:

Hi, We are using Progress 9.1E Database in HP-UX 11.11 Unix Server. Also the Progress is Installed in HP_UX. We want to use Delphi to Connect to Progress Database from Windows. First i tried to install Merant 3.7 ODBC Driver on my windows side and tried Test Connect via the ODBC Manager...

I don't have Progress in my Client side. I have progress installed in the Server side only. We use Telnet pro to access the Progress Database from the client side. Now we want to use Delphi to connect to Progress Database in the Unix Server. Thanks and Please let me know .