Database connection



<?php

I have a question about 2 connection strings to a ms sql database.

# TEST DATABASE

$connecttest = MSSQL_CONNECT("TEST", "sa", "123456") or exit("Unable to
connect to MS SQL Server at 10.0.10.58");

$select = mssql_select_db ("database1",$connecttest) or exit("Unable to
select database TEST");


# PRODUCTION DATABASE

$connectprod = MSSQL_CONNECT("PROD", "sa", "654321") or exit("Unable to
connect to database at 10.0.10.59");

$select = mssql_select_db ("database2",$connectprod) or exit("Unable to
select database PROD");


$SQL = "SELECT * FROM table1";

$RESULT = mssql_query($SQL);


// What data will i find here? Is it data from the TEST or from PROD and
will it be data from database1 or from database 2?

?>


.



Relevant Pages

  • Re: Access2k upsizing to SQL2k Automation
    ... Once I manually set the primary keys on two of the ... correctly against the SQL database. ... Upsize Wizard only marks some of the columns 'null'. ...
    (microsoft.public.access.conversion)
  • Re: Help with dtsrun and dts package.
    ... What I have done is create an SQL database, ... Error string: The specified DTS Package ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.odbc)
  • Re: too much OOP ?
    ... SQL database, ... You cannot say that without specifying what kind of requests are planned. ... nothing about inventory management, but in my area of interest relational ...
    (comp.object)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: Q: Datatables, Datasets and updating
    ... I have two tables A and B in the SQL database. ... ID_A (the primary key of A) and NAME_A (a string ...
    (microsoft.public.dotnet.languages.csharp)