Consult everybody warrior:
Delphi xe5 how to connect to ms SQL server? Be urgent!

CodePudding user response:

Use adoconnection link

CodePudding user response:

Using ADO connection...

CodePudding user response:

Pull a ADOConnection control, double-click the control, click Build, choose the SQL SERVER, the next step...
Again pull a ADOQuery in attribute Connection select ADOConnection

In the code written

 
ADOQuery1. Close; 
ADOQuery1. SQL. The Clear; 
ADOQuery1. SQL. The Add (' SELECT a FROM TABLE); 
ADOQUery1. Open; 

Showmessage (ADOQuery1 FieldByName (' a '). AsString) are identical. 

So you get the TABLE TABLE field a value, multi-line, get a cycle again

CodePudding user response:

Ladies and gentlemen, ADO controls simple, I ask is FireMonkey Mobile Application, how to connect? FireDac within those controls,

CodePudding user response:

No, only through a webService

CodePudding user response:

Through the webService what in? Ace to specific directions?

CodePudding user response:

Need to do a server, the server database using ado to connect, the server to do service, service can take through ado data, then you can do that through the webservice request to the server, the server through the data such as XML or json format to you

CodePudding user response:

Still don't understand, can you give the code?

CodePudding user response:

1, use DataSnap do a server;
2, using ADO or dbExpres servers;
3, the server to the client and, it is necessary to transfer data using XML or JSON.
4, the client will give DBGrid parses XML or JSON, or other display data controls,
Routines is such, the code is more complex,