ueoctudorprice's Q&A profile

• SQL Server Sql Server 2005 and Linked Server

  I am trying to create a linked server to an access database from sql server 2005 (64 bit) on a window 2003 r2 64 bit machine. i get the error message :Cannot create an instance of OLE DB provider "Microsoft.jet.oledb.4.0" for linked server "SSIDB_LO2". The linked server is attached, but it is not using the jet ole db provider, and i also noticed that in the provider list the Microsoft.jet.oledb.4.0 is not listed. i think that is my problem. how do get Microsoft.jet.oledb.4.0 in that list see if that's related to your problem: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=97302&SiteID=1 hope that helps ...Show All

• SQL Server Time intelligence

  I was trying to using the BI wizard and add time intelligence, but when I try to do so, I get an error stating: "One or more dimensions do not have a data source view. The time intelligence wizard can only be run if a data source view is present." Does anyone know how to get around this error Thanks! ...Show All

• SQL Server SSPI handshake failed with error code 0x80090311

  My developers are getting a "Failed to retrieve data for this request error" in SQL Server Management Studio. When I look in the SQL Server logs there are two errors logged: Source Logon Message Error: 17806, Severity: 20, State: 2. Source Logon Message SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed. [CLIENT: IP Address] I can’t seem to find any information about these errors. Any ideas Start here: http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx ...Show All

