SQL Server Performance

To make a Database connection

Discussion in 'General Developer Questions' started by ks9072, Jul 14, 2003.

  1. ks9072 New Member

    Hi All,
    To make a Database connection from Windows workstation/Window 2000 desktop to MSSQL 2000 Database using VB6 Program, What are the components I should install on my workstations?

    Regards
    Sri
    ks9072, Jul 14, 2003
    #2

  2. rushmada New Member

    U should have atleast Sql client connectivity tools(Preferable sql 2k) should be installed in the Windows workstation or 2000 desktop, DSN should be defined in the ODBC
    data source administrator under system dsn and test the dsn by connecting to the server.


    Thanks.

    Rushendra
    rushmada, Jul 15, 2003
    #2

  3. Chappy New Member

    My recommendation would be to use ADO and connect using OLEDB, rather than ODBC. For this you will need MDAC runtime installed, search for it on microsoft site
    Chappy, Jul 15, 2003
    #2

  4. satya Moderator

    True, check this link http://www.connectionstrings.com/] for detailed information and resources for syntax to create connections.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Jul 15, 2003
    #2

  5. gaurav_bindlish New Member

    You will need to install just the Microsoft Data Access Componenets (MDAC) if you wish to connect using VB only. However if you would like an interface to query database directly, you will need SQL Server Query Analyzer. This is generally preferred on Development machines and not on production machines.

    I agree with Chappy that OLE DB connection usinf ADO is the best way to connect to Database and for that you need not make a DSN.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    gaurav_bindlish, Jul 15, 2003
    #2

  6. ks9072 New Member

    Many thanks for all,

    Is it possible to include the MDAC runtime components my VB EXE (Program)? or Just I need to install the MDAC runtime along with the VB EXE

    Regards
    Sri

    ks9072, Jul 15, 2003
    #2

  7. gaurav_bindlish New Member

    Well you can install MDAC as a part of the setup for your VB Program. You'll need to do some coding in installshield though.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    gaurav_bindlish, Jul 15, 2003
    #2

  8. ks9072 New Member

    Hi,

    I installed a PC with windows 2000 professional edition and tried to connect to the MSSQL server 2000 standard with VB exe, I could able to get the database connection. How it is possible with the MDAC??
    Sri
    ks9072, Jul 17, 2003
    #2

  9. gaurav_bindlish New Member

    I guess Microsoft Data access components are installed by defualt on newer version of Windows.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    gaurav_bindlish, Jul 17, 2003
    #2

  10. royv New Member

    Windows 2000 without any service packs comes with MDAC 2.5


    "How do you expect to beat me when I am forever?"
    royv, Jul 18, 2003
    #2

Share This Page