1hhChip's Q&A profile

• Visual C++ The system cannot execute the specified program.

  I wrote a handy dandy tool in Microsoft VC 8.0 on a 32-bit developement machine, but when I tried to put the executable onto the 64-bit server it gives me the error message "The system cannot execute the specified program." I know that 32-bit programs can run on a 64-bit machine, because on another machine I was able to make the program work (but that machine had SQL and a couple of other programs installed). Any ideas on what is going wrong here I understand that there is probably an issue with the manafest, but the manafest is contained within the executable, and any attempt to change the manifest causes the executable to be corrupted. I would assume that the only Issue that I have is that the C Runtime is not in ...Show All

• SQL Server BIDS - Error on design surface of Calculation tab in Cube

  Has anyone seen this Within 'Business Intelligence Development Studio' (BIDS) with a cube opened and the calculations tab selected, the design surface displays a message that reads: Unexpected error occurred: 'Error in the application.' This occurs in any project I open and it still occurs when I restart BIDS or the computer itself. Any ideas Can anyone suggest a remedy hello, here is what i would try: - save out old files that you will replace (possibly rename just as you suggested), so that you can get back to original state if needed. - copy both dlls from C:\Program Files\Common Files\System\Ole DB\ to the other folders (PrivateAssemblies, IDE) start new BIDS an ...Show All

• SQL Server US Date Format in Calender Parameter (SRS2005)

  Hi this is driving me completely mad. UK based so we want the calendar parameter to display the date format as dd/MM/yyyy rather than MM/dd/YYYY. I'm using SQL RS 2005 on a Windows 2003 sp1 box. I've used regedit to look at all the user account international settings, all of which are set to UK. If i log on to the box and run the report the server the date format in the calendar parameter display correctly. Same account on annother machine displays it in the US format. I've also checked my regional settings on the other machine and it shows UK. Where else is it going to pick up the US format from Ok I thought that solved the issue, but after rebooting the server there is no change in the way the report ...Show All

• SQL Server Transfering data from Access Databse to Sqlserver

  I need to connect an already exeisting Access database to the Sql Database or you can say I need to import data in to sql I havent used access much if any body can help me with that, that will be really great That depends if the data is only imported once or on a regular basis. So you either use the import wizard Create a linked server Use the Opendatasource method (in TSQL) Create a Integration Services package. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Unlock account from Management Studio does not work!

  Hi, I recognized that I cannot unlock an locked account with Managament Studio for SQL Server 2005 SP1 (Login properties). I need to use 'ALTER LOGIN'-command from a query window. I found old forum entries mentioned the same problem. Is there a time frame to fix this problem Maybe in SP2 or SP3 Wolfgang Kunk Hi, When I use the Management Studio to lock/unlock an account it seems to work. I performed the following steps: create a new SQL Server account via \Security\Logins\New Login disable the acocunt via \Properties\Status\Login: Disabled enable the account via \Properties\Status\Login: Enabled Tried to login and it worked. Greetz, Geert Geert Verhoeven Consultant @ A ...Show All

• .NET Development Create lookup

  How does one create a lookup at runtime Please see my code below: Dim dsNames As New DataSet Dim userAdpt As New OleDbDataAdapter( "SELECT * FROM [User]" , DBCon) Try DBCon.ConnectionString = csWBoard DBCon.Open() userAdpt.SelectCommand = New OleDbCommand( "SELECT userID,fullName FROM [User]" ) userAdpt.Fill(dsNames, "User" ) cmbFind.DataSource = dsNames cmbFind.DisplayMember = dsNames.Tables( "User" ).Columns( "fullName" ).ToString cmbFind.ValueMember = dsNames.Tables( "User" ).Columns( "userID" ).ToString cmbFind.SelectedValue = dsNames.Tables( "Booking" ).Columns( "userID" ).ToString DBCon.Close() DBCon.Dispose() Catch ex As Exception MsgBox(ex.Message) End Try ...Show All

• Visual Basic Null Reference Exception

  I am having a problem with a multi-form application I am writing in VB .Net 2003. When I transition back from one form to my startup form, I get an intermittent Null Reference Exception. Sometimes it will work, moving back and forth from form to form with no problems for 15-20 minutes, and sometimes it will crash everytime. I have tried putting a try-catch block around the instantiation of the main form. It does not catch anything. The exception points to line 2 of the startup form, which reads: Public Class frmWelcome Not much to cause a problem there, I would have thought. I am attaching the code for bringing up the welcome screen in hopes that someone will see something I am not thinking of. Try Dim welcome As New frm ...Show All

