Hey Martin,
First Problem (mssql): you don't have the mssql-extension running.
Check it out in the php.ini and remove the ; before the appropriate line.
Second Problem (odbc): I've never worked with mssql2k, but here a silly
question that *might* be the problem: the system-dsn entry, is it set on
the Web-Server ???
Hope this helps, at least a bit =8)
Greetinx,
Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________
-----Original Message-----
From: Martin Rokicki [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 7:08 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-WIN] mssql and odbc functions
Hi All,
Thanks for the advice on database connectivity. I've tried
connecting to the mssql server (which is running 2000 not 6.5 as I had
thought) with the mssql_connect function as well as the odbc_connect
function. When I run the mssql connect I use this code:
MSSQL_CONNECT($host,$user,$pass)
The variables are all defined with the correct values, but I receive an
error message:
Fatal error: Call to undefined function: mssql_connect() in
c:\inetpub\wwwroot\stpweb\test\mssql.php on line 7
I've looked through the PHP documentation and tried a couple of fixes for
this error, but no luck so far. Also when I try to connect to the database
using odbc connect and this code:
odbc_connect("dsn","uid","pas");
I get this message:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified, SQL state IM002 in SQLConnect
I have the DSN defined as a system dsn, and it works when tested. I know I'm
screwing something up, but I'm not sure what. Any help you could give would
be appreciated.
Regards,
Martin
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
