|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2001-09-15 04:04 UTC] parabips at hotmail dot 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
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Thu May 02 15:01:33 2024 UTC |
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 SoftwareI 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.