Re: Re: odbc_connect

I've got this working great on PHP4.02 and NT4(SP5) - remembering to use SystemDSN, but I've noticed that I can't use files that are not on the webserver - eg a file on a separate Novell Netware 5 File Server. Any reason for this? I'm short of space for copying some of the bigger databases to the web server. If I used MS Client would that help? Derek ----- Original Message ----- From: "Gonzalo Vera" <gvz@eucalipto.net> To: "Warwick Chapman (Budgee)" <Budgee@ghs.kzn.school.za> Cc: "Giuseppe D'Ambrosio" <da_g@altavista.com>; <php-windows@lists.php.net> Sent: 31 August 2000 15:32 Subject: Re: [PHP-WIN] Re: odbc_connect > > 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"); > > I don't know if this works, but it certainly is cleaner if you go to > ODBC configuration in the control panel and register a DSN ("user" if > using Win95/98, "system" on NT/2000). Then just use that name in the > odbc_connect, like: > > > $conn=odbc_connect("alumni","inet","inet"); > > The DSN you register in the control panel ODBC applet will have all > the information needed for the connecton to be made, so you only need > to specify that name. > > Gonzalo. > > > > -- > 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 > >