DSN-less connection

Results 1 to 7 of 7

Thread: DSN-less connection

  1. #1
    Scouse Guest

    Default DSN-less connection

    What is the best DSN-less connection type to use, and what are the differences (if any) between these two:<BR><BR>conn.open "Driver={Microsoft Access Driver(*.mdb)};Data Source=name.mdb;"<BR><BR>or<BR><BR>conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=name.mdb;"

  2. #2
    MG Guest

    Default Not Advanced

    Most say that the second one is better.

  3. #3
    Scouse Guest

    Default Probably Not Advanced


  4. #4
    Eddie Campbell Guest

    Default RE: Probably Not Advanced

    Read http://www.4guysfromrolla.com/webtech/070399-1.shtml

  5. #5
    Scouse Guest

    Default RE: Probably Not Advanced

    Thanks, good article if a little MS biased, but it does not explain if there&#039s any difference between the two types of DSN-less connection strings shown in my first message : which is better and why?

  6. #6
    Scouse Guest

    Default Eddie, check this out...

    Check out your SQL7 xml post on the moderated advanced pages.. possible solution should come through when its cleared &#039vetting&#039

  7. #7
    Eddie Campbell Guest

    Default Thanks

    Thanks, I&#039ll keep looking :)

Posting Permissions

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