Search results for query: *

using the June 2005 edition of the Ent Lib. I can serialize a SqlParameterCollection using ConfigurationManager.WriteConfiguration() but GetConfiguration() does not seem to be able to deserialize that same ParameterCollection. The TestConfiguration.config file looks perfect... I actually said...

petrosky, I have the pop and smtp settings correct. When I am not using the library's proxy address, I can send and receive fine. Is it possible that the library is somehow blocking pop and smtp. This is the Louisville Public library's free wifi service. Network administration is a black...

...using Office 2K, IE6 and proxy server, AVG (disabled email plugin) At home, via cable modem, I have no problem using outlook, ie, firefox, whatever. But whenever I connect via the free wifi at the public library outlook reports Unable to connect to the server(account:myemail@gmail.com...

...using EntLib Jun 2005, VS 2003 I am new to c# and dotnet (3 weeks and learning like a fast) and am receiving this error while using the Enterprise Library Data Access Block at this line of code. Database db = DatabaseFactory.CreateDatabase("SomeDB"); An unhandled exception of type...

using VS.NET 2003 Enterprise Ed. and MSDE 2K I am very new to .net programming (about 3 wks) and was under the impression that I could manage sql server from within VS.NET All I see that I can do visually is to create DB, Tables and Queries. What about DTS, Backup Schedules, Logins, etc. I...

Nevermind... I answered my own question by actually writing the try catch block and pressing F5 Thanks anyway

...new to c#/dotnet using try catch is it possible to have my code continue at the next statement (kinda like vbscript's ON ERROR RESUME NEXT)? Thanks

I have noticed that nobody uses SET NOCOUNT OFF after turning it on.. even the VS SP Template does not include it. Why not?

using Outlook 2003... In GroupWise you can have the system notify you when someone opens or deletes a message. This does not require their involvement. With Outlook 2003, I see that requesting a read or open notification requires that the user agree. How do I duplicate the GW feature in...

Using SQL SERVER 2K the following is the meat-n-potatoes of an sp. It generates an error because there are related child tables that the DELETE would leave orphaned, but my output parameter is never filled with any message and the RETURN value is 0. What am I not understanding here...

using SQL SERVER 2K I was writing a function to strip out non-numerics and found that SELECT ISNUMERIC('-') = 1. What!!!

Is there a reference that list SYSTEM SP logically as opposed to alpha? I spent too much time today trying to figure out which sp would return a list of databases to which a particular login has access (like the list you see in the Database Access tab of the Login Properties dialog box). I...

franklin97355, The answer would be "not always"... but I can open the network connections properties box and click the repair button. Limited users do not have access to this button. It is greyed out.

Using WinXP Pro SP2, with cable connection and linxsys wireless router, zone alarm free firewall and avg antivirus. A default install of all software. this pc is connected by cat 5 to router sitting on desk. I can get online only sporadically. I boot up Firefox (or even IE) and get the...

nomadicalloy, I have read the BOL and created a format file (interactively) and that works fine... but I do not see anything that specifies how I can wrap values in quotes. I could alwasy build a query that does this. Is that the only option? Kevin

using sql server 2k sp2 using master.dbo.xp_cmdshell 'bcp ... ' I can output a query to a text file (csv) with only one problem. I need the values to be wrapped in quotes like this "1","me","you" "2","he","she" I currently get 1,me,you 2,he,she I am so close. Please tell me that there is...

NoCoolHandle, The red button stays red, so clearly you are right about a proces being held open. But I can copy and execute the exec xp_cmdshell manually from a window withou a problem. Ahh to hell with it!!! I just gave up and coded this in my ASP page using File System Object and gave...

prod machine: Win2003 Server, Sql Server 2k SP1 dev machine: WinXP Pro, Sql Server 2K SP2 This issue only occurs on the prod machine... during user acceptance testing of course. WHAT I HAVE DONE 1. I granted the right to run xp_cmdshell with the following (found by Googling "xp_cmdshell...

Catadmin, Thanks for the quick response and there are no trivial suggestions as you pointed me in the right direction. This is an AFTER TRIGGER. The DTS does not drop and recreate the table but... The TRANSFOR DATA TASK had the FAST LOAD and CHECK CONSTRAINTS option set. I unchecked these...

using SQL SERVER 2K, dev machine: WINXP PRO prod machine: WIN SERVER 2003 I have a DTS package which transforms a text file into a table : 1.CONNECTION OBJECT TO TEXT FILE 2.TRANSFORM DATA TASK OBJECT MAPPING FIELDS 3.CONNECTION OBJECT TO DB This works. The trigger on that table, though is...