Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Location
    Los Mochis
    Posts
    3

    Talking Unanswered: Connecting to Delphi

    Somenone can help me to connect a MSSQL to a Delphi App.

  2. #2
    Join Date
    May 2002
    Posts
    3
    what are you want to know? explain please...

  3. #3
    Join Date
    May 2002
    Location
    Los Mochis
    Posts
    3

    Connecting to SQL Server

    well, my problem its that i build the data bases in MSSQL, i already setup a DNS in OBDC, but whe in try to call that DNS from a Delphi application this throw me an error on conection, you can help me explaining me the steps to make a good setup of a simple database in MSSQL for use with Delphi

    Thanks

  4. #4
    Join Date
    Dec 2001
    Location
    India
    Posts
    25
    Hi,

    Here is a simple way to connect to sql server using ODBC DSN & Delphi.
    I hope this will help you.

    1. Drop a Database Component from DataAccess Tab

    2. Set the following properties for Database Component
    1. AliasName - The DSN name created with ODBC
    2. DatabaseName - The database you want to connect to sql server for example give "PUBS"
    3. Login Prompt - False
    4. Name - "PUBS_DB"
    5. Params - USER NAME=SA
    DATABASE NAME=PUBS

    3. Now Drop a Table Component from DataAccess Tab

    4. Set the following properties for Table Component
    1. DatabaseName - PUBS
    2. Now in "Table", select the table name you want
    3. Active - True

    5. Drop a DataSource and Link the dataset to Table

    6. Now drop a DBGrid from DataControls and link the datasource.

    Regards,
    Selva Balaji B.

  5. #5
    Join Date
    May 2002
    Location
    Los Mochis
    Posts
    3

    thankz

    i made it
    thankz
    i got another question, what about connecting to a server in my LAN, what should i configurate
    thankz again

Posting Permissions

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