Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Wilciek

    db2 odbc linking from progress to db2

    I am trying to find out how to find the ODBC driver that will allow me to connect to a db2 database on an IBM C3000. Our Progress is running on a SPARC. I would also like to know if anyone could point me in the right direction or to a manual to find out how to read / write to a db2 table using...
  2. Wilciek

    Turn over the crosstab

    I did a similar thing but I used VBA to do it. I've amended the code to fit yours. I should give you the feel for what I was doing. I've called your Crosstab xtab as if it were in spreadsheet format and your new table NewTable. I've named the fields Field_Matt, Column_Letter and Matt_Value...
  3. Wilciek

    How to interogate return codes from stored procedure in SQL

    Sorry - the code that calls the function is as follows -------------------------------------------------------- fnExtractSelection "Product Weightings" fnTransferText Me!RunFolder & "CPWT", "CPWT", "qfrmExtractProductWeightings" 'qfrmExtractProductWeightings' uses the query generated by...
  4. Wilciek

    How to interogate return codes from stored procedure in SQL

    It would be similar to this as I haven't written it yet but I am unsure how to incorporate the return code which I would have to set in the exec statement below- Function fnExtractSelection(stExtractName As String) Dim qdf_mle_Extracts As QueryDef ' Create a QueryDef object to...
  5. Wilciek

    How to interogate return codes from stored procedure in SQL

    I would like to run a pass through query from Access which will Exec a stored procedure (which performs various updates etc to tables) in a SQL baack end. I want to set the return codes for errors after each step in the procedure. I know how to do the first bit but I would like to know is how...
  6. Wilciek

    Report to PDF

    I think you will have to change the registry settings to reflect the fact that you are using CutePDF writer The code below looks as if it's set for adobe __________________________________________________________ SetKeyValue Software\Microsoft\Windows NT\CurrentVersion\Windows", "Device"...
  7. Wilciek

    Connecting to SQL/Server Trusted Connection from ASP

    I don't know anything about asp but I think SQL is looking for a login. Try user0 as 'sa' with password0 as the password you use to login to SQL as the 'sa' I don't know if this will help but it's worth a shot:)

Part and Inventory Search

Back
Top