Oren Solomon's Q&A profile

• SQL Server SQL2005 Set Approle has it changed behaviour

  We are trying to convert our client applications from SQL2000 to SQL2005 back end. We have noticed by trace that when setting implicit transactions on, and calling sp_set_approle in: SQL2000 1) connect 2) Set Approle 3) do stuff which invokes an implicit transaction SQL2005 1) connect 2) implicit transaction is invoked 3) we call set Approle [which fails because it cant be called in transaction]. does anyone know if Sp_set_approle has changed perhaps it now updates a system table which invokes the start of an implicit transaction where previously it did not We have not changed our client code, so this is a change in SQL2005 behaviour or driver incompatibility issue. Also interested to hear if anyone else is suffering issues. ...Show All

• SQL Server convert word doc to pdf

  I have to convert word doc to pdf file use asp net. I think maybe it possible make report in the report services, and then save them in pdf format. but I dont know if I can make report from doc file. and also if I can get the url of the file by query string. Is it possible thanks! Do you have static Word documents that need 1-time conversion, or do you have Word documents that represent report styles or definitions that you want to export to PDF regularly with different data In the first case, I'd say RS is not the right tool. In the second case, I think you'll get good results by designing the report definition from scratch using Report Designer, using the Word documents as prototypes. ...Show All

• SQL Server Connection error : SQL Server does not exist or access denied

  hello , i'm very new to sql server. i'm using sql server 200 & winXP. I have a local server called "JO" and a dsn named "LocalServer". Authentication is sql server authentication & window with username of "cying" and password "admin" i can ping my server "JO" but cannot telnet it's sql_server_tcp_port. this is the error code i obtained when try to open the connection: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. my connection string is as below : set objcon = server.CreateObject("ADODB.Connection") strConnection = "Provider=MSDASQL;Driver={SQL Se ...Show All

• Visual Studio Express Editions clicking a picturebox

  I have about 200 little pictureboxes that start simply white. When they are clicked they turn black. I'm using picture boxes because they are the only thing that can get as small as I need them. I'm hoping for a way that I don't need to re-write the code that many times. I've tried using Private Sub PictureBox1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox1.Click Me .BackColor = Color.Black End Sub But that changes all the picture boxes and textboxes and forms backcolor to black. I'm hoping there is some simple solution that I'm missing. Thanks for any insight. your code snippet is showing that you are setting the back color of the FO ...Show All

• Visual C# Console App: sending a series of commands

  I wonder if anyone can help me in building a console app to run a 3rd party app's console interface I have an application which can be executed from a console interface. Firstly I have to navigate to its parent folder, then I have to enter a command with switches. Something like this: C:\Parent_Folder>ConsApp.exe -a TestFile.doc -b TestOut.doc I've tried building this by implementing the Process class but I'm not having much success, though I atleast think I know where the problem is. My code is as follows: static void Main( string [] args) { ProcessStartInfo startinfo; Process process = null ; string stdoutline; StreamReader stdoutreader; try { startinfo = new ProcessStartInfo (); // use ...Show All

• Visual C++ C++ vs C++/CLI

  Hi, Somewhat of a basic question here. I am working on my first project using C++/CLI, a windows form project. I am trying to follow the ECMA standard. We have an open source piece of code we use across platforms called tinyXml, works fine. It use's STL, and probably would not be considered a C++/CLI program. I believe that STL is not ready for C++/CLI, from what I have read. So, tinyXml compiles and works fine in this project, which I find a bit confusing. I was under the impression that to get code to work properly in C++/CLI you had to follow ECMA. One example that works. Enum's. The standard has something like,( a bit general here ) class enum{ }, but I have added some older code that would look like, enum{ }, and tha ...Show All

• Visual Studio Team System Problem opening Excel Attachments

  I can open all types of work item attachments through the work item form without a problem, except for Excel. When I try to open an Excel attachment I get the following errors: " '<filename>.xls' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding" (I press cancel) "Cannot access 'AttachFileHandler.ashx'" (I press cancel) same as 1. The item finally opens in IE with Excel toolbars A dialog appears with a link to the Microsoft Office Excel File Repair Log showing the following Errors were detected in file 'C:\Documents and Settings\collingridger\Local Settings\Temporary Internet ...Show All

