Forum Replies Created

Viewing 15 posts - 106 through 120 (of 378 total)

  • RE: Part time job offer. Work at home!

    Beware!  As Frank had noted in this thread, http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=15&messageid=152691&post=true, this may be posted more than once.

  • RE: Part time job offer. Work at home!

    Hi.  I checked into this too.  The Web site was registered in Los Angeles, CA on 8/2004 (even though CCPI has been around since 1991) and the email contact was...

  • RE: A SQLServerCentral.com Christmas

    Steve,

    That was fabulous!  Thanks for sharing the Christmas spirit with the sqlservercentral.com! 

    Here's wishing a Merry Christmas and Happy New Year to all!  That...

  • RE: Need help with ADO Connection

    That is the cutest emoticon.  I'm blushing! 

    Hope there's some good stuff...

  • RE: Need help with ADO Connection

    Frank,

    Just remember with the connection pooling thing that you need to make sure that the creation of connections is under your control. Use COM+ object pooling over MS SQL Server...

  • RE: What is a DBA???

    Congratulations!  You just entered the world of "I do everything".  Your boss will love you for your newfound interest but now you've compiled it on top of your old duties. ...

  • RE: Review - MSSQLRecovery

    Did you actually recover the database?  Do you mean that you ran into a memory problem during recovery?  I'm interested.  Please let me know.

  • RE: Need help with ADO Connection

    Who knows, Frank?  The site owners will have to divulge that one.  Maybe this joke will give you some clues... 

  • RE: Need help with ADO Connection

    Yeah, you're right.  I went off on a .NET tagent. 

    Back to Frank's original question, "Is there any advantage of closing and reopening an...

  • RE: Need help with ADO Connection

    Exactly!    Takes a little work but it's a solution.  See this article on connection pooling and the .NET framework:  http://www.ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html

  • RE: Need help with ADO Connection

    Antares686,

    True!  True!  Assuming you need to use shared database connections.  However, don't forget the dreaded exception problem with connection pooling. 

    "If a connection exists to a server that has disappeared,...

  • RE: Need help with ADO Connection

    Hi again, Frank,

    Have you ever heard of http://www.w3schools.com?  It is an awesome free Web site with Web building tutorials.  ADO is one of them, http://www.w3schools.com/ado/ado_intro.asp.  Check it out! ...

  • RE: Need help with ADO Connection

    Good to see you too, Frank!  I've been busy with parenthood myself.  Only my kids are furry.  I have two Silkie Terrier puppies that are six months old now.  They...

  • RE: Need help with ADO Connection

    Note:  Closing a connection object does not delete it from memory.   Same thing goes for the Recordset.  If you close an object and it's no longer needed, you should set...

  • Viewing 15 posts - 106 through 120 (of 378 total)