Results 1 to 2 of 2

Thread: Connecting to a DSN

  1. Jul 24th, 1999, 08:31 PM #1
    googie
    googie is offline

    Thread Starter
    New Member
    Join Date
    Jul 1999
    Location
    St Peters, MO, USA
    Posts
    15

    Post

    I have multiple DSNs set up on my server so that I can access databases through Active Server Pages. Is there a way to connect to a DSN on the server through VB? I need to access these databases but would rather use a DSN instead of the path so that I can update the DSN if the path of a DB changes.

    Any help is appreciated.
    Reply With Quote Reply With Quote
  2. Jul 25th, 1999, 07:50 PM #2
    bashfirst
    bashfirst is offline
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

    In VB 5.0 (and I assume VB 6 as well) there is a ODBC login form in the form wizard. It has some good code for generating a list of the DSNs available on a client box. Try creating the form with the wizard and cutting out the code you like.

    Bash
    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