LJ G's Q&A profile

• SQL Server BCP Handling

  Hi, I am executing script like this. How to check for the errors if "master..xp_cmdshell @bcpCommand" fails. Is there any way to verify that BCP is completed successfully DECLARE @FileName varchar(50), @bcpCommand varchar(2000) SET @FileName = 'E:\TestBCPOut.txt' SET @bcpCommand = 'bcp "SELECT * FROM pubs1..authors ORDER BY au_lname" queryout "' SET @bcpCommand = @bcpCommand + @FileName + '" -c -U -P' EXEC master ...Show All

• SQL Server trigger issues

  I am running a trigger on a table (cusomfields) that is to fire when the table is updated or inserted. The trigger takes the new data and moves it to another table called search_products. Search products is made up of 5 columns (product_id, search_terms, name, vendor and keywords). The search_terms column is a combo of the name, vendor and keywords columns. When the trigger fires, the column in the customfields table that updates the keywords ...Show All

• Visual Studio Loading Report data from remote computer

  Hi guys I got a windows application that are on two different servers. The database is on one of the servers. When i open the application on Both Servers they can see the data in the tables. But when I access a report from the app on the one server its gives me a dialog box with a username and password boxes. The reports are stored on the both servers, but the database is on the other. I've set the DataSo ...Show All

• Visual Basic VB.Net 2005 Beta setup/deployment problem

  I am trying to create a vb6 type setup.exe file for a simple VB.net program. I have followed the instructions(add Setup Wizard) from the following site: http://www.vbdotnetheaven.com/Code/Jun2003/2005.asp Now, I did a 'Primary Output...' as instructed, and I rebuilt the Solution. When I check out the Setup directory all that is in there is 'Setup1.vdproj', where is the setup.exe files thanks, Dean Are you ...Show All

• .NET Development Is it possible to load the treeview on demand using xml?

  Hi, I am kind of new to xml and I was wondering if anybody had an example or a small snippet on how to populate a treeview in xml on demand. I played with the treeview quite a lot and in real world scenario you always load the treeview in the beforeExpand event using the node.Tag as your way to find out which node to load. now suppose for example sake i have to construct an xml like this Country City Hotel etc etc How wo ...Show All

• Visual Studio Print function does not work in x64 runtime

  Print button in crystal reports viewer does not work in x64 runtime, when I click on the print, no response and no error, nothing happen. Is this a bug Does anyone else have the same problem Barry, have you had any success with this I am having the same problem and my search for information is futile. I've installed CRRedist2005_X64.msi in addition to the hotfix supplied by Crystal which they claim resolves the ...Show All

• Visual Studio Team System TFS + ASP.NET Web Projects + Satellite Assemblies

  I'm not sure if this is a TFS issue or a VS.NET source control plug-in issue, so please let me know if I've posted this to the wrong forum: I'm seeing an issue with the algorithm that determines whether files in the /bin directory of a web project should be automatically added to source control. In my solution, the web projects only have 'Project Dependencies' (or .NET SDK dependencies). This triggers VS.NET to copy the binaries for the dependen ...Show All

• Windows Forms Parsing a URL

  I need to parse out everything up to the file name from a URL. ie... given: http://myserver/path/filename.ext I would like to retrieve the following: http://myserver/path I tried using the URIBuilder and URI object, however, neither of them want to give me the path&nbs ...Show All

• Visual Studio Express Editions importing ms access data into sql express

  Is there a way to import existing Access data into sql express. I couldn't find an import function. Thanks SQL Express doesn't include Data Transformation Services, which is the tool that supports the Import/Export wizards. You have a couple options... - Use the Export functionality of Access. (File | Export) You'll need to have a DSN created for the database you want to send the data to. - Use the Access Upsi ...Show All

• Visual C# file.exists does not check file on a network

  Hi friends am using VS2005 and C# .i have method which accepts a file path and if its valid it reads text from that file and display it in textbox (am doing this asp.net page). this works fine with files on my machine but when i pass a network drive file path File.exists always return .F. !!! why and how can i read files from a mapped drive Yes my user account has full rights read/write files from those mapped drives . Thanks for ur advice. ...Show All

• SQL Server Accessing the Windows ACL from Transact-SQL

  Hi everybody, I have a dilemna with a project I am developing. I am deploying the project to a Windows Small Business Server 2003 network, so as part of the security I have created a number of database roles (manager, secretary, bookkeeper, facilitator) and linked a Windows Group (DOMAIN\Facilitators, DOMAIN\Secretaries, etc.) to each of these roles. I have found that this model is by far the easiest way to administer access to my ...Show All

• .NET Development SSL on TCP Socket, how in .NET 1.1?

  Is there a way, using intrinsic .NET framework functionality, to open a TCP connection over an SSL channel   I'd rather not get into buying libraries, etc.  Java has the javax.net.ssl.* objects, and I'm not finding an equivalent in .NET. I looked all over the Internet, but nowhere a pointer/solution can be found. Please note this is a socket connection, not an HTTPS connection. Also, it's about .NET version 1.1. Any hints/tips/rem ...Show All

• SQL Server Using MS Access 2003 Project with SQL Server 2005

  I continue to receive an error that states "The version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your Access project is connected to. See the Microsoft update website for the latest information." I'm using Access 2003 that I ran a database through the Upzinging Wizard with a copy of SQL Server 2005. I have searched the Office Update pages and can't locate anything that helps, alt ...Show All

• .NET Development Can a dll built in vs2005 .NET 2.0 be used within vs2003 .NET 1.1

  will vs2003 .NET 1.1 be able to use a dll built in vs2005 .NET 2.0 Cheers, Craig I've tried once to create a 2.0 assembly which I tried to use from a 1.1 project. I tried to use the configuration settings described in the document you mention James. Finally, there was no way I could add a reference of the 2.0 assembly to the 1.1 project. VS2003 kept throwing an exception. ...Show All

• SQL Server Errors processing SSAS 2005 Cube against SQL 2000 database

  Hi, I am receiving the following erros when i try to deploy/process my cube. The source db is Sql Server 2000, could this be the issue I have a connection created (have tried both OLDB providers - SQL Native client and MS OLDB provider) and I am supplying a sql server user name and pass word (datareader permission in db). The 2005 SSAS service is running under a local user account so authentication is not possible using that account. And I ...Show All