DJ MCFLY - NY's Q&A profile

• SQL Server Passing datetime variable to stored proc as parameter

  Hello, I'm attempting to pass a datetime variable to a stored proc (called via sql task). The variables are set in a previous task where they act as OUTPUT paramters from a stored proc. The variables are set correctly after that task executes. The data type for those parameters is set to DBTIMESTAMP. When I try to exectue a similar task passing those variables as parameters, I get an error: Error: 0xC002F210 at ax_settle, Execute SQL Task: Executing the query "exec = dbo.ax_settle_2 , , ,3,1" failed with the following error: "Invalid character value for cast specification". Possible failure reasons: Problems with ...Show All

• Visual Studio Express Editions Using VB Express with MSDE

  Hi, can i estabilish a connection between vb express and msde I've looked in "Add datasource" but the datasource listbox shows only Access ans SQLClient Files. Thanks a lot, Sammy hi, I guess the SQl connction will establish connection to the instance of your sql including sql express you can also write your connection manualy sqlconnection  http://msdn.microsoft.com/vbasic/reference/data/default.aspx pull=/library/en-us/dnsql90/html/mandataaccess.asp#mandataac_topic5 many databases connection strings  http://www.connectionstrings.com/ hope it was helpfull ...Show All

• Visual Studio Team System well i think

  Hello, As you all probably know, when doing checkout in VSTS, it doesn't perform "get latest" to the files. instead, you work on the local files. I know that this is the way VSTS works and that i can't change it. what i want is to program a policy by my self. the policy will be triggered when someone will do checkout. it will check if he choosed files that aren't latest and if so it will raise "custom form" which i will design. the flow is: 1. a user press check out for files. 2. my costum policy is triggered. 3. the policy check if the file he choosed are  the latest. 4. if latest, it will continue. 5. if not latest it will raise costu ...Show All

• Visual Basic Data menu not available in web service

  Hi I have a web service project, and want to connect to a DB, and return the data from the web service The problem is that the data menu is not available, i know i need to create a data provider, but i cant... what am i doing wrong Regards Greg Phillips this is not really a web services question. our team doesn't own the designer, etc. in visual studio. i am going to move this thread over to the IDE forum. ...Show All

• Visual Basic Identifier

  Public Sub () RaiseEvent Button2.Click(TextBox2.Text & TextBox3.Text) End Sub It says i need a identifier before () on Public Sub (), but im not sure wut i need to do. Can someone post the correct code What is you sub called. What its telling you is that you need to give your sub a name. You cant just leave it blank. How would you then be able to refer to this sub Example Public Sub XYZ() RaiseEvent Button2.Click(TextBox2.Text & TextBox3.Text) End Sub ...Show All

• Visual Studio VSS problem for VS.NET 2003

  H!. For some reasons, I started getting a lot error dialog saying that "The specified procedure could not be found" when I tried to check in or out files in vs.net 2003. Any help is greatly appreciated. Hi, See if this article helps: http://groups.google.com/group/microsoft.public.visual.sourcesafe/browse_thread/thread/d7433001dc2e5a57/4d983482903894d8%234d983482903894d8 sa=X&oi=groupsr&start=0&num=3 Matt says near the end of the page this is due to some broken OLEDB configuration, and his solution was to replace MsDart.dll with a copy from a good machine and to re-register OLEDB dlls. This  ...Show All

• SQL Server Foreach loop with parallel execution

  Is is possible to get the iterations in a foreach loop to run in parallel What I need to do is to spawn an arbitrary number of parallel execution paths that all look exactly the same. The number is equal to the number of input files, which varies from time to time. Any help is appreciated! Regards, Lars Ronnback Code Snippet Imports System.Diagnostics Public Sub Main() ExecuteProcess("dtexec.exe", "SSIS package...") Dts.TaskResult = Dts.Results.Success End Sub Private Function ExecuteProcess(ByVal exe As String, _ Optional ByVal args As String = "") As Stri ...Show All

