FrankyLi's Q&A profile

• SQL Server Cannot Register with External Access

  I've done a lot of digging, and I can't find the solution to this one.  I followed Vineet's instructions to get an assembly registered that can call out to Web services; however, when I try to register, I get the following error: CREATE ASSEMBLY for assembly '' failed because assembly '' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.   The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. I tried setting the TRUSTWORTHY option to on, but I still get ...Show All

• Visual C++ VC 2005 preprocessor output is always in ANSI

  I have noticed followings with VS 2005 C++ preprocessor (CL /E /EP /P) behavior. I think previous versions of CL worked differently, and in fact this is a blocker for us to user VS 2005 for our standrd build tool, since our build scripts are written so that they work well with the old behavior. i) CL can recognize that the input source file is in UTF-8 encoding only when you have the UTF-8 BOM at the beginning of the file. Without BOM, it believes the input file is in ANSI even if the file is actually in UTF-8. ii) CL /E /EP /P output data seems to be always in ANSI, even if the input source file is in UTF-8 encoding. I can see " " characters if the source file contain character that cannot be expressed in the output ANSI f ...Show All

• SQL Server Aggregation on monthly base

  I need to create a report containing the headcounts of the employees for each month. The data I can retrieve from the database looks like this: Name StartEmp EndEmp tom 1/jan/05 15/mrt/05 dirk 1/jan/05 31/mrt/06 jan 1/feb/05 NULL In order to get the right information for the report the information should be represented in the following way: January 2005 February 2005 March 2005 "April" 2005 Tom 1 1 0,5 1 Dirk 1 1 1 1 Jan 0 1 1 1 HeadCount 2 3 2,5 3 (there should be more data in the 2nd table but it's a sliced repre ...Show All

• Windows Forms Global variable

  Hi, can anybody say how to add a global variable when I programing in Windows Forms What do you mean exactly You can create a public variable like this; public string myVar; ...Show All

• Visual Studio Adding tigris

  Hi; To add the tigris tasks it says to add: < Import Project = " $(MSBuildExtensionsPath)\MSBuildCommunityTasks\MSBuild.Community.Tasks.Targets " /> Where do I add this I assumed it was a MSBuild task but it's not listed in http://msdn2.microsoft.com/en-us/library/7z253716.aspx so I assume it goes somewhere else. Does anyone know where thanks - dave Dave, Add that to your TFSBuild.proj file anywhere after the following line: < Import Project = " $(MSBuildExtensionsPath)\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets " /> - Steve ...Show All

• SQL Server no luck w/ execute sql task and assigning variable

  Hello, I've asked this question before and I've read the answers before and I still cannot get it to work. My task is simple, I want to use the execute sql task container to grab a value from a database and put it in a variable. I've done all the preliminary stuff such as running profiler to make sure that the package is getting the call to the database, setting up the ResultSet to be "single row" in the general tab, mapped the Result Set correctly, but nothing works. I get the same error every time. This is my sql command: select output_location as output_location from script_master Result Set is set up like this: Result Name: output_location ; Variable Name: User::output_location Here is the error I get: ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Slow Texture2d.fromgfile, post latest xna update

  Hey All. Ive been upgrading an application I built in the pre October release of XNA to the post October XNA release, and so far Ive managed to get everything running fine. However I have a texture2d that im loading from a jpg file via : Texture2d texture = Texture2d.FromFile(filepath); And while this function worked fine and at high speed in the old app in the new app it seems to take 20-30 seconds to complete. For each load. Is there a reason for this I thought I might be using the function at the wrong point (at the moment its called at initialization, and I tried at the load resources function), or perhaps the method has been depreciated. Any help would be great. Cheers You should convert your code to use the content manager as t ...Show All

• .NET Development Asynchronous Receive Method and Threads

  Hello All, I have Asynchronous method to read bytes from the network stream. I wrote below code 2 months ago, now when I come back, I wonder why I used "while(true)" for backgroundWorker. Are there any alternative method to use asynchronous read method with backgorundworker Or the method written below is OK receiveBackgroundWorker.DoWork += new DoWorkEventHandler(Receive); private void Receive(object sender, DoWorkEventArgs e) { while (true) { dataTransfer.Reset(); clientStream.BeginRead(receiveBuffer = new byte[socket.Available], 0, socket.Available, new AsyncCallback (AsyncReceiveDataCallback), clientStream); dataTransfer.WaitOne(); } } private void AsyncReceiveDataCallback ...Show All

• Visual Studio Express Editions DataGrid not updating

  Confused Beginner, I have a form with textboxes collecting information and saving on a database; all is well so far, saves and navigates great, no problem. The problem I’m having is -- I added a button to the BindingNaviagator to bring up a new form/report showing all the data entered on a datagrid, so far so good. The problem come up when I return to the input form and change or add new data, it does not show on the datagrid when I bring it up there after, but if I close the program and reopen, the data shows on the datagrid. I been reading all the message and I gather that I need to clear the datagrid or something. I’ve try some of the suggestion but I have had no success. Not sure where to go from here. Any help ...Show All

• Smart Device Development DLLs and Message Queues

  Hi all, I have a service EXE which creates a window and recieves windows messages from one other exe that I have. Based on the message recieved, it performs necessary operations. I need to convert the service EXE into a service DLL. I am not able to make this work. The findwindow fails in my EXE and I can not find the handle to the DLL where I need to post the messages. The reason I understand is, service DLL is a child window now and findwindow do not find child windows. One more problem is since this DLL makes a window I am not able to see my EXE's main windows also. How to tackle these Any guidance on this would be appreciated. Best regards, Ashish Vyas Hi, Alex, thanks for the rep ...Show All

• SQL Server SQL 2005 Transact-SQL Full Outer Self Join

  Can someone please help me to find out the problem with the following Self Join using Full Outer Join SELECT T1.product, T1.vendor, T2.product, T2.vendor FROM ( product_vendor T1 FULL OUTER JOIN product_vendor T 2 ON T1.vendor = T2.vendor ) WHERE T1 . product = 1 AND T2.product = 2 This query always returns only the matching rows (as if INNER join). Is there a way to get the non-matching rows too, using a single query, without using temp tables If I put the results for Product 1 and Product 2 in two different temp tables and then do a FULL OUTER JOIN on the temp tables, I could get the desired result. I tried putting the WHERE clause condition in the Join, having <> etc., - but, nothing ...Show All

• Windows Forms About sorting in datagridview control

  Hi, I need to disable the sorting facility in datagridview control for all the columns. Is it possible. If its how Thanks Venp VB For Each col As DataGridViewColumn In DataGridView1.Columns col.SortMode = DataGridViewColumnSortMode.NotSortable Next C# foreach (DataGridViewColumn col in dataGridView1.Columns) { col.SortMode = DataGridViewColumnSortMode.NotSortable; } ...Show All

• Windows Forms Can not turn off automatic update

  I made Windows application which manualy checks for updates each time when the application is started. Although I turned off auto updates, I still get sometimes before I launch the application update form which wasn't created by me. My manifest looks like that: ....... <deployment install="true" mapFileExtensions="true"> <deploymentProvider codebase="http://some.url/> </deployment> ....... What do I do wrong Thanks, here is the problem, when you check for update using ClickOnce API, clickonce contacts the server and checks for update (same as if you had <beforeApplicationStartup/> tag). ClickOnce also marks that your application ...Show All

• SQL Server teradata OLE-DB or ODBC

  I have a 32 bit development/playbox SQL 2005 SSIS that can see and run 32 bit OLE DB drivers from Teradata. Granted I have the same issues as others where a table or a view would work and not a query or a variable query. The alternative is to use Linked Server and OPENQUERY. But our real development box is a 64 bit IA 64 using 64 bit SQL 2005. Non of the Teradata.com drivers would work/show up in the dropdown box of the Connection Manager since they are 32 bit. One option is to use the 64 bit Teradata ODBC drivers and then use the .Net ODBC connection instead. Linked server doesn't work either because the SQL 2005 is 64 bit and it is looking for 64 bit drivers. Has anyone have any experience with 64 bit SQL 2005 and Teradata Look ...Show All

• SQL Server Daylight Savings Patch for 2000 Server

  I was wondering if there is a simple patch for 2000 server. It seems that the only fix is to edit the registry and to use the time zone editor app. If there is a simple patch like there is for the 2003 servers i would appreciate it if anyone can show me where. I have about 80+ servers with 2000!!! Much appreciated! Michael, the original poster was trying to patch windows .... Windows Server 2000, not SQL 2000. Yes, not all of us are using Server 2003 on all our hardware. So, I guess is it a manual patch for my Server 2000 machines Any body found a better way Thanks, Vidal ...Show All