ODBC Not Working

shuklasanjeev

Hi,
I am trying to connect to MSAccess database using ODBC but getting 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 D:\wwwcode\php_codes\odbc_test.php on line 15

Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in D:\wwwcode\php_codes\odbc_test.php on line 30

I am using following script to access the database:

<?php

//connect to the database 
$connectionstring = odbc_connect("testdsn","",""); 
odbc_close($connectionstring);

This is System DSN and works fine in ASP and Coldfusion.

Please advise how to resolve this.

Thanks.

dotwebbie

If that's your entire script, why in the world is it saying that there are errors on lines 15 and 30?

<?php
$conn=odbc_connect("testdsn", " ", " ");
odbc_close($conn);
?>

Try that. Make sure that there are no spaces before or after the opening and closing marks.
After doing a little reading up at php.net, I found this:

Beware that when creating DSN under win32, you must make them comp DSN not user DSN. Since the httpd is ran as a system service, not as the current user, the service won't see the DSN you, as a user, have created. I know it's simple, it's logical afterward, but I lost so much time asking myself why it didn't work, that I decided to post this hint to avoid this hassle to anyone else.

Also, this:

for iodbc+openlink to connect to SQL 7 on NT from Linux+php3
I had to put the UID and PWD into the DSN string otherwise it wont recognise the username and password:
odbc_connect("DSN=DataSource","username","password"); doesnt see user or password

but

odbc_connect("DSN=DataSource;UID=UserName;PWD=Password","","");

works fine

shuklasanjeev

Hi,
There are other lines as well, which have been commented, thats why the error message shows line 15.

Following is the full script :

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>
<title>PHP ODBC Check</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php
$connectionstring = odbc_connect("testdsn","","");
//odbc_close($connectionstring);

?>

</body>

</html>

And following is the 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 D:\wwwcode\php_codes\odbc_test.php on line 13

And there is no space beteen opening and closing bracket in odbc_connect syntax.

Please let me know if you have any other clue.

ONE MORE INFO : I AM RUNNING THIS SCRIPT IN
WINDOWS 2000 ADVANCE SERVER SP2/ IIS5.0 / IE5.5

Thanks.

dotwebbie

Hm . . .
Okay, try

<?php
$conn=odbc_connect("DSN=testdsn","","");
odbc_close($conn);
?>

Be sure to put the DSN=testdsn in.

shuklasanjeev

🙁
Thanks.
But I still get the same error.

I have seen this error reported by a lot of people in other forum as well, so looks like a common missing parameter or setting.

dotwebbie

For once I wish I actually had worked with ODBC . . . Here's a thought, after looking through phpBB's dbal, I found nothing different. So try adding a username and password. Worth a try at least . . .

shuklasanjeev

I do not have any username and password for MSAccess DSN.

Thanks.

dotwebbie

I know, set one.

shuklasanjeev

Guys,
I guess I have found the bug:

If you install PHP4.2.3 from self install file and use it under Windows 2000 Advance Server / IIS 5.0 Then ODBC function of PHP does not work.

I replaced IIS5.0 with Apache2.0 on Windows 2000 Advance Server, and it worked.

So, we have to check the php4.2.3 buglist for this issue.

Thanks to everybody for trying to help me out.

dotwebbie

The self-install (the .exe if that's what you are referring to . . .) is for cgi only. The zip file let's you use mod_php which may or may not have the same problem . . . Have you tried mod_php?

shuklasanjeev

Hi,
I did try with zipped version of php4.2.3 and tried both php.exe as well as php4isapi.dll under IIS5.
But nothing worked.

I didn't try mod_php, because I think that works only under apache.

Thanks.

dotwebbie

Yes, I thought I saw Apache in there somewhere. Sorry, my fault.