Re: Output data to a program

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/23/04


Date: Tue, 23 Mar 2004 17:26:04 +0100

This is what a client application does when it connects to SQL Server using
some of the database API's provided (ODBC, JDBC, ADO, ADO.NET, Db Library,
OLEDB, SQL-DMO, the upcoming SMO, VBSQL etc.) There's no built-in mechanism
for publishing data apart from the API's. If you elaborate on what you want
to accomplish then perhaps someone can give you a suggestion...

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Steve Chen" <anonymous@discussions.microsoft.com> wrote in message
news:95B7695E-F2C6-4B29-9980-EE434B88E44E@microsoft.com...
> Does SQL2000 has the funtion of output data to a executing program. Like
pipe command of Oracle.


Relevant Pages

  • Re: OLEDB consumer and for xml auto SELECT
    ... ADO .Net is very different from ADO in several regards. ... Odbc Client, OleDB Client and SqlClient. ... SQL Server, and for applications where portability is not of interest, ...
    (microsoft.public.data.oledb)
  • Re: MS SQL Server
    ... Native for MS SQL Server are OLEDB/ADO, ODBC, ADO.Net. ... If you need easy-to use components, use ADO (ADO Express or dbGo) that you ... If you need speed, try Oledb Direct ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: connect to db in codes
    ... Env: SQL SERVER + Delphi 7 + ADO ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.database.ado)
  • Re: Best component for using SQL Server 2005 DB with delphi 7
    ... ADO is the easest and most common used way to work with MS SQL Server from ... ADO) or ADO.Net (compatibility with .Net applications, for example, if you ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: SQL 2005, Data Publishing, Cyclical foreign key relationships
    ... I ended up creating a script that deleted all fks and triggers and then ... Publishing data only is not supported for databases with cyclical ... I'm really confused on how the cyclical foreign key was created in the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.server)