Search results for query: *

I have a fairly complex union query stored in access (INSERT INTO table etc...) This query runs fine inside Access inserting plenty of rows into my table. However, I want to be able to run the stored query from Excel. Using ADODB and a command object and after much trial and error the code runs...

I am using Office 2007. I have a saved query in Access which runs fine as a stand alone query. However, when I attempt to open the recordset in my Excel VBA procedure I receive an "Invalid SQL ... " error. I have managed to create very simple union queries and get the code to run as a test...

I have a read only version of impromptu, so I can't build reports. I am trying to help someone with the administrator version. (Trying to solve a problem with one arm tied behind my back.) We have a report with a picklist prompt (which includes an 'All' option.) My administrator says "this...

sql server 2005 SSIS Is there a way to script all (or some) database objects with SSIS? This would provide a way to automate the process, rather than using the database task ('generate scripts') thanks for any help. BlueCJH

RS 2005. Currently our report dates format by default in US format. i.e MM/DD/YY To obtain UK formats we have to apply formatting formulae in text boxes etc..., which is a bit cumbersome. I am aware that I can set the XML in the body of the report to English. i.e...

SQL 2005. rsErrorExecutingCommand The stored procedure recides on a separate server from the Reporting Services server. "EXECUTE permission denied on object usp...." (a stored proc) I am Administrator on both. According to the data source, contact is made to the database with windows...

SQL SERVER 2005. (both remote and local) a linked server (OLEDB provider for sql server) exists which uses users current security context. I am sysadm on both boxes. A new database created on the remote server cannot be seen. I get the error "The OLE DB provider "SQLNCLI" for linked server...

sql server 2005, I have a user that seems to have rights shut down, yet still they seem to be able to delete tables in a database. I can only think there is some kind of aliasing going on, how do i get a list of any aliases to the dbo account? thanks for any help? BlueCJH

sql server 2005 GRANT REFERENCES ON TYPE::dbo.myExampletype to aRole but can i grant to all udt's on the database in one command? thanks BlueCJH

sql server 2005: if i give: GRANT CREATE TABLE TO test12 grant insert to test12 grant select to test12 why is user unable to select job_no into mytbl from dbo.job user gets Msg 15247, Level 16, State 4, Line 1 User does not have permission to perform this action. what other rights...

declare @test varchar(1000); set @Test = ''; SELECT @Test = @Test + ',' + c.name FROM syscolumns c INNER JOIN sysobjects O On c.id = o.id WHERE o.id = @@procid select @Test with the above i can get and store @parameter names from a procedure, is there a way to combine the...

Word 2003 vba If i want to set "Error Trapping" to "Break on Unhandled Errors" how do i do this? Don't seem to have the 'setoption' on the application object anymore. many thanks BlueCJH

windows xp user Every few minutes the cursor stops when entering text, as you keep typing the pc starts bleeping as too much text has been typed. Then it catches up with itself. No spectacular software is being run. What could be causing these frequent stall? thanks for any ideas BlueCJH

Help!, I have a one line page: Imports CrystalDecisions.Enterprise Public Class WebForm1 Inherits System.Web.UI.Page Private Sub Page_Load() Dim mySessionMgr As SessionMgr = New SessionMgr End Sub End Class and i get "COM object with CLSID...

visual studio 2003/ BO xi Dim myEnterpriseSession As EnterpriseSession Dim mySessionMgr as SessionMgr mySessionMgr = Serverr.CreateObject("CrystalEnterprise.SessionMgr") i get "Specified cast is not valid." If on the hand i try Dim mySessionMgr As SessionMgr = New SessionMgr it...

XI r 2 I have published an OLAP intelligence report in the CMC, but 'Data Source' test in the CMC fails and report preview fails. Can anyone help? this is my first attempt at publishing and OLAP Intelligence report thanks BlueCJH

BO XI r2. I would like all Infoview users to see a particular Web Intelligence report as their 'initial view'. I know i can set 'my infoview' to a report. But is there a way to enforce this view on all users at 'start up' many thanks. BlueCJH

We have just applied the latest hot fix to BO XI release 2. Now we are unable to view reports through the activex viewer called from asp pages. any ideas tahnks at the following stage in the code the nothing happens?? Response.Redirect("http://" + APS +...

Hope this is the most appropriate forum using BO XI and Business view manager against a SQL Server 2005 Database table. I've added one table to a new Data Foundation attempted to add a parameter on a date field but every time i set the 'Value Field' for the parameter (to this DateTime SQL...

I've received my new motherboard and noticed that the ide ribbons are smaller than my present one. Will it be ok to use the old larger ribbons with this board?, (looks like the colored connector on the new ribbon to the motherboard is the same size as the old one) thanks for your help BlueCJH