Re: Access ODBC database w/o User/Password

From: Date: Tue, 10 Oct 2000 14:25:15 +0000
Subject: Re: Access ODBC database w/o User/Password
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-19355@lists.php.net to get a copy of this message
"Felipe G. Coury" wrote: > > Hi, > > How can I access an (Access) database without user and password? > > I am trying: > > $conn = odbc_connect( "DBQ=c:\clientes ativos\guia > campinas\campinas\access\guiacampinas.mdb;Driver={Microsoft Access Driver > (*.mdb)}", null, null ); Weird connect statement. Did you create a system DSN name for your guiacampinas.mdb database? If so, just call the DSN by that name rather than the full path you're using. Here's an example of a connect statement I'm using: $Connection = @odbc_connect("AccessStats", "", "", "SQL_CUR_USE_ODBC"); Enjoy, --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409

« previous php.general (#19355) next »