How to connect in remote SQL Server?

Help
Anonymous
2011-06-20
2013-05-01

  • Anonymous
    2011-06-20

    About dbx2-connections.ini:

    DriverName=DbxSQLServer
    Database=?
    User_Name=user
    Password=password
    RowsetSize=20
    BlobSize=-1
    ; Delphi7Up or 'Delphi6 + DbxXXDrv.pas'
    Trim Char=True
    Custom String=coConnectionString=DATABASE=dbdemos;Trusted_Connection=No;LANGUAGE=German;coICloneCon=1;coNetPacketSize=8192;coLockMode=17;coCatPrefix=DATABASE
    ; Optional 'Prepare SQL':
    ;Prepare SQL=False

    No "Host Name" or "Server Name", Why?
    Please help me~~~~! THX!!!

     
  • odbc:
    VendorLib = 'odbc32.dll'
    Custom String=coConnectionString=DRIVER=SQL Server;SERVER=192.168.4.254;DATABASE=dbxoodbc;Trusted_Connection=No;UID=user1;PWD=pwd1;

    200/2005 odbc:
    odbc:
    VendorLib = 'sqlsrv32.dll;odbc32.dll'
    Custom String=coConnectionString=DRIVER=SQL Server;SERVER=192.168.4.254;DATABASE=dbxoodbc;Trusted_Connection=No;UID=user1;PWD=pwd1;

    2005 tcp:
    VendorLib = 'sqlncli.dll;odbc32.dll'
    Custom String=coConnectionString=DRIVER=SQL Native Client;SERVER=127.0.0.1\SQLEXPRESS2005;DATABASE=dbxoodbc;Trusted_Connection=Yes;LANGUAGE=….

    2000/2005 tcp native:
    VendorLib = 'sqlsrv32.dll'
    Custom String=coConnectionString=SERVER=\\127.0.0.1\SQLEXPRESS2005;Trusted_Connection=Yes;DATABASE=dbxoodbc;coCatPrefix=DATABASE;coTrimChar=1

    2005 tcp native:
    VendorLib = 'sqlncli.dll'
    Custom String=coConnectionString=SERVER=\\127.0.0.1\SQLEXPRESS2005;Trusted_Connection=Yes;DATABASE=dbxoodbc;coCatPrefix=DATABASE;coTrimChar=1

    2000 tcp native:
    VendorLib = 'sqlsrv32.dll'
    Custom String=coConnectionString=SERVER=127.0.0.1;Trusted_Connection=Yes;DATABASE=dbxoodbc;coCatPrefix=DATABASE;coTrimChar=1

    2000/2005 pipe:
    VendorLib = 'sqlncli.dll'
    Custom String=coConnectionString=SERVER=\\127.0.0.1\pipe\MSSQL$SQLEXPRESS2005\sql\query;Trusted_Connection=Yes;DATABASE=dbxoodbc;coCatPrefix=DATABASE;coTrimChar=1

    2000/2005 native pipe:
    VendorLib = 'sqlncli.dll'
    Custom String=coConnectionString=SERVER=\\127.0.0.1\pipe\MSSQL$SQLEXPRESS2005\sql\query;Trusted_Connection=Yes;DATABASE=dbxoodbc;coCatPrefix=DATABASE;coTrimChar=1

    2000 pipe local:
    VendorLib = 'sqlsrv32.dll'
    Custom String=coConnectionString=SERVER=\\.\pipe\sql\query;Trusted_Connection=Yes;DATABASE=dbxoodbc;coCatPrefix=DATABASE;coTrimChar=1

     

  • Anonymous
    2011-06-21

    Cool!!!
    Thank's your information.
    I like it!!!

    And I want to add "SERVER" in params. If it can.
    ex:

    DriverName=DbxSQLServer
    SERVER=127.0.0.1
    Database=?
    .
    .
    .

    Please help me again. THX!

     
  • DriverName=DbxSQLServer
    VendorLib = sqlsrv32.dll;odbc32.dll
    Database=?
    RowsetSize=20
    BlobSize=-1
    ; Delphi7Up or 'Delphi6 + DbxXXDrv.pas'
    Trim Char=True
    Custom String=coConnectionString=DRIVER=SQL Server;SERVER=127.0.0.1;DATABASE=mydatabasec;Trusted_Connection=Yes;
    ; Optional 'Prepare SQL':
    ;Prepare SQL=False