Jump to content

[SOLVED] odbc_connect Command Line it Works, Browser Is Blank


dlebowski

Recommended Posts

All,

 

I have successfully created an ODBC connection from my LINUX web server to a Windows SQL server on our network.  When I run my php code from the command line, it works perfectly.  When I try and pull the same page up in my browser, all I get is a blank page.  Has anyone come across this before?

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html lang="en">
<body>
<?
# connect to a DSN "mssql" with a user and password "mypassword" 
$connect = odbc_connect("mssql", "sa", "mypassword");

# query the users table for name and surname
$query = "SELECT DEPT FROM DEPT";

# perform the query
$result = odbc_exec($connect, $query);

# fetch the data from the database
while(odbc_fetch_row($result))
{
$name = odbc_result($result, 1);
print("$name \n");

}

# close the connection
odbc_close($connect); ?> 
</body>
</html>

Link to comment
Share on other sites

I now am getting this in my browser with debugging turned on:

 

Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][FreeTDS]

Unable to connect to data source, SQL state S1000 in SQLConnect

 

It will works correctly when I run it via the command line.  So this error only occurs when I try to view my page in a browser.  Any ideas at all would be appreciated.  thanks.

 

 

Link to comment
Share on other sites

Yes.  It's giving me this error running my php script via a browser:

 

Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][FreeTDS]

Unable to connect to data source, SQL state S1000 in SQLConnect

 

If I run the php script via the command line on my web server, it works perfect.

Link to comment
Share on other sites

Here is what it looks like when I run my script test.php from the command line:

 

 

[root@webserver aru]# php test.php

PHP Warning:  Module 'mysql' already loaded in Unknown on line 0

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

<html lang="en">

<body>

ADMN-Administration

ADMT-Patient Access - ADT

ADTE-Pt Access- ER ADT

</body>

</html>[root@webserver aru]#

 

 

Now if I browse to it in my browser, it gives me the Warning:.

Link to comment
Share on other sites

I managed to figure out what the problem was SELinux (Centos 5) was preventing apache processes from connecting to a the remote MSSQL server.  This would explain why my shell accounts could run the php scrip fine.

 

I resolved this issue by running:

 

setsebool -P httpd_can_network_connect=1

 

This allowed my web server to connect to my MSSQL server and query the data via ODBC.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.