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
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
Log in to post a comment.
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
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