RE: [PHP-WIN] Re: odbc_connect

Actually, I just use the database name. Once I had it set up in the ODBC Datasources control panel, it works anywhere for me... My datasource is on the webserver itself, so when I get to hitting databases that are not on the webserver, I may be coming to you! It would be much more helpful to have the actual error message though instead of "Can't do it..." doesn't really tell us much... John --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer - http://www.lcounty.com - CHECK OUT THE NEW LOOK! Licking County, Ohio, USA 740-349-3631 > -----Original Message----- > From: Warwick Chapman (Budgee) [mailto:Budgee@ghs.kzn.school.za] > Sent: Thursday, August 31, 2000 4:57 AM > To: Giuseppe D'Ambrosio; php-windows@lists.php.net > Subject: [PHP-WIN] Re: odbc_connect > > > Howdy > > Please gimme a hand here. > > What do I use for the DSN? I have tried the dbname I also tired the > same DSN that the asp code uses (below): > > <? > > $conn=odbc_connect("DRIVER={Microsoft Access Driver > (*.mdb)};DBQ=c:\inetpub\wwwroot\phpodbc\ghs.mdb","inet","inet"); > $c1=odbc_exec($conn,"select * from oldboys1930 order by > year,lastname"); > odbc_result_all($c1,"border"); > odbc_close($conn); > > ?> > > Can't do it... :( > > Thanks > > Warwick Chapman (1999) > Assistant IT Manager > Glenwood High School, Durban, South Africa > 031 2055241 > 083 7797094 > www.glenwoodhighschool.co.za > > -- > 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 >