RE: [PHP] URGENT: IIS server now OK, but MS access DB not reachable

mweb, Are you using a File or User DSN? You DSN "domain" needs to be a working System DSN, succesfully tested in your ODBC Adminsistrator. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: mweb [mailto:mweb@inwind.it] > Sent: Tuesday, December 04, 2001 7:28 AM > To: php-general@lists.php.net > Subject: [PHP] URGENT: IIS server now OK, but MS access DB not reachable > > > Still me. > Thank you all, you were right!! > The sysadmin did find out that the server config was wrong. Now php is OK. > However, I have to access an MS access database with those pages. > The sysadmin says relevant data are: > DSN: domain > Absolute path: c:\domini\domain_name.net\domaindata.mdb > > To give you an idea of the environment, a previous working ASP > version was > like this: > > Set conn = Server.CreateObject("ADODB.Connection") > Set rs = Server.CreateObject("ADODB.Recordset") > conn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & > Server.MapPath(".") & "\domain.mdb; Persist Security Info = False" > > The following snippet of code (copied from phpbuilder) fails as > pasted at the > end of the message. Now this must be even stupider than the other problem, > but again any help is appreciated > > mweb > > ################################################### > > MY CODE: > $DB_PATH="c:\domini\domain_name.net\domaindata.mdb"; > $DSN="domain"; > / > ////////////////////////////////////////////////////////////////// > ////////////// > function Output_Entries() > { > //Make the connection to the database. The syntax is odbc_connect( > 'SYSTEM_DSN' , 'USER', 'PASSWORD' ); > //$cnx will hold the > //pconnect is used to establish a persistent database connection to the > Database > //until the procedure is completed. > $cnx = odbc_connect( $DSN , '', '' ); > ################################################## > > ERROR MESSAGE: > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not > found and no default driver specified, SQL state IM002 > in SQLConnect in C:\domini\domain_name.net\test.php on line 20 > Error in odbc_connect > Warning: Supplied argument is not a valid ODBC-Link resource in > C:\domini\domain_name.net\test.php on line 52 > > Warning: Supplied argument is not a valid ODBC-Link resource in > C:\domini\domain_name.net\test.php on line 52 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >