BorlandTalk.com

TheMaxx · Guest

Where can i find tutorial for Delphi connectiong to SqlServer?

Thanx.

Alain Quesnel · Guest

If all you need is setting up the connection, it's pretty straightforward.
1) Drop a TADOConnection on your TForm or TDataModule.
2) Click on the ConnectionString property
3) Follow the wizard. For the driver type for MSSQL 7 or 2000, use OLE DB
Provider for MSSQL, for MSSQL 2005, use Native SQL Client.

Then, all other ADO components (TADOQuery, TADODataSet, TADOStoredProc,
etc.) will use the connection string of your TADOConnection (ex.:
ADOQuery1.Connection := ADOConnection1)

--

Alain Quesnel
alainsansspam (AT) logiquel (DOT) com

www.logiquel.com

"TheMaxx" <themaxxREMOVE (AT) net (DOT) hr> wrote in message
news:ev306l$s53$1 (AT) magcargo (DOT) vodatel.hr...

TheMaxx · Guest

Thanks!
I think drag-n-drop is great funcionality, however i really need to konw
what's going on
like:

ADOConn conn := new ADOConn();
conn.ConnectionString := '....';
ADORecordSet ARS := conn.ExecuteSqj('SELECT * FROM Table');

Where can i find references with examples?
I find Borlan help wery poor with no examples.
Resources on web are not that great either.

Thank you for you help!

"Alain Quesnel" <alainsansspam (AT) logiquel (DOT) com> wrote in message
news:4615b333$1 (AT) newsgroups (DOT) borland.com...

Dennis Passmore · Guest

function ADOConnectionString(fTrusted: Boolean;
const fUserName, fPassword, fDataBase, fSqlServer: string): string;
var
fModuleFileName: string;
begin
Result := '5098';
SetLength(fModuleFileName, 255);
GetModuleFileName(HInstance, PChar(fModuleFilename), 255);
fModuleFilename := ExtractFilename(Strpas(pchar(fModuleFilename)));
if fTrusted then
Result :=
'Application Name=' + fModuleFilename + ';' +
'Workstation ID=' + Get_Computer_Name + ';' +
'LoginName=' + Get_User_Name + ';' +
'Provider=SQLOLEDB.1;' +
'Network Library=DBMSSOCN;'+
'Use Procedure for Prepare=0;'+
'OLE DB Services=-1;' +
'Persist Security Info=True;' +
'Integrated Security=SSPI;' +
'Initial Catalog=' + fDatabase + ';' +
'Data Source=' + fSqlServer
else
Result :=
'Application Name=' + fModuleFilename + ';' +
'Workstation ID=' + Get_Computer_Name + ';' +
'LoginName=' + Get_User_Name + ';' +
'Provider=SQLOLEDB.1;' +
'OLE DB Services=-2;' +
'Persist Security Info=True;' +
'User ID=' + fUsername + ';' +
'Password=' + fPassword + ';' +
'Initial Catalog=' + fDataBase + ';' +
'Data Source=' + fSqlServer;
end;

Alain Quesnel · Guest

The connection string is merely a list of connection parameters separated by
semi-colons. Their values are self explanatory.

For a connection to a database unsing ADO (dbGo), you need:

A) A connection string. This can be centralized on a TADOConnection, or
specified for each TADOxxx component (Query, Dataset, StoredPRoc, etc.)
B) A TADOxxx component.
C) That TADOxxx component needs a connection string or a TADOConnection,
either a table name or a SQL statement (select * from MyTable) or a
procedure name (for a TADOStoredProc), parameters if need be.
D) A TDataSource
E) A TDBGrid or a few DB aware components (TDBEdit, TDBLabel, TDBMemo, etc.)

I can post (on the attachments NG) a small test project that connects to a
MSSQL table.

--

Alain Quesnel
alainsansspam (AT) logiquel (DOT) com

www.logiquel.com

"TheMaxx" <themaxxREMOVE (AT) net (DOT) hr> wrote in message
news:ev4p0f$b63$1 (AT) magcargo (DOT) vodatel.hr...