Toinepoep's Q&A profile

• Visual C# SQl server authentication issue in C#

  Hi Guys, I have a tool written in C# which connects to a remote SQl server 2005. Its working fine while I use "Integrated Security". However, I want to login the database using another credential instead of using the currently credentials associated with the tool. The reason for this was because not all the users using this tool have permission to access the database. So, I need sort of impersonation to allow any user using this tool to connect to the database. Is there any simple and efficnet way to do this Thanks. I have checked the configuration of SQL server 2005. Both integrated and SQl server aythentication are enabled by default/ So, I didn't change anything. My question is : ...Show All

• Visual Studio Team System Error: Missing the Unit Test .vsTemplates (wrong folder reference?)

  When I try to create a unit test for a stored procedure, I get a error "Could not find part of the path C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache\VisualBasic\1043\DBUnitTest.zip\DatabaseUnitTest.vstemplate" What I do have is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\ItemTemplatesCache\VisualBasic\1033\DBUnitTest.zip\DatabaseUnitTest.vstemplate", so a 1033 i.s.o. 1043 Due to regional settings Can I change or copy things It helped. I had to log on my system as admin, because I could not copy the folder on Program Files (running in Vista) in my normal context. I only get a Tryst warning, but I can live with this for the time being. Tnx. ...Show All

• .NET Development Write.XML from a DataSet

  Hello XML Gurus, I have what I hope is a relatively simple question; but since it's my first time with it, I'm hoping for a little guidance. I have a DataSet (DataSet1) and I want to write one its tables ("Users") to an XML file (Users.xml). I think I understand how to write the whole dataset (and schema) to the xml file, but how do you do one table Also, when you call write.xml(filename), does it automatically overwrite the contents of the xml file or do I have to do something else in order for that to happen Lastly, when (and how) do you call the TableAdapter.Fill method to fill the new dataset with data Any help would be greatly appreciated! Thanks in advance for any help, Tony http://msdn2.microsoft.c ...Show All

• Windows Forms Autorun Not Working

  Hi, I've published my ClickOnce application and in doing so indicated that I want the setup.exe to start up when the user puts the CD into their PC. Anyway, I've burnt the files to a CD, along with the generated autorun.inf file, but for some reason the autorun doesn't work. Every time I put the CD in the drive, after thinking for a little while, Windows just opens my CD drive's folder, displaying all the files on the CD. It doesn't actually run the setup.exe file. I know it isn't a problem with my PC as any other CD I put in with an autorun.inf works fine. I've even tried my CDs on other PCs to no avail. Any help would be appreciated. Thanks. Here's what my autorun.inf file looks like. [autorun] open=setup.exe icon=icon.ico ...Show All

• .NET Development I need to be able to fill a Date Type field with a null value.

  I need to be able to replace a date field with a Null value if the user has entered a date into that field and it really wasn't suppose to have any info in it. Does anyone have a suggestions as to how to do this It is really starting to frustrate me. Thanks in advance for any help. Try this: .Add( New SqlParameter( "@printDate" , SqlDbType.SmallDateTime)).Value = System.DBNull.Value ...Show All

• SQL Server comparing nvarchar(max) column using like to non-ASCII range

  Our database defines the long_value column as nvarchar(max). I want to find out which rows actually contain non-ASCII characters in that column, but this clause also returns rows with only ASCII characters: where long_value like (N'%[' + nchar(128) + N'-' + nchar(65535) + N']%') What am I doing wrong Kevin Rodgers wrote: Kevin Rodgers wrote: Here is a diagnostic query that suggests to me that the problem has something to do with collations (a topic I had been blissfully ignorant of). If the server's default collation or the database's collation is Latin1_General_BIN2, it returns the expected result; but if the collation is SQL_Latin1_General_CP1_CI_AS, it returns 21,230 Unicode characte ...Show All

• Visual Studio 2008 (Pre-release) WCF Performance: ASP.NET Client

  I'm trying to compare performance of WCF services (recent release) with ASMX webservices in the scenario when service is called from ASPX page, under load (hundreds of concurrent users). Here is the client code in aspx.cs: MyServiceCleint proxy = new MyServiceClient(); proxy.MyTestMethod(); proxy.Close(); MyTestMethod() here doesn't really do anything, just a stub that returns an empty string; WCF security is disabled - so there should be no extra overhead. WCF service is hosted in IIS. It seems like WCF service performs much worse than similar ASMX service - WCF is more than hundred times slower ( !). I have tried different modes/settings such as ConcurrencyMode, InstanceContextMode and Throttling as described here: http:/ ...Show All

