RE: [PHP-DB] Driver for connecting SQL server

Also, ensure that this is a System DSN. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Frank M. Kromann [mailto:frank@frontbase.com] > Sent: Monday, October 01, 2001 2:44 PM > To: LeTortorec, Jean-Louis > Cc: 'php-db@lists.php.net' > Subject: Re: [PHP-DB] Driver for connecting SQL server > > > > Hi > > Try to remobe 'DNS=' from the connect > > $conn=odbc_connect("dnsname","userid","password"); > > should do the trick. > > - Frank > > > Hi: > > > > I'm trying to establish a connection with SQL 7.0. > > > > My system runs W2000, Apache, PHP4. I created a DNS odbc file (with MS > > Access) and checked that the connection can be established. > > > > Then, my php script is as follow: > > $conn=odbc_connect("DNS=dnsname","userid","password"); > > > > When I execute the script, I get the following 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:\apache\intranet\default.php on line 6. > > > > How can I specify the missing driver? Should I install something? > > > > > > Thanks for your help. > > > > JL > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >