Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: KCWMS
  • Order by date
  1. KCWMS

    Use Ent LIb to deserialize a SqlParameter

    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...
  2. KCWMS

    Outlook cannot connect when IE can

    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...
  3. KCWMS

    Outlook cannot connect when IE can

    ...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...
  4. KCWMS

    Ent Lib Unhandled Exception -new to C#

    ...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...
  5. KCWMS

    Managing SQL Server/msde from visual studio

    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...
  6. KCWMS

    try-catch continue?

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

    try-catch continue?

    ...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
  8. KCWMS

    SET NOCOUNT OFF?

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

    how do I know when a message is opened

    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...
  10. KCWMS

    SP ERROR HANDLING

    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...
  11. KCWMS

    Why is ISNUMERIC('-') = 1

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

    a list of SP organized by task

    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...
  13. KCWMS

    limited user's internet access inconsistant

    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.
  14. KCWMS

    limited user's internet access inconsistant

    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...
  15. KCWMS

    bcp out to a csv file with quoted values

    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
  16. KCWMS

    bcp out to a csv file with quoted values

    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...
  17. KCWMS

    Exec xp_cmdshell blocking process

    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...
  18. KCWMS

    Exec xp_cmdshell blocking process

    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...
  19. KCWMS

    DTS not triggering TRIGGER

    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...
  20. KCWMS

    DTS not triggering TRIGGER

    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...

Part and Inventory Search

Back
Top