RE: [PHP-GENERAL] MS SQL and PHP connectivity question
| From: | Chuck Barnett | Date: | Thu, 01 Jun 2000 15:33:02 +0000 |
| Subject: | RE: [PHP-GENERAL] MS SQL and PHP connectivity question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-819@lists.php.net to get a copy of this message | ||
I am getting this error:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified, SQL state IM002 in SQLConnect in
d:\roopfinancial\phptest\index.php on line 2
Warning: Bad ODBC connection number (0) in
d:\roopfinancial\phptest\index.php on line 4
Warning: Bad result index 0 in d:\roopfinancial\phptest\index.php on line 5
This is the code:
<?
$connection=odbc_pconnect("huginn","chuck","chuck");
$query="select * from names";
$result=odbc_do($connection, $query);
$stuff = odbc_fetch_row($result);
echo $stuff;
?>
but what is the equivilent of "mysql_select_db" in the odbc world?
Chuck
-----Original Message-----
From: Liz Kimber [mailto:liz@xcalibur.demon.co.uk]
Sent: Thursday, June 01, 2000 9:39 AM
To: Chuck Barnett; php-general@lists.php.net
Subject: RE: [PHP-GENERAL] MS SQL and PHP connectivity question
The hostname/IP of the machine holding the sql server
> -----Original Message-----
> From: Chuck Barnett [mailto:cbarnett@netcabtec.com]
> Sent: Thursday, June 01, 2000 15:41
> To: 'php-general@lists.php.net'
> Subject: [PHP-GENERAL] MS SQL and PHP connectivity question
>
>
> Hello, I am starting an application that will be on an NT server
> running IIS
> 4 and an MS SQL db running on another NT server. I have in the past just
> made connections to MySQL with php as an apache module. All of
> this was on
> one box. In the NT world how do I make the odbc connection across the
> servers?
>
> $connection=odbc_connect("_what_would_go_here", username, password)
>
> would the ip address go there or what? please forgive my ignorance :)
>
> Chuck
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net