• Windows Forms DataGridView with CheckBox - I'm stuck

  I finally got thru the GridView populating only to get completely befuddled with this problem. I haven't been able to locate any reference to what I'm attempting so I really need assistance on this. The DataGridView contains 7 columns. Column 0 contains a checkbox and I want to allow the user to check multiple checkboxes and when they click on a control button, the code will loop thru the rows and when a CheckBox.Checked == true, I want to update the data in cells 5 & 6 with the current system date. Sounds simple but I have been wracking my brain on this and it feels like mush right now. This is what I am left with after inserting code and ripping it back out: private void buttonUpdateDues_Click ( object sender , Event ...Show All

• Visual C++ EntAPI.dll', No symbols loaded

  I am new to programming and C++. Using Visual Studio 2005. Build and compile are successvfull.Receive the following after I run my program and enter data that should result in a response. Instead this part of the message that I get. Anyone willing to help a new programmer Not sure what to do 'slope.exe': Loaded 'C:\WINDOWS\system32\EntAPI.dll', No symbols loaded. slope.exe': Loaded 'C:\WINDOWS\system32\netapi32.dll', No symbols loaded. The program '[3172] slope.exe: Native' has exited with code 0 (0x0) What you said has happened is perfectly normal in this case. The no symbols loaded is about debugging symbols. So if you have the IDE set up to load debugging information then it will load ...Show All

• .NET Development TimeSpan data type in DataTable.Select

  Hello, I need to filter a data table based on TimeSpan values in a column Is there any one who could help me on the syntax to use I have tried the following: ColName<='10:00:00'  =>Error : Cannot perform '<=' operation on System.TimeSpan and System.String ColName<=Convert('10:00:00',System.TimeSpan) =>Error : The String '10:00:00' is not a valid TimeSpan value The following works about the syntax but gives wrong results Convert(ColName,System.String)<='10:00:00' So, what is the right expression   Hi! I'm assuming that ColName is variable of type TimeSpan. Now with following statement you can do the comparison which will return bool. ColN ...Show All

• Visual Studio 2008 (Pre-release) UserName authentication

  Hi, I'm trying the sample about 'username authentication'. I have not changed the sources of sample. I receive this error : "An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail." InnerException : "At least one security token in the message could not be validated." Server stack trace: at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.ProcessReply(Message reply, SecurityProtocolCorrelationState correlationState, TimeSpan timeout) at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.Request(Message message, TimeSpan timeout) at System.ServiceModel.Security.S ...Show All

• Visual Studio Team System Accessing Global Lists From Reporting Services

  I have created a global list to populate a new field on our work items. I am creating a custom report using reporting Services to query work items. I want to create a parameter within the report that is populated by the global list to help filter which work items are returned. Are global lists stored in the SQL database so I can automatically populate the report parameter with the available options The values of global lists will be placed in the data warehouse as the values are used by work items. For example, lets say you have a global list that contains "a","b" and "c", and that this list is associated with the field "myNewField". Let's further assume that in ...Show All

• Visual Basic Data transfer from multiples textboxes to temporary listview Or any otherthing(URGENT)

  Hi Experts, I have problem like, In my form i have 3 textboxes in a 3 row , Like this - - - - - - - - - when i press save , I want to transfer all these values into list view , again i will enter some values in these textboxes , i have to append these datas into previews list view. How to do this......... Thanx and Regards Selva.R Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click For Each c As Control In Me . Controls If TypeOf c Is TextBox Then Dim t As TextBox = DirectCast ( c , TextBox ) Me . ListView1 . Items . Add ( t . Text ) End If Next ...Show All

• SQL Server MDX: Percentage-to-totals with subcubes (AW code sample)

  I need to create a calculation that gives me the percentage of a members value relative to the total. My problem is that I cannot make it work when my query is using a subcube in the from clause. The calculated member is simply not able to look outside the defined subcube. In other words - the following query works as expected: WITH MEMBER [Measures].[Test] AS [Measures].[Internet Sales Amount]/( ROOT ([Product]),[Measures].[Internet Sales Amount]), NON_EMPTY_BEHAVIOR = [Measures].[Internet Sales Amount], FORMAT_STRING = "#.##" SELECT {[Measures].[Internet Sales Amount], [Measures].[Test]} ON 0, NON EMPTY [Product].[Subcategory]. MEMBERS ON 1 FROM [Adventure Works] WHERE [Prod ...Show All

• Windows Forms Escaping/Exiting an autocomplete/form

  When using autocomplete, i want to press escape key on the autocomplete to not use it, however escape key is set on the form, i.e. this is the CancelButton property. Is there a way of catching the key event when the user clicks the escape key for the autocomplete on a textbox, so that its possible to determine whether to close the form or to close the autocomplete dropdown Do your processing only if the text box doesnt have focus in the cancelbutton's click: Private Sub Button1_Click_1( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If ( Not TextBox2.Focused) Then ' Proceed with normal processing End If End Sub ...Show All

• SQL Server Temporary Table

  Dear all, I have two store procedures,sp1 and sp2 sp1 : some codes here SELECT * INTO ##A FROM ATABLE sp2 : some codes here SELECT * FROM BTABLE LEFT JOIN ##A ON BTABLE.a= ##A.b I use vb.net to call sp1 first and fill the data to dataset,then call sp2 and fill the data to dataset. So you find that sp2 is left join to ##A. ##A is a result from sp1. If I run sp1 first,sp1 can provide the data to dataset(VB.NET) and sp2. It can improve the perfermance. So I can not use local temporary table #A The problem is : When two or more users run the program at the same time. It give me an error message : ##A is exist at server. My question here : (1) I know ##A is a global variable. but users use differen ...Show All

• Smart Device Development R

  Hi I'm writing my first Device app... I get the following error from seemingly innocuous code: Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%CSIDL_PROGRAM_FILES%\DeviceApplication1\DeviceApplication1.exe'. Error 0x80070020: The process cannot access the file because it is being used by another process. Device Connectivity Component Any suggestions as to what might be wrong Thanks, Bakis. That means your application is already running, so file is in use and can not be overwritten. To fix that please terminate the application via "Memory" applet or restart your device. Remember applications on Windows Mobile are minimized, not close ...Show All

• Visual C# Problem with simple cast

  int getal5 = 25; short getal6 = (int) getal5; Console.WriteLine("Casting van int naar short {0}", getal6); I'm trying to do a simple cast here. Faily new to c# so dunno exactly what i'm doing wrong. I get this error: Error 1 Cannot implicitly convert type 'int' to 'short'. An explicit conversion exists (are you missing a cast ) The second line should be: short getal6 = (short) getal5; You need to cast an int to a sort so the cast is (short). ...Show All

• Visual Basic Fixed: Unexpected exception occurred during upgrade engine operation: Not able to bind to the source

  If you’re receiving this error message: Unexpected exception occurred during upgrade engine operation: Not able to bind to the source (Exception from HRESULT: 0x8004000A (OLE_E_CANT_BINDTOSOURCE) when using the Upgrade Wizard in Visual Basic 2005 please download and install the Visual Studio 2005 SP1. You can find the Service Pack at: http://msdn.microsoft.com/vstudio/support/vs2005sp1/default.aspx We were able to resolve this problem. It seems even after applying SP1 for Visual Basic Express 2005 the problem may still occur. I have not been able to reproduce the problem here so far but the solution that has worked is to add the registry entries for the upgrade ...Show All