Results 1 to 13 of 13

Thread: Create ODBC

  1. Aug 24th, 2006, 06:17 PM #1
    ASoufan
    ASoufan is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    138

    Create ODBC

    Hello everyone
    I searched planet source code for a code that create a System ODBC
    but all codes are doing ODBCs that asks for user name and password
    I want the authenticity with Windows NT authentication using the network login ID
    how can I do this ?
    Thanks
    Reply With Quote Reply With Quote
  2. Aug 25th, 2006, 02:23 AM #2
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: Create ODBC

    Why do you need ODBC? You can use ADO code to connect without having the overhead and aggravation of ODBC setup.
    Reply With Quote Reply With Quote
  3. Aug 25th, 2006, 07:53 AM #3
    ASoufan
    ASoufan is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    138

    Re: Create ODBC

    Because the SQL Server is used by many clients on the network, an ODBC Connection setup needed to connect to the server.
    Reply With Quote Reply With Quote
  4. Aug 25th, 2006, 08:48 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,838

    Re: Create ODBC

    If this is just for your VB program, it isn't needed at all (and is arguably a bad idea anyway).

    See the Connection Strings link in my signature for examples of what you need to connect without DSN's.
    (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
  5. Aug 25th, 2006, 12:18 PM #5
    ASoufan
    ASoufan is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    138

    Re: Create ODBC

    I need to know how to create a system dsn regardless of it is a bad idea, I need to know how.
    Reply With Quote Reply With Quote
  6. Aug 25th, 2006, 02:29 PM #6
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,838

    Re: Create ODBC

    Well I suggest you search the forums for the code, as most of us stopped using DSN's years ago.
    (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
  7. Aug 25th, 2006, 05:18 PM #7
    ASoufan
    ASoufan is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    138

    Re: Create ODBC

    ty sir
    Reply With Quote Reply With Quote
  8. Aug 25th, 2006, 09:49 PM #8
    vbmom
    vbmom is offline
    Hyperactive Member
    Join Date
    Jun 2000
    Location
    NY
    Posts
    497

    Re: Create ODBC

    I wrote some code to lookup and create an ODBC once. It's all registry settings. Create an ODBC yourself the way you want, then check out the values in HKLM\SOFTWARE\ODBC\... under the DSN name you created.

    You do need to know the path to the driver that is being used, i.e. full path to sqlsrv32.dll for sql server, as it is one of the registry values. If you really want code, I can post what I've got.
    end war
    stop greed
    Reply With Quote Reply With Quote
  9. Aug 25th, 2006, 11:23 PM #9
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Create ODBC

    this will create a DSN
    VB Code:
    1. 'Creating the DSN 

    2.     StrAttribs = "Description="ODBC Driver Description" & Chr$(13) & "DBQ=" & DBName

    3.     rdoEngine.rdoRegisterDataSource "YourODBCName", "Microsoft Access Driver (*.Mdb)", True, StrAttribs
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  10. Aug 26th, 2006, 04:11 AM #10
    vbmom
    vbmom is offline
    Hyperactive Member
    Join Date
    Jun 2000
    Location
    NY
    Posts
    497

    Re: Create ODBC

    Wow. I wish I knew that 5 years ago! What object is rdoEngine from (remote data objects?)
    end war
    stop greed
    Reply With Quote Reply With Quote
  11. Jan 17th, 2007, 04:39 AM #11
    sessi4ml
    sessi4ml is offline
    Fanatic Member sessi4ml's Avatar
    Join Date
    Nov 2006
    Location
    Near San Francisco
    Posts
    956

    Re: Create ODBC

    I use an ODBC when connecting to our AS400, Do you still need some help?
    Alpha Micro: Alpha Basic, AS400 V5r2, EDI (Trusted Link/ Inovis.com),Access AS/400 via VB6, Qbasic for data conversions. A mix of Hardware too. ASCII Table , New Number to Words/66 digits , AS/400(v5r2) VB6 Viewer/Ask for code(ODBC) ^ What Is Transferring? , Check your Ports #Perfect Passwords , *Slide Bar Example , Logoff, Restart, Shut-Down PC *Keep Form On Top , Opaque Form ^ Create Objects at Run Time @ Check Key Caps Locks # GetTickCount(System Up Time) * Convert text to Excel & Collected Icons + Resize: Form/Text box ^ PC GateWay via Shell $ Drag & Drop Game ! PopUpMenu *Print File/no Open# Timer on Mult Forms ~ Splash & Mult Forms & Lots of Comments + Random/Timer/Guess * Dec >Hex >Oct >Bin % Get MAC (NIC) < saving to Registry > Wookiee Cookies \ BackUpDisk / World Conection SpeedTest $ Glossary Commonly Used Terms # phonetic list @ Detailed Computer Scan

    When posting Code, Use tags.. [CODE] *Your Code* [/CODE]
    Reply With Quote Reply With Quote
  12. Jan 17th, 2007, 04:42 AM #12
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: Create ODBC

    can you post the codes that connecting/creating ODBC for AS400
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  13. Apr 22nd, 2018, 01:34 PM #13
    sessi4ml
    sessi4ml is offline
    Fanatic Member sessi4ml's Avatar
    Join Date
    Nov 2006
    Location
    Near San Francisco
    Posts
    956

    Re: Create ODBC

    Quote Originally Posted by ganeshmoorthy View Post
    can you post the codes that connecting/creating ODBC for AS400
    All the code I found, located, created is in my signature...I wrote ? 2004?

    With the correct use -profile and password...it should work

    Glad to help
    MLS
    Alpha Micro: Alpha Basic, AS400 V5r2, EDI (Trusted Link/ Inovis.com),Access AS/400 via VB6, Qbasic for data conversions. A mix of Hardware too. ASCII Table , New Number to Words/66 digits , AS/400(v5r2) VB6 Viewer/Ask for code(ODBC) ^ What Is Transferring? , Check your Ports #Perfect Passwords , *Slide Bar Example , Logoff, Restart, Shut-Down PC *Keep Form On Top , Opaque Form ^ Create Objects at Run Time @ Check Key Caps Locks # GetTickCount(System Up Time) * Convert text to Excel & Collected Icons + Resize: Form/Text box ^ PC GateWay via Shell $ Drag & Drop Game ! PopUpMenu *Print File/no Open# Timer on Mult Forms ~ Splash & Mult Forms & Lots of Comments + Random/Timer/Guess * Dec >Hex >Oct >Bin % Get MAC (NIC) < saving to Registry > Wookiee Cookies \ BackUpDisk / World Conection SpeedTest $ Glossary Commonly Used Terms # phonetic list @ Detailed Computer Scan

    When posting Code, Use tags.. [CODE] *Your Code* [/CODE]
    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