#13312 [Com]: cant connect to a odbc source
| From: | shuklasanjeev at yahoo dot com | Date: | Sun, 15 Sep 2002 00:30:43 +0000 |
| Subject: | #13312 [Com]: cant connect to a odbc source | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-19367@lists.php.net to get a copy of this message | ||
ID: 13312
Comment by: shuklasanjeev@yahoo.com
Reported By: parabips@hotmail.com
Status: Closed
Bug Type: ODBC related
Operating System: Windows2000 server
PHP Version: 4.0.6
New Comment:
I recently installed php4.2.3 on windows 2000 Advance server SP2.
When I tried to execute the following script:
===========
<?php
$conn = odbc_connect('tlgdevpnr','tlguser','tlguser123');
?>
===========
I received following error:
===========
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified, SQL state IM002 in
SQLConnect in D:\wwwcode\php_codes\odbc_test.php on line 2
===========
The DSN "tlgdevpnr" is System DSN and I am using it with ASP,ColdFusion
and other Applications.
Please let me know if you have any clue.
Thanks.
Previous Comments:
------------------------------------------------------------------------
[2001-09-15 14:19:55] ahill@php.net
This will occur on Windows if you try to use a File DSN
instead of a System DSN - and is expected behavior. Try a
System DSN.
For people searching the bug list, if you experience this
on linux/unix, this will occur if you don't pass the
location of your odbc.ini to your script with a
putenv("ODBCINI=/path/to/odbc.ini");
Best regards,
Andrew Hill
OpenLink Software
------------------------------------------------------------------------
[2001-09-15 04:04:27] parabips@hotmail.com
I tried to connect with a Microsoft Access database but it didnt work.
I made the DSN named reg and then I used the following code to connect
$connection=odbc_connect("reg","admin","") or die ("Cant connect
the
datasource");
$sql="Select * from newuser order by name asc";
$sql_statement=odbc_prepare($connection,$sql) or die ("Cant prepare
statement");
$sql_result=odbc_execute($sql_statement) or die ("Cant execute
query");
odbc_result_all($sql_result,"border=1");
odbc_free-result($sql_result);
odbc_close($connection);
when i view the php page it says
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name
not found
and no default driver specified
can anyone solve my problem
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=13312&edit=1