XE6+FIREDAC connecting Sybase

First, Win7 X64 System installation Sybase ODBC:

1, Download the corresponding package to C:\system_odbc ( folder name itself, in the following registry content needs to use ), and then need to add the directory to the PATH environment variable ;

2. Write the value information to the registry:

WindowsRegistry Editor Version 5.00

[Hkey_local_machine\software\wow6432node\odbc\odbcinst. Ini\odbcdrivers]

"Sybasease ODBC Driver" = "Installed"

[Hkey_local_machine\software\wow6432node\odbc\odbcinst. Ini\sybasease ODBC Driver]

"Altdefaults" = "1"

"APILevel" = "1"

"Connectionfunctions" = "YYY"

"CPTimeout" = "60"

"DriverODBCVer" = "04.10"

"FileUsage" = "0"

"SQLLevel" = "0"

"Driver" = "c:\\sybase_odbc\\syodase." DLL "

"Setup" = "c:\\sybase_odbc\\syodases." DLL "

3, Enter the c:\windows\SysWOW64\ , find odbcad32.exe execution, such as

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/2B/C6/wKioL1OK8A6CREk7AAHLjmwLJVQ248.jpg "style=" float: none; "title=" 1.png "alt=" Wkiol1ok8a6crek7aahljmwljvq248.jpg "/>

To create a new user DSN, fill in the following:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/2B/C6/wKiom1OK8DqSITZFAAE2NNCJghM068.jpg "title=" 2.png " Style= "Float:none;" alt= "wkiom1ok8dqsitzfaae2nncjghm068.jpg"/>,test connect successfully, which means the installation was successful.

Second, the next use of Delphi XE6+FIREDAC to connect it:

Put in several controls that you need to use:

{ create a new VCL Forms application, and then add the following controls ( We recommend pressing Ctrl +. ) after adding with keyboard input ):}

tfdphysmysqldriverlink // Used to drive automatic connection ; Each database corresponds to a : Tfdphys****driverlink

tfdguixwaitcursor       // for automatic management of GUI program " "; in Console FMX

tfdconnection // Data Connection

Tfdquery // data Query

Tdatasource // Data Source

TDBGrid // Data Display

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/2B/C6/wKioL1OK8A3wVQdPAAPvxrwCnjY413.jpg "title=" 3.png " Style= "White-space:normal;float:none;" alt= "wkiol1ok8a3wvqdpaapvxrwcnjy413.jpg"/>