Re: connect to db in codes

You can use dbExpress, ADO type libraries without VCL wrappers, you can use
OLEDB or ODBC or event ADO.Net, you can use old way such as DBLib and BDE.
The best way depends on what you want to do - all these ways will require
you to learn their API.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"keith" <support@xxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:44725329@xxxxxxxxxxxxxxxxxxxxxxxxx
Not using adoconnection, adoquery, etc......

--
Env: SQL SERVER + Delphi 7 + ADO
"John Herbster" <herb-sci1_AT_sbcglobal.net>
??????:447121e1$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Keith" <support@xxxxxxxxxxxxx> wrote
Is it possible to connect to access or sql server purely
in codes not using components?

Keith,
By "components" do you mean descendents of TComponent?
If not, then what?
Rgds, JohnH





.

Relevant Pages

  • Re: Parameters Question
    ... OleDB the syntax for calling a stored procedure is the same as the ODBC ... The .NET Framework Data Provider for SQL Server does not support the ... In this case, you must use named parameters, as in the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Parameters Question
    ... Also as I said in my post, the reason I sometimes use OLEDB for both Access ... and SQL Server is so I can upsize the Access database to SQL Server and use ... Do you have an example of using named parameters with OLEDB for both Access ... It will work with question mark placeholders. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: oledbconnection v sqlconnection
    ... The OleDb provider is a one-size-fits-all data access interface that uses ... No two database engines have the same SQL so you'll have to ... actual low-level data access layer and exposes a common object layer that ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access linked tables to ODBC in C++/ADO application
    ... to stay inside an actual Access OLEDB file. ... the .MDB, but are run against linked tables to the SQL Server ODBC ... I know that OLEDB is just the standard protocol, ...
    (comp.databases.ms-access)
  • Re: Really want a answer, is there a mature way to access different data providers without performan
    ... I dll can support both SQL server and mysql, ... > You can use OleDB and ODBC also. ... > direct adapter as SqlClient. ...
    (microsoft.public.dotnet.framework.adonet)