Adodb & Ms Sql 2000

[Ted_Haller]

Hi,

The include problem I was having (see previous thread) seems to be resolved (the include path in the php.ini file was commented out). My problem now is that the connection times out when trying to connect to the db.

My code looks like this:

<?
include("adodb/adodb.inc.php");

$hostname = "hostname";
$username = "username";
$password = "password";
$dbname = "webdb";

$db = ADONewConnection('mssql');
$db->Connect( $hostname, $username, $password, $dbname);

...

It seems to timeout trying to do the 'Connect'. I've been assured by the sys. admin. that the hostname, username, and password are correct.

Assuming they are correct, is there something else I've missed?

Any and all suggestions would be most welcome - I'm down to only a few hairs left on my head ;-(

Cheers

Ted

[tomhath]

I haven't tried connecting to mssql this way, but from what I've read you might need a call to ADOLoadCode before the connect:

http://php4you.kiev.ua/docs/adodb.html

[Ted_Haller]

I tried that but it didn't work ;-(

You mention you haven't tried connecting to mssql this way - does that mean you've been able to connect some other way?

The documentation mentions that 'mssql' is the driver name for MSSQL 7. I'm trying to connect to MSSQL2000. Please tell me it's possible for php to talk to a SQL2000 db!!

cheers

[Ted_Haller]

The question has become a lot simpler now. Can PHP connect to an MSSQL 2000 database?

If so, can someone show me how?

Thanks

[tomhath]

We use asp :o(

[Ted_Haller]

You can get php to talk to ms sql 2000!! :-)

I read on one of the forums that there is a bug in the adodb-odbc.inc.php file. It tries connecting using the 'hostname':
$dbh = odbc_connect( $hostname,...)

what it should be doing is connecting using the dsn_name.

i.e. $db->Connect( $dsn_name, $username, $password, $dbname) or DIE( "connection failed" );

BUT, there seems to be other problems :-(

I've got Omni installed on my machine and I'm able to connect and read from the MSSQL 2000 server via 'localhost'. BUT when I try to do exactly the same thing through our IIS server, the '$recordset = db->execute( $sql ) or DIE( "execute failed" ); doesn't work.

In both instances I'm connecting to the same db and I'm pulling off the same record set.

I've tried creating a COM 'recordset' object ->
$recordset = new COM( "ADODB.RecordSet" );

But having done that, how does one perform the 'execute' to read in the record set (and then to subsequently loop through the table)?

Thanks

[rtconner]

yeah the problem is that your useing Microsoft SQL Server.
(that was a joke)