RE: Anmeldung an MSSQL-Server ueber vertraute Verbindung mit PHP

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

From: Frank Kalis (nospam_at_insidesql.de)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 02:15:04 -0800

"Irmgard Schwenteck" wrote:

> kann man die Verbindung zu einem MS-SQL-Server auch über NT-Sicherheit
> realisieren?

Ja, z.B. mit COM und ADO

$db = new COM("ADODB.Connection");
$dsn = "DRIVER={SQL Server};
SERVER={XXX};DATABASE={FRANK_PLAYGROUND};Trusted_Connection=yes;";
$db->Open($dsn);

$delID =$HTTP_GET_VARS['id'];
$delWho = $HTTP_GET_VARS['who'];
switch($HTTP_GET_VARS['action'])
{
...
$rs = $db->Execute("...");
$count = $db->Execute("...");

> mssql_connect() erwartet wohl immer einen SQL-Nutzernamen.
>

AFAIK, Ja.
-----------------------
--Frank
http://www.insidesql.de
-----------------------

Relevant Pages

  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Re: Variable in SQL Where Statement in =?windows-1252?Q?=93Pass_?= =?windows-1252?Q?__Throug
    ... to a server, either. ... Well, when using ADO, we can indeed bind the resultset of stored procedure to a form and still have it updatable, providing we follow same set of rules we have to follow for writing queries for a form's recordsource. ... It's only in the case where you've bound a form to ADO recordset would you get a ADO recordset from the form's recordset. ... I actually never though to overlay a parameter query on top of a passthrough query, but that's two objects for one function, and I'm loath to create several objects. ...
    (microsoft.public.access.modulesdaovba)
  • Re: CHANGING from DAO to RDO
    ... To boost the speed we use Terminal Server 2003 and it definetly helps on the fact that we get less corruption, but certain queries take awhile and we want to add more users. ... I don't know _where_ you got the idea that ADO and RDO were the only methods to access SQL Server. ... In fact, I have never heard of anyone using RDO with an Access database, only, in the past, with the separate VB product. ... The VB crowd abandoned it for ADO with SQL Server, even though they, too, could use DAO and, for them too, DAO was simpler and easier. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Moving data back and forth between Excel and SQL Server
    ... your database you should look into using ADO. ... ADO proides an object model to let you work with data via SQL/ODBC. ... records, or to update/add records, or even to create or modify tables - all ... MyRs.Update ' updates recordset on server ...
    (microsoft.public.excel.programming)
  • Re: Error -2147168227 Cannot create new transaction because capacity was exceeded.
    ... OLEDB provider for SQL Server. ... > I have been unable to find info in the Knowledge base, ADO or SQL Server ... > ADO driver generates the error. ...
    (microsoft.public.data.ado)