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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: hambo12
  • Order by date
  1. hambo12

    Combining two different datasources in one report

    Ok to answer my own question, I have fixed part of the openrowset query, but now the following query does not work: select * from openrowset('Microsoft.Jet.OLEDB.4.0', 'Z:\Stockaid_Data.mdb';'administrator'; '', 'select KillDateTime, KillBodyNo, HotScoreWeight from tblbeastcarcass') as...
  2. hambo12

    Combining two different datasources in one report

    ...SQL reporting services, and it says it doesnt support views? So I try to create a view as follows in SQL Server 2005: create view PIC as select * from openrowset('stockaidnew', 'Dsn=stockaidnew; trusted_connection=Yes;', 'select KillDateTime, KillBodyNo, HotScoreWeight from...
  3. hambo12

    Combining two different datasources in one report

    Hi all, I need to make an urgent report that combines data from two datasources in the one report. I have heard this is not as easy as it sounds. Basically I have the following: one datasource connected via ODBC to an access database: Fields: Date BodyNo Weight another datasource being a...
  4. hambo12

    Printing list of table relationships

    I am trying to find the table relationships for a rather complex access database. I open it up, and can view the table relationships in diagram form. It is a huge mess of tables and relationships. I dont want to go through and move each table to print it in diagram form. So can I print a test...
  5. hambo12

    Matrix - Range of dates

    I have created a matrix that displays some grouped information for a certain date. However, I want it to display the information for a date range. So I want the user to be able to enter the date ranges, and the matrix include all data within those date ranges. Is there any way to do this? I...
  6. hambo12

    Importing Data into SQL DB from IP device

    I have been asked to pull some data from an IP connected device on our network. This device is a dumb device that simply buffers the data, and im not sure where it sends it (if it even does). I need to setup a schedule to import data on a regular basis into an SQL 2005 DB. The main thing I...
  7. hambo12

    converting dates in parameters

    Further to this: I have tried the following in the parameter tab in the dataset: =format(Parameters!Parameter1.Value, "dd/MM/yyyy") However when I try to run the report, I get this: An error occurred during local report processing. The value provided for the report parameter 'Parameter1' is...
  8. hambo12

    converting dates in parameters

    thanks for the help anyway :)
  9. hambo12

    converting dates in parameters

    Im not sure how to use this. I cant run those queries on a progress database, and I have no sql DB to run this against...
  10. hambo12

    converting dates in parameters

    I have managed to get a simple report from a Progress Openedge database connected to SQL reporting services. The report uses an un-named parameter to select the date. However, progress formats their dates as MM/dd/yyyy. SQL reporting services parameter uses dd/MM/yyyy as the format to select...
  11. hambo12

    Staging does not purge when threshold reached

    Hi, I have a backup job set to backup to an FSD first, then to tape each day. However, for some reason now once the FSD reaches its threshold, the backups fail, rather than purging the FSD. I have the following settings: - Arcserve 12 - Staging enabled - Max Threshold 85% - Purge when...
  12. hambo12

    Connecting Progress DB to SQL Report Model

    Ok, big question this one: I want to create a report model project in MS Visual Studio 2005, connecting to a Progress Openedge Database. I can successfully connect to the progress database, and pull some data from SQL Reporting Services. However, when I try to create a report model project, I...
  13. hambo12

    CA ETrust Antivirus 8 - Mass redirect download source

    I want to move the Etrust Threat Management console to a new server. However this will also mean I have to go around to every client PC and manually change the download source for updates to the new server. Is there any way to redirect all clients updates to the new update server?
  14. hambo12

    Lost previous Backup / Restore records

    Dont worry I figured it out. Restored the catalog etc and its all good!! Thanks!
  15. hambo12

    Lost previous Backup / Restore records

    I dont have the "Recover" menu item. I only have Job Scheduler, Diagnostic, Merge, Scan, Compare, Count, Copy, Purge ?
  16. hambo12

    Lost previous Backup / Restore records

    So I was told to move our Arcserve database to an SQL express instance, which I attempted to do. I was then told shortly after to not worry about it. So I attempted to move the database back to the SQL 2005 instance it was orginally on, however I have no records of previous backups / restores...
  17. hambo12

    SQL reporting: Connect ODBC error

    Hi and thanks for the info so far. Below is the connection string I use in SQL reporting services (the same I use to connect via Windows ODBC): Dsn=QAD2008;host=rdadmqad01;port=7110;db=mfglive;uid=SYSPROGRES I have connected through Administrative Tools > ODBC without credentials, however SQL...
  18. hambo12

    SQL reporting: Connect ODBC error

    Hi all, I am having some issues with connecting a progress database to SQL reporting services via ODBC. I can connect to the DB through Windows ODBC. The connection does not use a username or password. This I think is where the problem is. I try to connect to the ODBC connection through SQL...
  19. hambo12

    Group policy - Computer issues

    Strange problem with Group policies not being applied to a computer. I have a GPO for all users, which is applied to everyone in the AD. I have just made another GPO for a single computer to lock it down. I have added the computer to the OU that contains the GPO, and attempted to apply it...
  20. hambo12

    Group policy - Adding emails to safe senders list

    Your right, thanks for that!!

Part and Inventory Search

Back
Top