Nithin, This issue is due to the ODBCINI environment variable not being set by in your PHP script, or the odbc.ini file that variable points to not being readable by the user that Apache runs as. Check out the PHP-ODBC-HOWTO at www.iodbc.org for examples of what environment variables need to be set to connect properly. Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Thursday, October 24, 2002, at 10:24 AM, Poduval, Nithin wrote: > Hi All, > We are also facing a problem in connecting PHP with database, > We are trying to access the MS SQL Server 2000 which runs on Windows > 2000 > from the php in the Linux 7.2. > During access the php, it gives the followin message. > Warning: SQL error: [iODBC][Driver Manager]Data source name not found > and no > default driver specified. Driver could not be loaded, SQL state IM002 > in > We do followed all the step done by you. > We would like to know how did you solve the issue. We have been using > the > Openlink database driver.Please help in this issue. > Thanks In Advance. > With Regards, > Nithin > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php