Search results for query: *

Hi, I am trying to open a remote file to read the header row to establish which columns the file has. The code below works but takes ages with a large file. I have a feeling the whole files contents is being read into memory? Is it possible to read a header row of a remote file without...

Hi, vs2005. how do I convert a string to a string byte array? thanks

hi, It is possible to connect a SQL server 2005 db to an oracle db over the internet and specifically over HTTPS? i.e. is it possible to set up a linked server (or equivalent) between the 2 dbs (not on the same network) to communicate securely over the internet? The remote oracle db would...

Hi there, I am using VS2005 - .NET framework 2. I have 2 textboxes on a form: - txtEmailAddr - txtCustomerNumber I need to be able to validate that either 1 is populated. I can find lots of examples of validating all fields seperately i.e. : <asp:textbox id="txtEmailAddr" runat="server"...

hi, vb.Net 2005. I need to be able to convert an array to an array list. is this possible? If possible, an example would be great. thanks david

Hi, VS.NET 2005 - Visual Basic I have just written my first Webservice and have exposed a couple of funtions/subs using: <WebMethod()> Public Sub Finish(ByVal JobID As Integer, ByVal JobStatus As JobStatus) I would like to expose a class also and its public properties. Is it possible to do...

Hi, Using VB.NET 2005. I am trying to create a sub which loops through each line in a text file and does a string replace on a certain word. The sub also needs to log the line number/s which have changed and write these to a log file. All the examples I have seen so far use the following...

Hello, I have a view created from a Pivot. I am trying to create an index on this view but get the following error: Cannot create index on view 'testview' because the view is not schema bound. It is possible to create an index on view which is created from a pivot? Thanks David Here is...

Hello, I have a sub which I need to be able to pass an exception. Public Sub WriteLog(Optional ByVal Exception As Exception) This Exception needs to be an optional input parameter. Optional parameters require a defualt value. If this is where I am having the problem. I do not know how to...

Hi there, using Access 2003. I am use to using T-SQL (sql server). I am having problems joining 2 tables with 2 conditions in the join. in t-sql the following would work fine: SELECT x,y,z FROM table1 INNER JOIN table2 on (table1.memberid = table2.memberid AND table1.Date =...

SQL Server 2005 I have a text field. (data type text) The field consists of various Name value pairs. I need to extract the value of the "SavedFilterName" pair. i.e. SavedFilterName=STAFF_PCOM%2526%26FilterEntryVars_1=EscapePercent=1%2526SavedFilterName=VIP_CP% The value will always have...

hi, I have a table: TaskID URLID Order Total 1 731951 NULL 100 1 731952 NULL 10 1 731953 NULL 9 2 1 NULL 100 2 2 NULL 10 2 3 NULL 9 I want to update the Order column so that it looks at the total counts and gives a grading by TaskID. so the highest total per taskId would be...

I have a report with 2 sub reports. In the Business Intelligence designer the report runs fine showing the main report and the 2 sub reports, and exports to Excel fine also. BUT when the report is deployed to the report server - the 3rd sub report does not show - "Error: Subreport could not be...

SQL server 2005 SSRS Hi, I have a report - which has one sub group (Site). I am not sure if the report behaved like this before..... The sub totals for the group appears after entry - not at end of group. Is there a setting which puts the sub group total line at the end of the group? Thanks...

SQL server 2005 SSRS Hi, I have a report with 1+ sub reports. I need to schedule this report - and select default parameters values for teh main report and sub reports. When you go into subscriptions - it only allows you to select a value for the main report and not the sub reports. Is there...

Hi, - SQL Server 2005 - SSRS I need to capture and deal with error handling in my report. It seems that some of the formula you would use in Excel - it not recognised in SSRS - i.e. IF(ISERROR(formula,"",formula)) -----> =IIF(ISERROR((XXX.Value/YYY.Value),"",(XXX.Value/YYY.Value)) The...

SQL Server 2005 & SSRS 2005 Hi, another simple question.... How Do you get the detail to above the Groups sub totals? When I use teh wizard to generate a report the sub totals appear above the detail. makes the report hard to read. I can see this makes sense if you drill down into the report...

SQL server 2005 Hi, It is possible to schdule a report to run/execute and export the report to excel, and if so, is it possible to specify a particular directory, which the report can be put? Thanks

Hi, I am using SQL Server 2005 and SSRS. I have a report which has percentage(%) columns. the report also has sub groups. My problem is that the sub total is totalling my Percentages - like a sum. I need the sub total to act as a overall % . I.e. the answer should be 90% not 179%. Emails...

Hi, SQL Server 2000... New to ActiveX (vbscript) and DTS. I am trying to change the values of some of the DataPump properties via ActiveX (vbscript). I have managed this for connections: 'Now set the new values con.Catalog = strToDataMartdb con.DataSource = strToDataMartServer BUT I...