SQL Server COM question

[Sorry - I misposted this in the General group]

I am in the process of converting my clients PHP scripts that are
using Firebird so they will work with SQL Server (their request;
not mine).

Is there a reference where I can get the COM Methods and Properties?

Also, without loading the large AdoDb library, is there a
Prepare() method if I use the

$db = new COM("ADODB.Connection")

connection?

Any suggestions are greatly appreciated.

Todd

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

Re: SQL Server COM question

Todd Cary wrote:
> [Sorry - I misposted this in the General group]
>
> I am in the process of converting my clients PHP scripts that are using
> Firebird so they will work with SQL Server (their request; not mine).
>
> Is there a reference where I can get the COM Methods and Properties?

The php website maybe? http://php.net/com

> Also, without loading the large AdoDb library, is there a Prepare()
> method if I use the
>
> $db = new COM("ADODB.Connection")
>
> connection?

If you want to use adodb methods, you need to load it all up properly,
same as anything else.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Re: SQL Server COM question

Chris wrote:
> Todd Cary wrote:
>> [Sorry - I misposted this in the General group]
>>
>> I am in the process of converting my clients PHP scripts that are
>> using Firebird so they will work with SQL Server (their request; not
>> mine).
>>
>> Is there a reference where I can get the COM Methods and Properties?
>
> The php website maybe? http://php.net/com
>
>> Also, without loading the large AdoDb library, is there a Prepare()
>> method if I use the
>>
>> $db = new COM("ADODB.Connection")
>>
>> connection?
>
> If you want to use adodb methods, you need to load it all up properly,
> same as anything else.
>

I checked the http://php.net/com site initially and there is a
couple of examples, however there is not a list of all COM
methods and properties for SQL Server. Does anyone know where
such a list might exist?

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

Re: SQL Server COM question

Todd Cary wrote:
> Chris wrote:
>> Todd Cary wrote:
>>> [Sorry - I misposted this in the General group]
>>>
>>> I am in the process of converting my clients PHP scripts that are
>>> using Firebird so they will work with SQL Server (their request; not
>>> mine).
>>>
>>> Is there a reference where I can get the COM Methods and Properties?
>>
>> The php website maybe? http://php.net/com
>>
>>> Also, without loading the large AdoDb library, is there a Prepare()
>>> method if I use the
>>>
>>> $db = new COM("ADODB.Connection")
>>>
>>> connection?
>>
>> If you want to use adodb methods, you need to load it all up properly,
>> same as anything else.
>>
>
> I checked the http://php.net/com site initially and there is a couple of
> examples, however there is not a list of all COM methods and properties
> for SQL Server. Does anyone know where such a list might exist?
>

You could always get the freetds stuff working:

http://php.net/mssql

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Re: SQL Server COM question

Try the MSDN library:
http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/ado270/htm/mdobjconnectionpme.asp

- Frank

> Chris wrote:
> > Todd Cary wrote:
> >> [Sorry - I misposted this in the General group]
> >>
> >> I am in the process of converting my clients PHP scripts that are
> >> using Firebird so they will work with SQL Server (their request; not

> >> mine).
> >>
> >> Is there a reference where I can get the COM Methods and Properties?
> >
> > The php website maybe? http://php.net/com
> >
> >> Also, without loading the large AdoDb library, is there a Prepare()
> >> method if I use the
> >>
> >> $db = new COM("ADODB.Connection")
> >>
> >> connection?
> >
> > If you want to use adodb methods, you need to load it all up properly,

> > same as anything else.
> >
>
> I checked the http://php.net/com site initially and there is a
> couple of examples, however there is not a list of all COM
> methods and properties for SQL Server. Does anyone know where
> such a list might exist?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

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