Search results

I have my asp.net app to run progress via SQL server as it is much more effiecient. Do you have SQL server available to work with? If so.... Simply set up a linked server to link to your progress DB. Either hve scheduled stored procedures or call them from an asp.net page to import the...

Hello all thanks for all your replies and views. It has been some time since I posted. For the record the first things I checked where the indexes etc on the joins..... The problem was not the ODBC connection but that the query and the sheer size of the bulk of data within the tables were...

No problem - Glad you got it working!

Hi Jason, If your ODBC Connection is set up correct which it is if you can run a test connect then I cant see why it is not working. Try this.... Click properties on your linked server under security make sure the following is ticked. "For a login not defined in the list above...

Here is my succesfull connection string: DSN=name_test;DB=data1;UID=odbc;PWD=odbc1234;HOST=datatest;PORT=23400 Try and run this SELECT statement. SELECT * FROM LINKED_SERVER.."sysprogress"."sysdbauth" From the looks of your error messages I think the linked server is getting past SQL...

Yes I did..... What part are you having trouble with??

Hi all, OK.... I wish to set up a linked server within MS SQL Server 2005 to access my PROGRESS DB for reporting purposes. The Linked Server will allow us to update the tables ect and then run our queries off of SQL Server. Im having trouble in connecting to PROGRESS via SQL Server using...

Hi I have re-written my code to make it more simple to get rid of the damn syntax error! however still no joy!!..... I need help Progress guys!!..... can u see anything wrong that Im doing?? SELECT Table_One.Field_A, Table_One.Field_B, Table_One.Field_C, Table_One.Field_D...

Hi Casper, Yes I had already split the code up..... Im getting the error for the second part of the query: SELECT Table_One.Field_A, Table_One.Field_B, Table_One.Field_C, Table_One.Field_D, Table_One.Field_E ,Table_One.Field_F, Table_One.Field_G, Table_One.Field_H, null, null FROM...

Sorry this is it (missing bracket in the last one!) SELECT Table_One.Field_A, Table_One.Field_B, Table_One.Field_C, Table_One.Field_D, Table_One.Field_E ,Table_One.Field_F, Table_One.Field_G, Table_One.Field_H, Table_Two.Field_I, Table_C.Field_J FROM (PUB.Table_One Table_One INNER JOIN...

Oh yes.... might help ;) SELECT Table_One.Field_A, Table_One.Field_B, Table_One.Field_C, Table_One.Field_D, Table_One.Field_E ,Table_One.Field_F, Table_One.Field_G, Table_One.Field_H, Table_Two.Field_I, Table_C.Field_J FROM (PUB.Table_One Table_One INNER JOIN PUB.Table_Three Table_Three ON...

Hi Casper, No there is no dash in the table name. The tables are as follows: PUB.tp_customer.cust_ID I have ran scripts with my tables like above I have also ran them s follows "PUB"."tp_customer"."cust_ID" Both running without error. Any other thoughts? thanks

Hi all, Im running a query and Im getting the following error Column not found/specified (7520) - However all columns are valid?? I know that 99% of the time this error would be due to having the wrong table/field name down but I have checked and checked my code and all table and field...

Hi and thanks BCM, I was hoping not to go down that road as the plan was to run this query via Crystal Reports ( which does cant access temp tables)... However from the looks of things and from what your saying its not looking good!

Hi guys, After reviewing the code my script still wont execute due to syntax errors. Now taking it that I wrote the script based on my SQL / ORACLE experience Can you PROGRESS guys see anything within the SQL query that wont execute or is compatible within SQL92 PROGRESS DB? Thanks again

Quick update: I have enquired about setting up SP9 on our test environment (a lot of red tape involved) so if it is thought that it will increase SQL92 performance then it will certainly be interesting to see if it helps with this problematic report ;) In the meantime I have started to...

Just a thought (back to my orriginal gut feeling) but could it be the ODBC driver?? Im running PROGRESS V9.D06 Connecting ODBC: MERANT 3.60 32-BIT Progress SQL92 v9.1D Gentlemen I eagerly await your answers! ;)

Hi, Yes the LEFT OUTER JOIN's are nessasry. And all fields in the query are indexed. I have not monitored it with Promon no. And im running this query via Crystal Reports (command) so it does not support 4GL. So bit it the above can u think of anythink Im doing wrong?

Hi guys Im back working on this again. Close to tears at this point! All three tables stats have been updated. All indexe stats for each table have been updated. I ran the following scripts as posted by Casper select * from sysprogress.systblstat (table) select * from...

Thanks again Lee and Casper..... I created a DBA account ect and ran the above script to update the stats to allow for the LEFT OUTER JOIN to run effieciently. update table statistics for pub.table_Name update index statistics for pub.tablex_Name I even ran it to update all tables in the...