Paul MF's Q&A profile

• .NET Development SqlCommand calling stored procedure with temporary table problem

  Hi there, Env. VS2005 professional, SQL2005 Developer Edition. I have a problem on calling a stored procedure that uses a temporary table through SqlConnection and SqlCommand component added on a form. After enabling these components to appear on the toolbox (I am converting a VS2003 application), I put these components on the form, setting all parameters to connect to the db and calling the procedure. When the sistem ask me if I want to regenerate parameters and confirming it, I get the error message: 'Invalid object: #Rows'. What is wrong or what is changed from VS2003 Below the table definition and the SP you can use ...Show All

• Windows Forms Tiling children in MDI Parent space

  Hi!   I want to position child windows in a specified location on load - and I want to tile windows on demand; I also need to retain the original size of one of the child windows, and tile the remaining to the right of that.    In VS6, I would set the .Top and .Left properties of the form; in .Net, that doesn't seem t ...Show All

• Visual Studio Express Editions Treeview question #4

  Hi Back again. This question is typed boolean :) I had problems when I click on the last node of a branch in treeview. This would invariably cause an 'Object reference not set to an instance of an object.' error. To solve this, I wrapped the offending code in an 'Try...Catch exception' = No more of those errors. Question: Is doing this a 'cop out' If answer = True then why I had tried a number of other 'traps' to avoid the offending code being executed, but all those attempts were trying to use aspects of the same variable(s) etc which also caused exceptions. Having your code in a try catch block is always a good idea ...Show All

• SQL Server enforcing password complexity in sql server 2000

  Hi all, Are there any built-ins, utilities, ... within sql server 2000 that can be used to enforce password complexity in the database. i.e at least 8 characteres, upper and lowercase mix, includes at least on number and one punctuation (underscore,...). I understand that this requirement can be achieved using windows authentication. Unfortunately we do not have that luxury (at the moment). tx. There is no builtin support in SQL Server 2000 for enforcing password policy on SQL logins. SQL Server 2005 offers these features if it is installed on Windows 2003. The free Express edition includes this fe ...Show All

• .NET Development timeout when using ftp over SSL

  Using the example at http://msdn2.microsoft.com/en-us/library/system.net.ftpwebrequest.enablessl.aspx I am attempting to connect to an FTP server over SSL.  I can change the EnableSSL flag to false and connect to a non-SSL server with no problem.  But when I try to connect to my SSL server with the EnableSSL file set to true I get a timeout message when the GetResponse mothod is called. I did a trace of the connection and everything seems to work ok, through the authentication process, where the user name and password are passed.  This portion of the trace picks up at that point: - - - - - - - - - - - - - ...Show All

• Visual C++ CHTMLView bug with IE7 beta 2

  I am using Visual Dev 2003 with a CHTMLView derived Class as part of a larger application. The content pages have HTML wrappers with Flash content. It's been working fine with IE 5 & 6, but after installing IE 7 beta 2, I get the equivalent of "cannot display web page" on the first clicking of an internal or external link after timing out. When I return to the previous page and click the link a second time, it works! Anybody else run into this, any suggested fixes Would there be a better place on MSDN to pose this question I think this is same as http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx feedbacki ...Show All

• Visual Studio Model Query Capabilities

  What capabilities will exist for querying a model, for example, "find me all object of this type that have the following attribute setting" Note that by V1 we expect to have a a strongly typed API on relationships, as well as classes, so the code to do some of these navigations will be a lot cleaner. Speculating beyond V1, I can imagine that the LINQ technology announced at the PDC would make a pretty nice query mechanism over DSL models. ...Show All

• SQL Server Replication failed after restore

  Hi everybody, I have the following replication setup. SrvA - SQL2000 Publisher and Distributor for Snapshot and Transactional one way replications SvrB and SrvC - SQL2005 - Subscribers. All are pull subscriptions. Worked fine until I had to move one  subscription database from server B to Server C. I did it through backup/restore procedure. Now subscription does not show up under subscriptions folder in managment studio and I cannot create new subscription getting error "subscription already exists". When I tried to run existing SQL Agent distribution job - it failed with error "Agent message code 20084. The process could not connect t ...Show All

