mssql equivalents to mysql_errno & mysql_error

I have looked in the online manual but am not able to find the
equivalent functions in mssql of mysql_errno() & mysql_error().
I am in the unfortunate position of having to develop using an existing
MSSQL database.

--

Regards,
Alf Stockton www.stockton.co.za

Lady Luck brings added income today. Lady friend takes it away tonight.

My email disclaimer is available at www.stockton.co.za/disclaimer.html

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: mssql equivalents to mysql_errno & mysql_error

I have looked in the online manual but am not able to find the
> equivalent functions in mssql of mysql_errno() & mysql_error().
> I am in the unfortunate position of having to develop using an existing
> MSSQL database.

There aren't any as far as I know. I think the best you can do is test for
the existence of whatever you are looking for (connection, result set etc)
at each stage and do something graceful. Not much use for debugging though.

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: mssql equivalents to mysql_errno & mysql_error

------=_NextPart_000_0044_01C5B87E.ADE0AD20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks for your advice.=20
ADODB link
http://adodb.sourceforge.net/

Please use reply all to send your message to the list

-----------------------------------------
in my experience is better to use an abstraction layer library like =
adodb=20
this will allow you to switch database in the future, besides that =
provides error control and debug options and it is extremly easy to =
develop with.

Luck!


I have looked in the online manual but am not able to find the
equivalent functions in mssql of mysql_errno() & mysql_error().
I am in the unfortunate position of having to develop using an existing
MSSQL database.
=20
There aren't any as far as I know. I think the best you can do is test =
for
the existence of whatever you are looking for (connection, result set =
etc)
at each stage and do something graceful. Not much use for debugging =
though.


------=_NextPart_000_0044_01C5B87E.ADE0AD20--

I Can"t connect to MySql using ADODB

Hi There,

I am trying to connect to MySQL using ADODB library for PHP using the
following code with no success. What am I doing wrong?

include('/php/adodb.inc.php');

$db =3D &ADONewConnection('mysql'); # eg. 'mysql' or 'oci8'=20
$db->debug =3D true;
$db->Connect('localhost', 'tony', 'mypassword', 'test');
$rs =3D $db->Execute('select * from users');
print "

";

print_r($rs->GetRows());

print "

Re: I Can"t connect to MySql using ADODB

Tony Aldemir wrote:

>Hi There,
>
>I am trying to connect to MySQL using ADODB library for PHP using the
>following code with no success. What am I doing wrong?
>
> >include('/php/adodb.inc.php');
>
>$db = &ADONewConnection('mysql'); # eg. 'mysql' or 'oci8'
>$db->debug = true;
>$db->Connect('localhost', 'tony', 'mypassword', 'test');
>$rs = $db->Execute('select * from users');
>print "

";

>print_r($rs->GetRows());

>print "

Re: I Can"t connect to MySql using ADODB

> Tony Aldemir wrote:
>
> >Hi There,
> >
> >I am trying to connect to MySQL using ADODB library for PHP using the
> >following code with no success. What am I doing wrong?
> >
> > > >include('/php/adodb.inc.php');
> >
> >$db = &ADONewConnection('mysql'); # eg. 'mysql' or 'oci8'
> >$db->debug = true;
> >$db->Connect('localhost', 'tony', 'mypassword', 'test');
> >$rs = $db->Execute('select * from users');
> >print "

";

> >print_r($rs->GetRows());

> >print "