cleith's Q&A profile

• SQL Server OPENQUERY and Windows Authentication

  We have a SQL Server and an Oracle Instance. I have been using OPENQUERY to run queries on SQL Server to compare datasets on SQL Server with those in Oracle. Yesterday, I switched from using a SQL Server login to using Windows Authentication. My OPENQUERY returned Msg 7399, "Access Denied". So, I added a new linked server login for my windows username: EXEC sp_addlinkedsrvlogin     @rmtsrvname = 'ORAINST',     @us ...Show All

• Smart Device Development changing label color

  hi there, i was developing an device application. i was trying to change the back color of a label in my device application to web's category color or custom color, but it take no effects. only color under the system category will do is it cannot use color other than the system's color in .net compact framework Please see this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=178752&Sit ...Show All

• SQL Server External columns from Sybase stored procedures

  I need to execute several stored procedures on a Sybase server and copy the results to SQL Server 2005 tables. While using an ad-hoc sql statement the "Available External Columns" list is correct, however when using a stored procedure the list is empty. I've tried to work around this a couple of ways without success. 1) DelayedValidation. I ran the sql from the stored procedure body in the OLE DB Source to set the column list, then turned on Del ...Show All

• .NET Development No connection could be made because the target machine actively refused it

  Trying to connect to a local host TCP port 3380 (the port number chosen arbitrarily): 10.1.10.176:3380 I got this error message: No connection could be made because the target machine actively refused it What shall I do to convince the target machine not to refuse it the next time I used a sock.Connect(serverEndPoint); statement. Thanks HI Guys It's very easy. please first understand, what will to do try. u try send a byte of data s ...Show All

• SQL Server Data Driven Subscription Disabled

  Hi All, We are using SQL Server 2005 enterprise edition for our project with SSRS 2005. We are not getting the Data driven subscription option enabled. That is we see the tab in Report Manager but its disabled. We have ensured the following: 1- The server is enterprise edition with SP1 2- The users are part of local admin group on the report server 3- The report credentials are stored in the database. Is there anything m ...Show All

• .NET Development Transporting a newline character (\r\n) across a web service

  Hi, I had some trouble getting newlines to serialize across web services. I then read that a web service in .NET 2.0 adheres to a certain soap/xml standard wherein each \r\n character is serialized as \n. I've already written a string substitute class that overrides its own serialization and replaces the unix newlines (\n) back to Environment.Newline (\r\n). I was wondering if there is a better (cleaner) way to do this, e.g. some setting or twea ...Show All

• SQL Server Why no aggregation?

  If I put this into one of my table footer field expressions, it brings back the top 1 result of that column: =ReportItems( "ProjFee_AZ" ).Value However, if I put this into the footer expression for the same field later on, it errors out: =SUM(ReportItems( "ProjFee_AZ" ).Value) ERROR: [rsAggregateReportItemInBody] The Value expression for the textbox 'ProjFee_AZ_gt' uses an aggregate function on a report item. Aggregate f ...Show All

• .NET Development Error when opening component containing OleDbDataAdapter

  When I open an existing component containing an OleDbDataAdapter, or when I try to add an OleDbDataAdapter to a component, I receive the following error message. Up til today, this has worked flawlessly. I am using C# in VS.NET 2005 beta 2. Error HRESULT E_FAIL has been returned from a call to a COM component.    at EnvDTE.OutputGroup.get_FileCount() at Microsoft.VisualStudio.Design.VSTypeResolutionService.GetProjectOutputs(Proj ...Show All

• .NET Development Problems linking: wininet

  # define WINVER 0x0400 #include "stdafx.h" #include <windows.h> #include <wininet.h> int main() { HINTERNET hInternetRoot; hInternetRoot = InternetOpen("bmw Agent",INTERNET_OPEN_TYPE_PROXY, "127.0.0.1","<local>",0); return 0; }   I am getting the error: WebAccessCom error LNK2019: unresolved external symbol __imp__InternetOpenA@20 referenced in function _main Any ideas would be helpfu ...Show All

• Visual Studio Team System i want to create a custom rule to check the naming rule of constant..

  this is my custome rule. which check the constant naming. but shows other type of names which is not present in the target file. i think it shows compiler generated code also , so please tell me how to avoid that. send me immediate answer for that. my code is below .. using System; using System.Diagnostics; using System.Reflection; using Microsoft.FxCop.Sdk; using Microsoft.FxCop.Sdk.Introspection; using Microsoft.Cci; using System.Text.Regular ...Show All

• Windows Live Developer Forums What are "Windows Live Messenger Blog Alerts"?

  I have an MSN Space. I found a page where I can sign up for "Windows Live Messenger Blog Alerts". Is this a part of Live Messenger Can you give me a link to the most current info about it In my searches I am only finding Beta information about Live Messenger. Thank you, X The sign-up page for enabling blog/RSS driven alerts is http://signup.alerts.msn.com . It's a service that's freely available for blogs or other RS ...Show All

• Windows Forms Loading a form into a form ?

  Hi, I'm stick with that problem for a while now and I don't know how to proceed. What I'm trying to do is very simple, in fact maybe to simple... I have an application using a main form that contains a menu strip. I want the rest of the form to act as a container to load other forms into it. So when I click a menu item, the appropriate controls fill in the container space (a bit like the tab control but without the tabs). I don ...Show All

• Windows Forms TabControl - Borders

  Hi, I have problems to draw the TabControl borders in a different color. Overriding OnPaint only seems to be specific to the TabStrips but not the control itself. Anybody can help Thanks It's a lot of work but possible. See the tips on my site. http://dotnetrix.co.uk/tabcontrols.html ...Show All

• Visual C# Bind with WindowsIdentity

  Hi, how can I bind to the ActiveDirectory with WindowsIdentity, without requiring username and password again Thanks. I found and expect to have to use the token.. Do anybody of you unmanaged guys know how to bind to the ActiveDirectory (in fact I need to get the Guid) with the login token Thanks... ...Show All

• SQL Server Validate by column name

  Hi, I would like to validate a large file using an IS package before importing it into a table using IS. The Validation rules are stored in the database against each column name Question 1. Is there a way I can get the column names of Input (coming from the file) (So I could check them against the validation table) 2. Can I store these rules in memory, may be using an array if so how do i create an array 3. What would be the best way to go a ...Show All