• SQL Server Report Model Against MSAS cubes

  Hi! Could anyone give me a detailed description of how to create a report model against an analysis services cube Thanks in advance! http://msdn2.microsoft.com/en-us/library/ms345292.aspx ...Show All

• Visual Basic Connection Strings

  After reading through the issues on ConnectionSettings I have decided that whoever or the group that decided that the developed and deployed database will be in exactly the same place as in the developement environment hasn't a clue to the real world. The person or group should rapidly be removed from the gene pool before any futher damage is done. Sorry for this attitude, but what possible reason could there be to not have the ODBC app look to the ODBC Name to get a clue as to where to look for the database. This is absolutly absurd. Max Guernsey Rio Rancho, NM Well, that didn't work. I change the con ...Show All

• Visual C++ 2 dimentional arrays...

  Hi all, I need to do this: 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 Any idea Here is my code so far: #include<stdio.h> void main () { int n=5; int m=5; int arr[5][5]={0}; for (n=0;n<5;n++) { for (m=0;m<5;m++) { printf ("%d ",arr [m]); } printf ("\n"); } printf ("\n"); printf ("\n"); for (n=0;n<5;n++) { for (m=0;m<5;m++) { printf ("%d ",arr[ ][ ]); } printf ("\n"); } } Why use arrays int main() { for ( int x = 1; x <= 16; x <<= 1 ) { printf( "%d %d %d %d ...Show All

• Visual C++ HELP! - Converting Data Type and Writing File Problem

  I want ot open a file, getting the username from a label, and write to it. Simple No. It always errors whaever I do. I have looked at the documentation but that provides no answers. This code: FILE *stream; errno_t err; err = fopen_s( &stream, label5->Text, "w" ); fclose(stream); but it errors: error C2664: 'fopen_s' : cannot convert parameter 2 from 'System::Windows::Forms::Label ^' to 'const char *' No user-defined-conversion operator available, or Cannot convert a managed type to an unmanaged type How do I stop this And the, I have no idea how to write to the opened file. How do I do that Please help me! Hiya. Than ...Show All

• Visual J# Does Visual J# supports Browser Helper Objects(BHO)

  Hi In our web application we want to access frames in HTA.But some reason ,HTA doesn t seems to load the application.So now we trying for BHO in VJ#.But we don t have a clear idea ,whether it is supported by vj# or not.If any body have idea in it ,revert with some examples. thanks praveen Hi Praveen, BHO is supported in VJ#. I have done a small example. Create a new VJ# classlibrary project named sample.Add reference to the folllowing dlls from visual studio IDE. C:\Program Files\Microsoft.NET\Primary Interop Assemblies\Microsoft.mshtml.dll C:\Windows\System32\shdocvw.dll copy t ...Show All

• SQL Server Programmatic generation of History snapshots with varying parameters

  When you call CreateReportHistorySnapshot it generates a snapshot of the specified report with only the default parameter values. How would I generate snapshots based on parameters specified at runtime I've done this before using a Linked Report. If you first call CreateLinkedReport() you can pass in the properties for the Report. Then Create a Snapshot of that. If that is not enough to get you going let me know I'll see if I can dig up the code. Dave ...Show All

• Windows Forms Use one app.config setting - deploy another?

  Hi, I'm trying to use Click-once-deploy. My app.config file has a setting called FileServer - like this: < appSettings >     < add key = " FileServer " value = " MyPc " / > </ appSettings > When deployed, I would like it to be... < appSettings >     < add key = " FileServer " value = " MyServer " / > </ appSettings > Is this possible to have one "test" setting and when deployed, have another setting Thanks, M O J O Thank you... I thought I was going mad I had used the override feature in 2003 to have a development app.config ...Show All