Results 1 to 10 of 10

Thread: [2005] Database Connection

  1. Jan 23rd, 2008, 07:56 AM #1
    tonydotigr
    tonydotigr is offline

    Thread Starter
    Lively Member
    Join Date
    May 2006
    Posts
    100

    [2005] Database Connection

    I have an access database that resides on the network. What is the recommended method of verifying connectivity with this database before connecting the program. I'd basically just like to do a ping test or something to determine if the server is found if not throw a message.

    Thanks all!
    Reply With Quote Reply With Quote
  2. Jan 23rd, 2008, 08:25 AM #2
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: [2005] Database Connection

    You could do a File Exsists check. What version of VB are you using?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  3. Jan 23rd, 2008, 09:00 AM #3
    tonydotigr
    tonydotigr is offline

    Thread Starter
    Lively Member
    Join Date
    May 2006
    Posts
    100

    Re: [2005] Database Connection

    2005. Would that work better than a ping test? Looking for something that could run fairly quick as well.

    Thanks!
    Reply With Quote Reply With Quote
  4. Jan 23rd, 2008, 09:14 AM #4
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: [2005] Database Connection

    That should be quick. Try Sustem.IO.FileExsist(filename)
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  6. Jan 23rd, 2008, 09:15 AM #5
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [2005] Database Connection

    Wouldn't it be simpler, and far less code, to just error trap the connection code, and run with it?
    Reply With Quote Reply With Quote
  7. Jan 23rd, 2008, 05:37 PM #6
    tonydotigr
    tonydotigr is offline

    Thread Starter
    Lively Member
    Join Date
    May 2006
    Posts
    100

    Re: [2005] Database Connection

    Can you give me a code example of the error trap? Thanks!
    Reply With Quote Reply With Quote
  8. Jan 24th, 2008, 08:33 AM #7
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: [2005] Database Connection

    That would the depend on the programing language you are using
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  9. Jan 24th, 2008, 09:03 AM #8
    tonydotigr
    tonydotigr is offline

    Thread Starter
    Lively Member
    Join Date
    May 2006
    Posts
    100

    Re: [2005] Database Connection

    Visual Basic
    Reply With Quote Reply With Quote
  11. Jan 24th, 2008, 09:09 AM #9
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: [2005] Database Connection

    VB6? VB.Net 2003? .Net 2005? .Net 2008?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  12. Jan 24th, 2008, 09:21 AM #10
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [2005] Database Connection

    If you are using VB.NET 2005, then you would use the Try/Catch/Finally method of error trapping.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width