BSohante's Q&A profile
SQL Server Too many table names in the query sql 2005 merge replication snapshot error
In SQL 2005 I’m able to create a snapshot no problem, when the snapshot runs on the next scheduled date I get the following error. ********************************************** Message: Too many table names in the query. The maximum allowable is 256. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Command Text: sp_MSmakesystableviews Parameters: ...Show All
Visual Basic Saving and retrieving html file
I have a method that returns a report as HTML code in a string... I want to save this string/code into a .html file on a folder in my hard drive. once saved i also want to be able to open it in a browser so I can view the report. thanks try this Dim xmlContent As String = "<html>Hello</html>" My .Computer.FileSystem.WriteAllText( "d:\my.html" , xmlContent, False ) System.Diagnostics.Process.Start( "d:\my.html" ) ...Show All
SQL Server using DTS for reading Dynamic .CSV files from a Folder
Hi All, I have a challenge i am trying to overcome, hopefully soneone would have come across this issue before.. I am creating a DTS package that will be scheduled to run at a certain time everyday. A source folder exists that get a set of new files everyday.The DTS Package will then read each file and copy the data into a load table in my database the challenge is this: I am trying to load files from a source folder into my load table, Within each file, the entires are in a specific format using pipes to seperate the data that goes into which column e.g example of a file entry: column1 | column2 | column3 data1 | data2 | data3 data1 | data2 | data3 data1 | data2 | data3 And now i am using DTS to ...Show All
Windows Forms combobox help
i use a combobox to in my programme to dispay text Me .comboBox1.Items.AddRange( New Object () { "Capacitor" , "Polycapacitor" , "EHT" , "Remote" , "Resistance" , "IC/Transistor" , "Other" }) now i want that user can only selct from above chice & can't type his choice in combobox combobox to work like a list box from which user can chose only from choces but can't write ...Show All
SQL Server DTS to VB
Can someone help me please. I am having issues with the following code. This is the first time I am doing this, so it is Brand new to me. Sorry if I look and sound like an idiot. I am having issues with 'DTS.OleDBProperties' cannot be indexed because it has no default property at the following line :oConnection.ConnectionProperties I used DTS wizard to create my vb code and I am following this page: http://msdn2.microsoft.com/en-us/library/aa176248(SQL.80).aspx Can someone please guide me in the right direction. Option Explicit Public goPackageOld As New DTS.Package Public goPackage As DTS.Package2 Private Sub Main() set goPackage = goPackageOld goPackage.Name = "Test" goPackage.Description = "Casier" ...Show All
Software Development for Windows Vista application compatibility testing
hi, what steps need to be taken care of to completely test an application to be compatible on vista platform thanx in advance divya Hi, I have been following this forum. I need to create an installation for my WPF project for the Vista Logo certification. I was given to understand I cannot depend on Visual Studio - Setup and Deployment solution as it is not fully compatible for the Vista Logo certification. How do I go about in creating the setup using Windows Installer 4.0. Any documentation such as a step by step guide, etc. Regards Markand ...Show All
Commerce Server Commerce Server Order Adapter Endpoint cofiguration programmatically
Hi, Is there a sample on configuring the CS Order adapter programatically in the BizTalk so it can be used configuring the dynamic send port I need to assign send adapter URI and END POINT MESSAGE TYPE = "Order Queries" properties during run time. Thanks, Why not configure an endpoint for each site and use the "Sitename" endpoint configuration property This property is also written and read from the message context, so this is routable in an Orchestration. You can have the orchestration route based on the Sitename context value to the appropriate endpoint. Further, you can use the Send Port endpoint message type to be "From Context" and you can use the ...Show All
Architecture Sending commands to a particular PS2 mouse
(NB I have also posted this to the Gamers forum. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1052249&SiteID=1 Please, to reply: follow this link and reply on that forum. This way all replies will be on the same thread. I don't know which forum is best - there is no obvious choice I can see... Sam) I am building a project which involves connecting many TrackPoints into the computer and collecting pressure data from each. How can I send commands to a particular TrackPoint, and listen for the response A TrackPoint sits on a little circuit board two centimetres by three centimetres. this can be wired in to a PS2 Port. I have three TrackPoints; each goes through a PS2->USB converter into a USB hub ...Show All
Windows Forms PerformClick stopped working
I have the code below that worked for a long time and I made some simple code changes, like adding a msgbox stmt, and now none of my PerformClicks work. Anyone know why Here is the code: Private Sub frm_ARExport_Shown( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Shown MsgBox( "AutoStart=" & AutoStart.ToString) If AutoStart Then MsgBox( "Before btnLogin.PerformClick()" ) 'fires btnLogin.PerformClick() 'does not fire MsgBox( "After btnLogin.PerformClick()" ) 'fires btnDoFile.PerformClick() 'does not fire 'Me.Close() End If End Sub Private Sub btnLogin_Click( ByVal sender As System.Object, ByVal e As Syste ...Show All
Visual Studio Team System How to rebuild the TeamProject based on a specific label?
Hi; How can I rebuild the team project based on a specific label that is attached to all source files by a pervious team build Thanks.... ok.. now I have One Question: if we can rebuild a specific version of the souce files, why we need to keep these files under the build directory thanks.... ...Show All
SQL Server database backup job quits for no apparent reason
I created a maintenance plan to back up a database as a file to another server. Full backup was specified. The job has been running for about 3 months, then quit last night (after the server was rebooted). Error is: Message Executed as user: xxxxx\Administrator. The command line parameters are invalid. The step failed. not sure what to do to fix this - - This is typically caused by the account changing the password. If you change the password of the account you used to run the job, you won't see any problems until you reboot your server/restart SQL Server service as this is the only time that the new security credentials will take effect. ...Show All
Windows Forms Dataview row Filter issue
When we use something like this to filter the dataview we get some error.....what could be the reason... filter=" [FieldName] LIKE 'adfasdfsd*asdfasdfasd%' "; dataview.RowFilter= filter; Could anyone explain the reason why * char is treat in special manner...... it act as a wild character if we simply do filter=" [FieldName] LIKE '*%' "; dataview.RowFilter= filter; it doesnot display entry starting from * , rather it display all the data without any filter applied. Eagerly waiting for the reason..... Thanks in advance... You could do a dummy-replacement first to a char which is not included in the string. See my code below: string chr1 = null; string chr2 = null; string str = "test[]tes ...Show All
Smart Device Development Error attaching to process on Microsoft Device Emulator 2.0 beta with VS 2005
I have a C# app using SqlCe that I can’t always attach to after deploying my solution to the emulator which does imply I can attach sometimes. I can sometimes redeploy multiple times before this issue starts showing and other times I have the issue on first startup of application. I don’t have a real pocket PC yet so don’t know if this reproduces there. And I have not tried this on the 1.0 version of the emulator as of yet. The error I receive is “Unable to attach to the process. Operation not supported. Unknown error: 0xc0000005.” This crashes the process on the emulator. Any advice would be great. Environment: Visual Studio 2005 Pocket PC 2003 SE Emulator Second Edition virtual machine Active sync 4.1 be ...Show All
Game Technologies: DirectX, XNA, XACT, etc. BadImageFormatException for 'Microsoft.Xna.Framework' from fresh Spacewar project
Windows XP 64 Pro. Already had VS 2005 Pro installed. 1) Installed VS C# Express and registered it 2) Installed XNA 3) Installed latest DX SDK (August) 4) Created a Spacewar project 5) Build and run: BadImageFormatException Could not load file or assembly 'Microsoft.Xna.Framework, Version=1.0.0.0, Culture=neutral, PublicKeyToken=f48fa5f25d27e8ff' or one of its dependencies. An attempt was made to load a program with an incorrect format. at Spacewar.Program.Main(String[] args) at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) a ...Show All
Game Technologies: DirectX, XNA, XACT, etc. XNA on Original Xbox?
Back when XNA was first announced at GDC 2004 it was said that XNA would be a unifying environment for both original Xbox(and future versions), PC and mobile devices. With the XNA framework now available for the Xbox 360 are there any plans for supporting the original Xbox I know there are about to be 10 million Xbox 360 consoles shipped by the end of this year, but as of last May Microsoft said they had shipped at least 24 million Xbox consoles worldwide. It seems like it would be a good idea to also target that larger audience that has the original Xbox console, no BTW, I did read the FAQ and found the following entries: Q: Is the XNA Framework available on non-Microsoft platforms A: At this time, the XNA Framework is only avai ...Show All