If I remember right, PHP's built-in database functions don't allow for a
DSNLess connection. Meaning you have to set up an ODBC source on the machine
PHP is running on (or do a remote ODBC connection) and connect to a DSN (a
named datasource manually set up). BUT.. if you know the address of the server
and all the login information, you can do a DSNLess connection.
At my last job I used PHP on an IIS server to connect to a couple SQL Servers
and an Oracle server using ADODB for PHP.
I posted about it ages ago.. here's a link to an archived message where I
posted my DSN config file. Down here it says Cargo System databases you'll
find examples that might help. Sorry to be vague, but hopefully it's a start
for you. Once you get it configured, it should work fairly fluidly.
-TG
= = = Original message = = =
I have been asked by my client to use SQL Server for my php application
(uh!). The name of the server is 2k-server, but I am not sure
where to create the ODBC connection. Some of the docs state that all I
need is
?php
$connection_string = 'DRIVER=SQL
Server;SERVER=2K-SERVER;DATABASE=Php_Test';
$user = 'sa';
$pass = 'MyPassword';
$connection = odbc_connect( $connection_string, $user, $pass );
?
However that gives me an error:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified, SQL state IM002 in SQLConnect in
/home/httpd/test/odbc/php/connect.php on line 8
Any suggestions on the best way to connect?
Todd
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php