You must set up the ODBC source you want access to. Go to control panel, administrative tools, ODBC ... (if you haven't done this already).
Go to the DSN tab and create a new datasource there. Are you familiar with this? If you need further help setting up an ODBC source, let me know. After creating this source, you can then use it through your PHP scripts. hope that helps any. ~Nicole Amashta www.aeontrek.com "Bill Seeley" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > When attempting to query an Access 2K DB with the odbc_connect function, I > get the messsage: > > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not > found and no default driver specified, SQL state IM002 in SQLConnect in > e:\vnpweb\html\getcontact.php on line 14 IM002 > > I have tried both the CGI (installer version) and ISAPI versions of PHP > 4.1.1 (manual install) and get the same messages. I am able to access this > same data source name with Crystal Reports and was previously able to access > it with a PHP script under an Apache server (php4apache.dll version) on the > same machine. I've enabled both ODBC and PHP logging, but PHP logging > doesn't give me any more than the above messages. Curiously the ODBC log is > empty, even though the above messages would indicate that the MS ODBC driver > returned a legitimate error code. > > Has anyone seen anything like this and can you offer any suggestions? > > Thanks, Bill Seeley > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