• SQL Server Mirroring problem between pcs in different location

  I am facing this problem here. Well , I did setup mirroring in LAN successfully (using certificates). Then I try to implement the same method for WAN. Here's the info : Principal : location A (111.222.333.444,1234:5022) Mirror : location B (444.555.666.777:5022) Witness : location A (111.222.333.444,5678:5022) For the mirror side, I didn't put any firewall settings at all; and both principal n witness , i did open the specific port for mirroring endpoint n sql. However, when I start mirroring , it shows 'The server network address "TCP://444.555.666:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Se ...Show All

• SQL Server Cannot save English dates!

  Hi All, I have this dumb problem with dates in my mobile application. The problem is when saving a short date in English format ex 20/08/2006 the sql server 200 windows CE Edition display an error stating THERE IS AN ERROR IN THE DATEPART FORMAT. [,,,Expression,,] When changing the date in American format the problem is solved ex 08/20/2006 The problem is that I require the dates in English Format only! Is there anyway of solving my problem Thanks Matt Please use parameters to avoid formatting issues. If you don’t know how, please look up SqlCeParameter class on MSDN and/or search this forum. Note: SQL CE 2.0 only supports unnamed parameters, SQL Mobile supports bot ...Show All

• Windows Forms How to make a control transparent

  Hi please tell me how to make a control like panel or label transparent so that it shows an image which is a background of the form that contains the controls thanks in advance Does anyone have this Bob Powell code in VB I can't read c# unfortunately but this is the solution that I am looking for. Any help would be appreciated. ...Show All

• Windows Forms Problem with Clickonce deployment

  Hi!!! I have developed an application using the clickonce deployment... I would want my application to be installed in C:\Program Files\MyApplication folder , using the Clickonce deployment.....How do i set the project properties for deployment..... Plz help me out in this issue....... ...Show All

• .NET Development MS Access

  if set a break point before i open the MS ACess Db it open fine. However if I remove the break point i get this error System.TypeInitializationException was unhandled Message="The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception." Source="System.Transactions" TypeName="System.Transactions.Diagnostics.DiagnosticTrace" StackTrace: at System.Transactions.Transaction.get_Current() at System.Data.Common.ADP.IsSysTxEqualSysEsTransaction() at System.Data.Common.ADP.NeedManualEnlistment() at System.Data.OleDb.OleDbConnection.Open() at icxprotype1.IRunAccess.RunSQL(String sqlstring, String& err, String ConnectionString) in C:\Documents and Settings\Fran ...Show All

• Visual Studio Team System Deployment

  I have a DB project I created by reverse engineering our production DB. VS DBPro is looking great! I have a few questions around deployment of database objects. 1.) I notice that VS DBPro CTP creates one file for each object in my database project (in the "...\Schema Objects\" folder). The extension for each object is .sql. We have already captured all our database objects using the VS.Net 2003 database project file extensions (i.e. .TAB for table, .KCI for ref integrity constraints, .PRC for stored procedure, etc), and we have been versioning these files in VSS for a number of years now. We would like to move to using VS DBPro, but need to know whether VS DBPro will a.) allow scripting at the same granularity (i.e. sep script ...Show All

• SQL Server Snapshot Replication of MOM database

  When configuring snapshot replication of the OnePoint database used by MOM i am having the following error being reported in SQL Replication Monitor: Command attempted: CREATE TABLE "dbo"."Computer"( "idComputer" "uniqueidentifier" ROWGUIDCOL NOT NULL, "Name" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, "Description" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, "CustomData1" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, "CustomData2" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, "Domain" "nvarchar"(100) COLLATE SQL_Latin1_General_CP1_C ...Show All

• .NET Development Synchronising Serial Communication

  I have a questiong regarding Serial Communication. Im trying to set up a communication between a computer and a machine. Sending data is not a problem because the machine has already an algorithm to check and validate the data received. But on my side, I have to develop this algorithm to be sure that I get sensefull information. I receive a byte that tells me an id of the type of operation, then a byte which tells me the number of following bytes of data to receive and two bytes for a special type of checksum. If for some reason I miss one character, my computer can think that one of the data bytes is the size of the data. Then I will read extra bytes as data, that will include operations IDs and size of data from other data packets. ...Show All