SQL Connection

[obrienkev]

Hi all,

I am using the following to connect to MS SQL Server Database...

$db = mssql_pconnect('db_name', 'user1', 'pass1');

However, sometimes data is not displayed so I'm thinking it is to do with the connection.
If I press Refresh a few times it works.

Any ideas why this is?

Thanks.

[thorpe]

What (if any) debugging techniques have you tried? Is there any particular reason your using mssql_pconnect() and not mssql_connect()?

[chernyshevsky]

obrienkev wrote:

Hi all,

I am using the following to connect to MS SQL Server Database...

$db = mssql_pconnect('db_name', 'user1', 'pass1');

However, sometimes data is not displayed so I'm thinking it is to do with the connection.
If I press Refresh a few times it works.

Any ideas why this is?

Thanks.

It's a probably a licensing issue. The developer version of MSSQL is limited to a small number of concurrent connections. If you use mssql_pconnect(), some server threads will fail to get a connection. Switch to mssql_connect() and the problem should go away.