• Windows Live Developer Forums zooming out Virtual earth

  Having a small problem, trying to find a location using the code below function FindLoc() { map.FindLocation(document.getElementById('txtWhere').value, onFoundResults); } function onFoundResults(e) { var results="More than one location was retruned. Please select the location you were looking for:<br>"; for (x=0; x<e.length; x++) { results+="<a href='javascript:map.FindLocation(\""+e[x].ID+"\");'>"+e[x].ID+"</a><br>"; } document.getElementById('resultDiv').innerHTML=results; } when I locate it, it zooms it in far, I do not want it to zoom in. i tried the map.zoomout, but for some reason it will on ...Show All

• .NET Development XSL: sub category 'n' number of loops

  I have a listing of items that can have 'n' number of sub items. How can I loop through each <collection> and all of its sub items and pull out the title of each using XSL I've been stuck on this for awhile. I can use nested loops to pull out each value but thats when I know the upper boundary number of Sub items. Any help would be GREATLY appreciated! Here is the sample XML: <Collection> <Collection> <Collection title="title"></Collection> <Collection title="title"> <Collection title="title></Collection> <Collection title="title> <Collection title="title></Collection> <Collection title="title></Collectio ...Show All

• Visual C# project cannot be started directly!!

  hi all I was searching the net and I found a project and when I tried to run it I gotthe following error: "A project with an Output Type of Class Library cannot be started directly. In order to debug this project, add an executable project to this solution which references the library project . Set the executable project as the startup project." can anyone help me in this issue because I've never used c# bafore Thanks in advanced for help   micvos wrote: You tried to run a dll as a program, which is not possible. You'll have to start the exe. In your solution explorer go to the application that is the main program, click right and choose "set as startup project".   it ...Show All

• Microsoft ISV Community Center Forums On Error not trapping internet connection problem

  I want to add a toolbar button to a Word 2003 VBA project to access a web page. The code below runs fine when my internet connection is open. On Error GoTo notFound ThisDocument.FollowHyperlink _ Address:="http://www.chronolator.co.uk/Tutorials/index.htm", _ NewWindow:=True, AddHistory:=True Exit Function ' problem time notFound: Call showMessage(c8Msg5310) However, if I take my internet connection down, the On Error statement is ignored and I get a runtime error panel. The trap does work if the Address is a non-existent local file rather than an http address. ...Show All

• SQL Server Question to Thread " Usage of Association Rules"

  "If you have a pressing need for this fix, please contact our customer support team." Yes I have a pressing need for this fix, where I have to contact your customer support team. How do I do that You know I only have the evaluation version of SQL Server, but I have to show that this programm is good enough to solve Association Analysis. If I can not show this it wouldn't be bought. Please help me. TNX Answered on other thread - http://support.microsoft.com In this case, contact me at jamiemac "at" microsoft.com ...Show All

• Internet Explorer Development password text field

  hi, does anyone know how to write code to show (*) (star) password instead of (.) DOt password. Is there is way that we can convert to star text for password! i like to have something different. please help thanks. Alidad I think you should be able to change the password character Have a look at http:// msdn2.microsoft.com/en-us/system. windows.forms.textbox.passwordchar(VS.80).aspx ...Show All

• SQL Server Consolidating multiple lookups

  In many of my packages I have to translate an organizational code into a surrogate key. The method for translating is rather convoluted and involves a few lookup tables. (For example, lookup in the OrgKey table. If there is a match, use that key; if not, do a lookup of the first 5 characters in the BUKey table. If there is a match, use that key; if not, do a lookup of the first 2 characters... You get the idea.) Since many of my packages use this same logic, I would like to consolidate it all into one custom transformation. I assume I can do this with a script transform, but then I'd lose all the caching built into the lookup transforms. Should I just bite the bullet, and copy and paste the whole Rube Goldberg contraption of cascading look ...Show All

• .NET Development Accessing a password protected file.

  Hi; Note: While our specific use is ASP.NET, this is a general "reading a file" question. Our ASP.NET application allows a user to give it an XML filename and the app then opens that file as a datasource to generate a report. The issue we face is we do not want the file opened using the credentials of the user that our ASP.NET app is running under for two reasons: The ASP.NET user may not have access to \\hr\payroll\salaries.xml but the person requesting the report does. The ASP.NET does have access to Web.Config but the person requesting the report does not. Our app supports both forms and WindowsIdentity as an authtication/authorization method. So we do not have the client identity to use if they are usin ...Show All