Search results

  1. A

    Query taking too long to run

    Hi guys, thanks for your quick reply it is the SQL-92 engine we are running. I will try to run an update statistics for the order tables involved in my query on the weekend and see if this improves performance. I was thinking about a temporary table option to run this nightly and then my...
  2. A

    Query taking too long to run

    Hi guys i'm running a query which isn't too complicated but is taking a lot longer than I would expect to run, its suming the value of sales orders (there are over 200,000 in the db) invoiced in the current month I'm not sure if i were to order the where clause of my query differently it would...
  3. A

    Show orders below % margin

    Hi guys , i'm struggling with some of the basics of S92. I'm trying to display all orders below a certain margin in a given month and year. Not sure if i'm missing something in my layout of the calculation thats giving me the syntax error, can anyone see anything glaringly obviously wrong with...
  4. A

    S92 Inner Join

    Hi guys , sorry this one might be a bit simple , tried to avoid Inner Joins in Progress but now I want to try one out can't get the syntax right. Could someone point out my error please Select name From Pub.arsc Inner Join Pub.oeeh on arsc.custno = oeeh.custno where cono = 1 Error I'm...
  5. A

    MS Access Table which links to a progress table

    I had a similar problem , I got round it by having two connections , one for the MS Access database and one for the Progress database. The progress database connection I used the System DSN using the following connection string in ASP Set adoCon = Server.CreateObject("ADODB.Connection")...
  6. A

    Unable to connect to Progress datasource with ASP

    Guys , the problem has been resolved , it was an error on my part , I was trying to connect to a system DSN using the name of a file DSN. We have connectivity and are away !! My thanks for your time in helping me with this Cheers Andy
  7. A

    Unable to connect to Progress datasource with ASP

    Thank you for your reply. Not too sure what you mean , I have a file DSN and system DSN set up on the DC, Terminal Server and File Server, is there any other way to define the ODBC datasource on my DC ? The datasource hostname is the linux server that hosts the progress application, not...
  8. A

    Unable to connect to Progress datasource with ASP

    Hi guys , been using simple ASP to connect to an MS Access database for applications on our company intranet. Our order entry server uses progress, I can connect to this using the ODBC built into MS Access for VB applications etc I've never been able to connect to the live datasourece...
Top