BKewl's Q&A profile

• SQL Server Cannot open database "testDB" requested by the login. The login failed.

  I have created a new database within SQLServer Express 2005 and have an ASP page in IIS. Any time i attempt to access the database I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "testDB" requested by the login. The login failed. The ODBC connection that I have created works fine if connecting to the same table (literally three sample fields with two records) in an Access database. The database connection that I am using is: Set DatabaseConnection = Server.CreateObject("ADODB.Connection") DatabaseConnection.Open "DSN=testDB;UID=EINSTEIN\Administrator&pwd=password;DATABASE=t ...Show All

• Windows Forms Fill Polygon

  I am creating a polygon-like drawing. I am drawing an octogon. 7 sides have a pen color of red. The other has black. How can I fill the polygon or open-space with blue or green or even black Glad you got it working. There are lots of tricks you can use to get exactly what you want. Did you resize pieces of the dra ...Show All

• .NET Development XslTransform.Transform(): Different results on different machines?

  Hi, I have an application which works fine on my development machine.  However, when I used my build on the production machine, I get an Exception. I use code like this to transform a XML string "Text" to its transformed version: XmlDocument oXML = new XmlDocument(); System.IO.StringWriter sw = null ; oXML.LoadXml(Text); XslTransform xslt = new XslTransform(); sw = new System.IO.StringWriter(); xslt.Load(XSLT); xslt.Transform(oXML, null , sw); return sw.ToString(); With the same input string and stylesheet, on my machine, it works fine and on the prodcution machine, it generates an exception. Here ...Show All

• Visual Studio Export E-mail Button and E-mail Prompt DialogBox

  I am using CR XI from inside VS .NET 2003. Is there a way to have a button or file menu option show up on the CrystalReportViewer page Is there a pre-existing prompt dialog to enter the email information like the one you get if you are inside CR (menu: File->Export->Export Report) Thanks, Dave The kbase uses SMTP rather than MAPI. The kbase article works with Visual Studio 2002 or 2003. It does not work with Visual Studio 2005. The Web.Mail namespace has been replaced with SMTPClient. Also addressing is done with the .Add property rather than being set directly to string values. HtH, John ...Show All

• Windows Forms Custom Permission Set

  Anyone have a good link on how to make your own XML file when creating your custom permission set Thanks, Trey Trey - Take a look at the PermissionSet.ToXml method for more information: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemsecuritypermissionsetclasstoxmltopic.asp Hope that helps, -Paul ...Show All

• Visual Studio How to give a signature for a zip file?

  I want to know it because I make a snippet or it will always show a messagebox which ask you click "yes or no" See the blog posting at http://blogs.msdn.com/craigskibo/archive/2005/11/16/493570.aspx . This has information about how to sign a file for the Content Installer. Craig ...Show All

• Visual Studio Why debug now stops on curly brackets?

  Hi, Now in VS 2005 debugging an application we need to do more keystrokes, because the execution is often interrupted on the first curly bracket, stopping before the first breakpoint. Someone knows how to change this behavior on VS 2005 C# Thanks. Washington Moreira I don't think it can be changed. Note this change is completely on the compiler side: the compiler is now emitting a nop for the brackets. You'd need an additional compiler flag. I believe the change was motivated because people wanted to be able to set a breakpoint on the { } brackets and step on the brackets. ...Show All

• SQL Server Access to Cubes from Excel

  I have a developer that I am trying to get connected to an Analysis 2005 cuber from Excel.  He is able to make the original connection, can see the database, etc.  When it tries to fetch the data to the spreadsheet he receives the following err: Initialization of  the data source failed Any ideas   I'm sure I'm missing a simple step. Thanks ...Show All

• Visual Studio Adding a web form to a class library project

  We have been using class library projects for our web application for several reasons. This means we need to be able to add web forms to class library projects, and we used to do this manually in VS 2003 by creating files outside of VS and then just including them in the project. I was expecting to do this and maybe even improving it by creating a template. I have been able to create a template and am able to add a web form to the project using the IDE, but havent been able  to figure out how to make the .aspx and the .aspx.vb files appear as parent/child in the solution explorer. It looks like when I add the files the . ...Show All

• Visual Studio Does VSS 2005 have Netsetup?

  Does VSS 2005 have a netsetup or equivalent I much prefer that installation tool versus toting and inserting a CD at every client box. Mike No, it doesn't, but as Rothariger said, you can install it over the network. VSS2005 doesn't create by default a new database like VSS6 did when you installed from CD, so there is no need for a "netsetup" tool that will just copy and register the binaries. Alin ...Show All

• Visual Studio Visual Studio 2005 Combined Help Collection Broken

  This has been discussed several times and I've still not seen a fix that actually works for it. I've tried everything posted here in the forums, newsgroups and on the web with the same results: The V isual Studio 2005 Combined Help Collection along with SQL Books Online are not available. Pointing Dexplore.exe to here: ms-help://MS.VSCC.v80/dv_vscccommon/local/CollectionManager.htm Shows this at the bottom of the page: Collections available for inclusion in VSCC: Microsoft SQL Server 2005 Mobile Edition I can't remember the list of everything that's supposed to be there but there should be things like: V ...Show All

• .NET Development The Undo operation encountered a context that is different...

  This is not specific enough information for me to know what I did wrong and where. Does anyone have any insight to this It appears to have something to do with asynchronous socket I/O completion. System.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"> <TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier> <Description>Unhandled exception</Description> <AppDomain>PPSManager.vshost.exe</AppDomain> <Exception> ...Show All

• Visual Studio Error whit CrystalReportsSource

  I have a web application that i make in VS.net 2005, and i use a CrystalReportSource. When i publish my application in my IIS, and qhen i go to the page that use that CrystalReportSource it gives an erro, and i don’t understand why. I have one Win 2003 Server, with the framework 2.0, and i have more application that i make working on that server. Maybe i have to install sometihng on my server, but i don’t know what. The error are this: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify ...Show All

• Visual Studio Express Editions Is it possible to use two OLEDB datasources In this Way?

  I am wondering if its possible to do something like what I have in my adaptor= line below (which doesn't work at the moment). All I am really trying to do is come up with a quick and dirty way to pull a few rows out of one database/table and pop them into another database/table: Dim constr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Media\Databases\Configurator.mdb" con = New OleDbConnection(constr) dt = New DataTable() adapter = New OleDbDataAdapter( "Select * into Customers2 from [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Media\Databases\aDifferentDatabase.mdb].Manufacturer_ ...Show All

• Visual Studio Tools for Office How can I call a managed code extensions function from another project?

  I have a Excel Workbook project in Visual Studio with a sub like DoSomeComplexThing(parameters) as code-behind. I wan't to call this function from a windows forms project. In the windows forms project I create and reference a new excel.application, then open the workbook, but then I don't know how to call the function. I wan't to activate a function in my workbook with some parameters supplied by the windows forms app. Is this possible Is there some kind of excelApp.ExcecuteDotNetCodeBehind("DoSomeComplexThing",parameters) or something like that Thanks, Hector Hi Hector, There is no ...Show All