• Visual Studio Tools for Office URI Formats are Not Supported

  Software:  VSTO SE, Visual Studio.NET 2005 Solution Platform:  MS Word 2003 Template I'm using the following code to open the SaveAs dialog with file name created in prompt, and set to the path of a common web folder.  However, the error I get back says that "URI Formats are Not Supported".  Please advise as to how I can edit this code for the save to web folder. Thank you, for any assistance you can provide. sample code: Private Sub FileSaveWebFolderWithNamingProtocal() Dim eRom as string eRom = " http://www.eromaddress.org/erom/foldername/subfoldername/ " ChDir(eRom) With Application.FileDialog(Microsoft.Office.Core.MsoFileDialogType.msoFileDialogSaveAs) .InitialFileName = varia ...Show All

• SQL Server Key Maintenance and Stored Procedures

  Basically I would like to ask whether parameters can be used to pass the value of the 'symmetric key id', 'certificate' and optionally 'password' to a stored procedure that uses encryption functions. The reason this is appealing is that when encryption keys etc change over time (we have a requirement to decrypt data, destroy and create new keys, then encrypt data every time we lose a staff - don't ask), as we would be passing the value of keys, passwords and certificates as parameters to a standard stored procedure. Hardcoded Example (Working) USE PSS GO CREATE PROC insert_payer_ba -- define parameters @param_rec_id NVARCHAR ( MAX ), @param_bsb NVARCHAR ( MAX ), @param_account NVARCHAR ( MAX ), ...Show All

• Visual C# NEW ROW IN DATAGRID

  How can i create a New row in datagrid..... Can i Use datagrid in javascript.How to handle Datgrid properties through Javascript. Waiting for ur repliess........... With regards, Mahender hi, datagrid is just a UI to draw the data which stored in your datasource, so insert row in the datasource and the datagrid will show it, if this datagrid is web control you better use this forum http://forums.asp.net hope this helps ...Show All

• Microsoft ISV Community Center Forums build a matrix

  Hi all, I would like to create a 2x4 matrix but I can't make it work. This is how I like the matrix to be [LHS_X, ForceX, DispX, StiffX LHS_Z, ForceZ, DispZ, StiffZ] The first value on every row is a string (LHS_X and LHS_Z). The rest(Force, Disp and Stiff) is each a single value. How should I declare the Array to get this function I would also later need a similar matrix but then will the Force Disp and Stiff be arrays. How will this differ from the first one Grateful for help \Jonas ...Show All

• SQL Server custom handler replication error

  hi we're having a very weird problem, we are developing a outlook addin using VSTO, in order to replicate data we are using a merge replication with a Merge Pull Subscription between SQL server 2005 and SQL express 2005, from that subscription we obtain the MergeSynchronizationAgent specifying the following properties: syncAgent = mergePullSub.SynchronizationAgent; syncAgent.ExchangeType = MergeExchangeType.Bidirectional; syncAgent.DistributorSecurityMode = SecurityMode.Integrated; syncAgent.PublisherSecurityMode = SecurityMode.Integrated; syncAgent.SubscriberSecurityMode = SecurityMode.Integrated; syncAgent.SubscriptionType = SubscriptionOption.Pull; BTW, the publication has a custom conflict Handler registered in the GAC, this clas ...Show All

• Visual Studio A data source instance has not been supplied for the data source 'DataSet1_Clientes'.

  Hello i'm cuban and i'm doing an aplication in Visual Studio 2005. I have a problem with this code because i have an error. I want dinamically load differents reports in one page usin the reportviewer control. This is my code. please help me and tell me what's wrong here. This code i'ts for a test Protected Sub Page_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load Me .ReportViewer1.ProcessingMode = ProcessingMode.Local Me .ReportViewer1.LocalReport.ReportPath = "C:\Inetpub\wwwroot\pepe1\report1.rdlc" Me .ReportViewer1.LocalReport.DataSources.Add( New ReportDataSource( "clientes" , cargar())) Me .ReportViewer1.LocalReport.Refresh() End Sub ...Show All

• Visual Studio Express Editions Show URL title in title bar

  Private Sub WebBrowser1_DocumentTitleChanged( ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentTitleChanged this.Text = "Farscape Navigator - " + this.theWebBrowserControl.Document.Title ; End Sub I can not get it to show the page title in the title bar. I want to display the Web pages title in the title bar. Don't paste C code into a VB program! Try: Public Class Form1 Private Sub WebBrowser1_DocumentTitleChanged1( ByVal sender As Object , _ ByVal e As System.EventArgs) Handles WebBrowser1.DocumentTitleChanged Me .Text = "Farscape Navigato ...Show All

• SQL Server Trace Flag 9059 gone in SQL Server 2005

  Does anyone know if the behavior in SP4 which was disabled with the Trace Flag of 9059, has been made permanent in Sql 2005 We have a vendor app. that required us to turn on TF9059 after upgrading to SP4, so we are wondering, since TF is not in any Sql2005 doc, if moving the app to Sql2005 will cause the same performance issue the app had in SP4 when the TF9059 was not enabled. thanks oj, thanks for responding but maybe I wasn't specific enough. does tf9059 exist in sql2k5 I don't see it listed in the trace flag portion of the documentation. ...Show All