ODBC connection error

[keimdf]

I am trying to connect to a ODBC database. I have testing the entry in the ODBC Data Source Administrator and it connects just fine.

Now I have written a short script to connect to the database with php.

Here is my code.

// Set the ariables for database access

$Host = "localhost";
$User = "MyName";
$Password = "XXXXXXX";
$DBName = "Irms";
$TableName = "empmst";

$Link = odbc_connect ($Host, $User, $Password);

// $Query = "SELECT * from $TableName";

// odbc_close ($Link);

As you can see, I have commented out the query and close statements. I am concentrating on the connection only.

When I run the script in the browser, I am getting this error.

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in

c:\inetpub\wwwroot\dbconnect.php
on line 16

I am not sure what is going on here.😕 Is there anyone that can help me?

[Tracer]

Ah Ha! I have had this very same problem. I am assuming you are running on a Windows Box. Try running apache 1.3 in a window a user whom has permission to acess the odbc driver.

Running apache as a service on NT WILL NOT ALLOW YOU TO ACESS DATTABSES NOT ON THE SAME PHYSICAL DRIVE AS THE APACHE SERVER VIA ODBC.

Also make sure that your DSN is setup as a system dsn, not user or file.

Let me know if none of the above works.