• Visual Studio Team System error when trying to create a new class diagram

  When I try to add a blank class diagram to either a new or existing project, I get the following error: VSLangProj80.VSLangProjWebReferencesEvents VSLangProj80.VSProjectEvents2.get_VSLangProjWebReferencesEvents() I just installed VS 2005 Team addition for Software Developers after uninstalling the VS2005 Team System Beta 2.  Any ideas on what could be causing this error Thanks,   Scott Mead   Scott, I do not recognize this specific issue, but we often see problems with installing on a machine that has previously had a Beta build installed on it. Some of the Beta builds ma ...Show All

• Visual Studio How to get the build order via an EnvDTE API?

  I have an addin that needs to know the build order as it is listed in the VS Solution|Project Build Order dialog. While analysing the dependencies for the projects is great (and works for projects that have an expressed dependency), I found that the project build order for unrelated projects is fixed (and frequently relied upon by solutions), but as far as I can tell there is no way to figure that order out programatically. The build order as displayed in VS seems to change completely every time I add a new project. To reproduce: 1) Create an empty solution 2) Create a C++ console app project called "a". 3) Create a ...Show All

• Microsoft ISV Community Center Forums Display Metadata of files

  Hi all, i am using the following code to export to a file a folder details - files and sub-folders in a specific folder. i want to export the Metadata of the files as well. any idea how i do it oFile.title, or oFile.comments does not work... thanks, S Dim oFileSystem As Object Dim oFolder As Object Dim oFile As Object Dim oFiles As Object Dim oSubFolder As Object Dim oSubFolders As Object Dim oOutput As Object Public Sub WriteDir(sDirPath As String, ByRef sOutput As String) 'get the folder Set oFolder = oFileSystem.GetFolder(sDirPath) sOutput = sOutput & oFolder.Name & vb ...Show All

• Visual Studio Questions on setting share permission on the VSS database folder

  Dear experts, Just several questions on the share permission setup of VSS database: 1. It is necessary to set the share permission of the VSS database folder to "Change" to to users that needed to check in / check out files, am I right 2. If yes, users may access the files / folders in the VSS database folder by enter the share path in exploerer. (e.g. \\server_name\share_name ) They can even delete or destroy all the VSS database files without security control, am I right 3. If yes, can you please suggest any security control over this case please Thannks. Hi Yes you are correct about the security req ...Show All

• Windows Forms I'm new

  I'm having problems with the Idle event          AddHandler Idle, New LoadEventHandler(AddressOf MyAnimal_Idle) It's saying the MyAnimal_Load is not declared and I'm not sure what to do. Any assitence would be good. P.S. I only have been programming a few months, in .Net and only forms. ...Show All

• Visual Studio Team System Unable to access Team Foundation Source Control

  Hi,    I m using Team Foundation server Beta 3 Refresh and new to this.My project Manager created a Team Project "<TeamProj1> " who is a member of [server]Team Foundation Server administrator Group.He added me as project administrator in ,[TeamProj1] Project administrator group. I m unable to open Sourec conrtol explorer when i double click Source control in Team Explorer, getting follwing error Either source control has not been configured for this team project or you dont have permission access it.Would you like to create create the source control folder, $/<TeamProj1> When i click Yes button getting this ...Show All

• Visual Studio VSS 6.0c and VSS 6.0d

  Hello. I would like to know if there is some reported issue if you work your VSS database with the VSS 6.0C server version and some of your clients have installed the 6.0d version to connect against this server is it fully compatible. thank you Version of the VSS installed on the server does not make any difference in VSS 6.0 VSS is file access based database that does not use any components on the server. The database format has not changed either. It should be fully compatible except for the bugs fixed in this update ...Show All

• Visual Basic Run-time error '429' ActiveX component can't create object

  Hi! I get the error (Run-time error '429' ActiveX component can't create object)  when I execute my VB 6.0 program on Windows server 2003 BUT not on Windows XP Professional. The code that causes error is: Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet) Is there anybody who experienced the same problem What should I do /Saki   I have a tlb component for VB6 that I wrote in VS2008 that displays reporting services reports. When I run the vb6 application in vista, it works fine (this is where I wrote and built the application). Whe I run the VB6 application in windows ...Show All