Results 1 to 4 of 4

Thread: [RESOLVED] ODBC Help

  1. Sep 5th, 2007, 10:22 AM #1
    zynder
    zynder is offline

    Thread Starter
    Frenzied Member zynder's Avatar
    Join Date
    Nov 2006
    Location
    localhost
    Posts
    1,434

    Resolved [RESOLVED] ODBC Help

    Hi once again. This is my 3rd post for the past 2 days.

    I'm done with my VB6 app with SQL as the backend. It's ready for testing to different workstations, however my app is ODBC dependent. I don't want the clients to be configuring their ODBC DSN.

    I've search my entire registry and found where it was added. It's via registry but I want to find ways to hard code the ODBC configuration beside the registry settings.

    Is there other way, besides the registry?
    My Bible - SEO Techniques - Search first before posting.
    Reply With Quote Reply With Quote
  2. Sep 5th, 2007, 10:31 AM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: ODBC Help

    You don't need to use a DSN at all - see the Connection Strings link in my signature for the 'modern' way to do it.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. Sep 5th, 2007, 10:43 AM #3
    zynder
    zynder is offline

    Thread Starter
    Frenzied Member zynder's Avatar
    Join Date
    Nov 2006
    Location
    localhost
    Posts
    1,434

    Re: ODBC Help

    Holy Moly!

    How many $$$ do I owe you Si? connectionstrings.com is great.
    My Bible - SEO Techniques - Search first before posting.
    Reply With Quote Reply With Quote
  4. Sep 5th, 2007, 10:49 AM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: [RESOLVED] ODBC Help



    It's a very useful site, but in several cases leaves a bit to be desired.. I have gradually been writing my own version to put in our FAQs, but it isn't my top priority as there is already something out there.
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    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