Re: Hi,I have an idea of no DSN to use access,but i faild.

Thank you very much. But i think it will cause a error as: $dbc = new COM("ADODB"); The ADODB will not be a object. Any advice ? Christine Green ----- Original Message ----- From: "Jason Gan" <hspace@ihug.com.au> To: <php-windows@lists.php.net> Cc: <christine19990815@163.net> Sent: Friday, September 08, 2000 10:23 PM Subject: RE: [PHP-WIN] Hi,I have an idea of no DSN to use access,but i faild. > Hi Christine Green, > > I'd like to say that David Coulter was on the right track (see previous > messages below), > except that you are not allowed to use the dot . which is a > VBScript/JScript/Java way of referencing objects and methods. > In C++ and PHP you *MUST* use -> instead when referencing objects and > methods. > Try -> and think about PHP being an expression-based language... > Your code should look like this instead - > > $dbc = new COM("ADODB"); > $dbc -> $Connection -> Open($connString); // the $Connection object might be > instantiated in the ADODB object (????) > // then call the Open method of the $Connection object (has it been > instantiated???) > > or something like that. Correct me if I'm wrong but you cannot use the > Java-like dot notation. > I'm sorry I can't be of much help, but I haven't played around with PHP COM > and I will never do so because it's just not the way to go. COM is not > reliable and can crash IIS. If you want to do distributed apps it is better > to instantiate Java servlets in PHP. Java runs inside a JVM and is > protected/isolated from IIS. > > Good Luck. > > > > -----Original Message----- > From: Christine Green [mailto:christine19990815@163.net] > Sent: Friday, 8 September 2000 12:54 PM > To: David Coulter > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] Hi,I have an idea of no DSN to use access,but i > faild. > > > Thank you ! > But i got error as : > > Warning: Invoke() failed: in F:\php\program\ado\access.php on line 4 > Warning: Invoke() failed: in F:\php\program\ado\access.php on line 7 > > My php code is: > > <? > $connString = > "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=F:\\WINNT\\system32\\ias\\dnary > mdb"; > $dbc = new COM("ADODB.Connection"); > $dbc->Open($connString); > $sqlString = "SELECT * FROM Vendors"; > $rs = new COM("ADODB.Recordset"); > $rs->Open($sqlstring, $dbc, 3, 3); > ?> > > > > > ----- Original Message ----- > From: "David Coulter" <david@luminarytech.com> > To: "Christine Green" <christine19990815@163.net> > Sent: Thursday, September 07, 2000 10:58 PM > Subject: Re: [PHP-WIN] Hi,I have an idea of no DSN to use access,but i > faild. > > > > Well, I'll take a shot at this... I know how to do it in ASP so this might > > work. :) > > > > <? > > $connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data > > Source=d:\inetpub\wwwroot\news.mdb" > > $dbc = new COM("ADODB.Connection"); > > $dbc->Open $connString > > $sqlString = "SELECT * FROM Vendors"; > > $rs = new COM("ADODB.Recordset"); > > $rs->Open $sqlstring, $dbc, 3, 3 > > file://do whatever with the array of the recordset > > ?> > > > > Like I said though, this is what it looks like written in ASP, but with > the > > PHP syntax. I could be totally off. Hope it helps though. :) > > > > David Coulter > > > > Christine Green wrote: > > > > > Hi all,i have an idea to use access and not config dsn, > > > but i don't know to how to do. > > > exa: > > > <? > > > $cnpath = "DBQ=F:\\WINNT\\system32\\ias\\dnary.mdb"; > > > $driver = "DRIVER={Microsoft Access Driver (*.mdb)};"; > > > $pr = $driver.$cnpath; > > > > > > $dbc = new COM("ADODB.Connection"); > > > $dbc->Provider = $pr; > > > $dbc->Open("nwind"); > > > $rs = $dbc->Execute("select * from Vendors"); > > > ... ... > > > > > > ?> > > > But i get a error and the ie will close, > > > i don't know what cause that. > > > > > > Any advice ? > > > > > > Christine Green > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-windows-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > >