[SOLVED] Connecting to DB from Virtual Machine

[maliary]

 

 

Hi guys,

 

I have a php program running on a server connecting to a MSSQL server on a different server and the connection works well.

I moved the program to a virtual machine but for some reason there is no database connection any more.

 

Is there a special way to connect to the database from a virtual machine ?

 

Here is the working connection :

 

class mssql

{

var $dbname;

var $server;

var $user;

var $password;

var $connection;

 

/**Constructor**/

function mssql ()

{

$this->dbname='[dbname]';

$this->server='192.168.0.5';

        $this->user='sa';

        $this->password='pass';

 

$this->connection = mssql_connect ($this->server,$this->user,$this->password);

 

if ($this->connection)

{

mssql_select_db ( $this->dbname, $this->connection) or die ( 'Can not select database' );

return $this;

}

return false;

}

 

/**closes the mssql connection**/

function close ()

{

return mssql_close ($this->connection);

}

/**shows the connection status.**/

function toString()

{

print "connected To: ".$this->connection;

}

 

/**performs a query **/

function query ($sql)

{

if ($sql)

{

$results= mssql_query ($sql, $this->connection);

return $results;

}

 

return false;

}

}

[DarkWater]

Verify that you can access the server from the VM, and does the database connection return any errors?

[maliary]

Sorry to bump an old post:

 

Am getting the following error :

Fatal error: Call to undefined function: mssql_connect() in C:\apache2triad\htdocs\care2x\include\care_api_classes\class_mssql.php on line 36

 

and yes I can connect to the server from the VM both by remoting and accessing it via its IP.

[Lamez]

can you post line 36!?

[maliary]

 

Line 36:

 

$this->connection = mssql_connect ($this->server,$this->user,$this->password);

[trq]

Looks like you do not have the mssql extension enabled.

[maliary]

 

How do I enable it ?

[maliary]

 

I have tried this

 

if (function_exists('mssql_fetch_row')) {

echo "MSSQL functions are available.

\n";

} else {

echo "MSSQL functions are not available.

\n";

}

 

and it says MSSQL functions are available.

 

what next ?

[trq]

Take a look at the output from a call to phpinfo(), are you sure its enabled?

 

What OS is within the VM?

[maliary]

 

From the php out put it is enabled.

The OS is Windows server 2003

[maliary]

 

Find attached the phpinfo MSSQL report.

 

[attachment deleted by admin]

[maliary]

 

 

Hi guys,

 

The problem was that I was using an old version of ntwdblib.dll.Which is  Version 2000.2.8.0. This doesn't work very well with MSSQL 2005 so I downloaded ntwdblib.dll 2000.80.194.0 which worked.

 

I've seen several unanswered posts and I think this could be the solution to them. So guys, I wouldn't want you wandering in the internet jungle like I did, give yourself some peace and download this.