Search results for query: *

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

hmmm, a view... So where do I create this view? I try to create it in 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;'...

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

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

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

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

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

thanks for the help anyway :)

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

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

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

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

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?

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

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

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

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

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

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

Your right, thanks for that!!