Recent content by itsAK

  1. I

    connect error to progress with asp.net

    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...
  2. I

    Latset ODBC driver

    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...
  3. I

    Linked Server

    No problem - Glad you got it working!
  4. I

    Linked Server

    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...
  5. I

    Linked Server

    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...
  6. I

    Linked Server

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

    Linked Server

    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...
  8. I

    Column not found/specified (7520) when column is valid

    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...
  9. I

    Column not found/specified (7520) when column is valid

    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...
  10. I

    Column not found/specified (7520) when column is valid

    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...
  11. I

    Column not found/specified (7520) when column is valid

    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...
  12. I

    Column not found/specified (7520) when column is valid

    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
  13. I

    Column not found/specified (7520) when column is valid

    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...
  14. I

    Latset ODBC driver

    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!
  15. I

    Latset ODBC driver

    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
Top