Search results for query: *

HI all. I am a little stuck on a peocedure. I'm trying to move files once they have been imported into SQL Server. The first file moves correctly, then I get the above error. I know it's something to do with dispose or close but can't get my head around it. Here is the code so far, the main part...

Hi All, Using SQL 2005. Can anyone give me some pointers in remotely administering a Reporting Services install. I have one site that already has reports running and another that has RS setup but nothing as yet. I have the IP and port setup etc Any pointers would be a great help I have also...

Hi. Please can someone help. VB.net 2008 I have long queries running on an app and while the query is running I'm looking for a progress bar to tick away (on timer event) to let the user know something is happening. Each time the query is run the system processes are blocked and the progress...

Hi, I wonder of someone would know the answer to the following. I have created a system for a company that uses SQL 2005. They want to use reporting services. In the past I have always VPN or RDP to the computer and with Visual studio I have set up the reports and deployed. I wondered if its...

Hi, I have got email data from outlook that return info from a form entered on the web. I'm looking to extract the data and add it to specific fields on the access database. It loooks like this Name: Mr Ian xxx email: ixxx@tiscali.co.uk Address1: xx, xx Address2: xx Town_City: xx...

Dear All, I have two queries (Very much shorten for clarity) which I would love to be able to turn to one. Due to accounting years I have a problem where due to spanning years I cannot seem to use the same logic. If the @StartYear and @EndYear are the same I can use the 'AND' clause. If they are...

Hi, I need to be able to change the properties on a pass through query, in fact a load of them. As you can see, I have the code and all pass through 's get updated correctly. strConnect = "ODBC;DRIVER=SQL Server;SERVER=" & ComputerName & ";DATABASE=RUILS_Temp;Uid=" & strUID & ";Pwd=" & strPWD...

Dear all, I have been asked if its possible to provide a link between Exchange 2003 and/or Sql Server 2005 / Access 2007. We have a database with contact details in (SQL Server) and wanted to update exchange 2003 with these details regular basis. I can use SSIS, Access VBA, VB.net, anything MS...

Hi, Just getting my head around stuff. I have a small vb.net app. I want to be able to add a new tabpage like so; Dim strTitle As String strTitle = InputBox("Please enter the title for the page", General.ConTitle) Me.TabControlMain.TabPages.Add(strTitle) When I close down the...

Hi, I'm looking to change the connection string (To Sql Server) on the fly based on the computer name. Just a normal IF ELSE based on that. I want to leave the connection string settings in app.config if possible. I have looked everywhere to see if I can do this!! I have tried adding a new...

Hi, I have a simple call to an ADO subroutine that refreshes a recordset from SQL SERVER 2005 to my ACCESS 2007 DB. Set cmd = New ADODB.Command cmd.ActiveConnection = gcnn cmd.CommandType = adCmdStoredProc cmd.CommandText = mCommandText Set rstServer = New ADODB.Recordset...

Hi, I have a client who has just had an upgrade to server 2008! Bit quicker than I would do it. Anyway, an excel spreadsheet has some vba included. When its run it get the above error. It stops on the forth line of code each time (Selection.QueryTable.Delete) Here's the full code...any ideas...

Hi, Trying to access an already made mail merge document through Access. I am using the following code. Set objWord = GetObject("C:\DatabaseMailMerge\BBOffer.doc", "word.document") objWord.Application.Visible = True The problem is the dialogue box that comes up saying 'Opening this document...

I am currently moving report manager (not Databases) between servers. Not having much luck. After starting two days ago I'm stuck. I am using SSL (Selfssl) and have managed to connect via the report server, BUT report manager gives the following error; The request failed with HTTP status 401...

Hi..New to SSIS. I have a flat file that has two fields. One is productcode, one is quantity. All I want to do is if productcode = 'GM-Hello-1' then I want to add another line that says 'GM-Hello-2'with a quantity. Its because the two products are in a pack but only one is added to the order...

Hi, I have a in production RS2005 running and we are currently installing Sharepoint 2003. I have been looking around to find out what effect changing the server mode will have. Will my current system continue working? Will a need database be set up? Your help is gratefully recieved :) Scott

Hi, Running RS2005 (was running RS2000 on same system) When trying to run Report Builder I am getting the following error; Report Execution Error The report might not be valid or the server could not process the data. An attempt has been made to use a rendering extension that is not registered...

Hi, I'm new to VS2005. I have uploaded a website to our server, for asp.net, Its been placed in the middle of our old system and we are using an I-frame to reference it in a php site. I have upload it and now want to adjust the page and re-upload the changes. I have seen 'copy website' but this...

Has anyone had problems like this. I recently got SQL Server 2005 Workgroup edition. I did the normal 'read everything I could' to make sure I was getting the correct version for my business. After having to wait 4 weeks to upgrade as we were waiting for our accounting system to be upgraded also...

Has anyone carried out a side by side upgrade. The main problem I see with it is that I would have to create another instance and therefore change all ODBC links within the company and also connection strings via asp sites etc. Anyone used this route??? Many thanks Scott