Results 1 to 3 of 3

Thread: ADO Connection

  1. Aug 31st, 2000, 04:02 PM #1
    JR Ewing
    JR Ewing is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    16
    I can't remember how to bring up the ODBC Data Source Admin screen, if I want the user to specify a User DSN, System DSN, File DSN, Driver etc.

    I've had suggestions just to keep the ConnectionString blank and try to open the connection, but that doesn't seem to work.
    Reply With Quote Reply With Quote
  2. Aug 31st, 2000, 04:34 PM #2
    quadoc
    quadoc is offline
    Lively Member quadoc's Avatar
    Join Date
    Jan 1999
    Location
    Ga, USA
    Posts
    83
    To bring the ODBC data source adm screen. Go to control panel and it should have an icon for ODBC. If not you have to install it.
    Reply With Quote Reply With Quote
  3. Sep 5th, 2000, 11:24 AM #3
    JR Ewing
    JR Ewing is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    16
    Sorry, I should have been more specific. I don't remember how to pull it up in my VB code. I'm using ADO. Here's what I have right now.

    dim cn As New ADODB.Connection

    With cn
    .ConnectionString
    = "DSN=Informix;Database=temp_db;Uid=;Pwd=;"
    .ConnectionTimeout = 10
    .Open
    End With

    I'd like to allow them to specifiy what type of System DSN, File DSN, Driver etc. they'd like to use.
    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