mssql_pconnect

So far, all my database programming in php has been with a mysql database.
I need to connect to a SQL Server database. I looked in the manual and it
seemed rather easy. It seemed that all I had to do was replace mysql with
mssql everywhere I had coded before.

So, naturally, on my first call which was to mssql_pconnect I received the
following message:

Fatal error: Call to undefined function mssql_pconnect()

Now I must say that php was not previously installed on this server. I had
the admin fellow install it (and this was his first time). Are the
database routines some sort of additional installation that simply haven't
been installed?

Thanks for any help

Shely

Re: mssql_pconnect

Shelly wrote:
> So far, all my database programming in php has been with a mysql database.
> I need to connect to a SQL Server database. I looked in the manual and it
> seemed rather easy. It seemed that all I had to do was replace mysql with
> mssql everywhere I had coded before.
>
> So, naturally, on my first call which was to mssql_pconnect I received the
> following message:
>
> Fatal error: Call to undefined function mssql_pconnect()
>
> Now I must say that php was not previously installed on this server. I had
> the admin fellow install it (and this was his first time). Are the
> database routines some sort of additional installation that simply haven't
> been installed?
>
> Thanks for any help
>
> Shely
>
>
uncomment the php_mssql.dll in the extensions section of php.ini
(assuming you're using a windows box) or recompile using --with-mssql if
using Linux.

-david-

Re: mssql_pconnect

Shelly wrote:
> So far, all my database programming in php has been with a mysql database.
> I need to connect to a SQL Server database. I looked in the manual and it
> seemed rather easy. It seemed that all I had to do was replace mysql with
> mssql everywhere I had coded before.
>
> So, naturally, on my first call which was to mssql_pconnect I received the
> following message:
>
> Fatal error: Call to undefined function mssql_pconnect()
>
> Now I must say that php was not previously installed on this server. I had
> the admin fellow install it (and this was his first time). Are the
> database routines some sort of additional installation that simply haven't
> been installed?
>
> Thanks for any help
>
> Shely
>
>
uncomment the php_mssql.dll in the extensions section of php.ini
(assuming you're using a windows box) or recompile using --with-mssql if
using Linux.

-david-

Re: mssql_pconnect

Shelly wrote:

> So far, all my database programming in php has been with a mysql database.
> I need to connect to a SQL Server database. I looked in the manual and it
> seemed rather easy. It seemed that all I had to do was replace mysql with
> mssql everywhere I had coded before.
>
> So, naturally, on my first call which was to mssql_pconnect I received the
> following message:
>
> Fatal error: Call to undefined function mssql_pconnect()
>
> Now I must say that php was not previously installed on this server. I had
> the admin fellow install it (and this was his first time). Are the
> database routines some sort of additional installation that simply haven't
> been installed?
>
> Thanks for any help
>
> Shely
>
>

It would help if we knew what platform/webserver you are using but a first guess
would be to check your PHP.INI file to make sure that you are loading the MSSQL
module.

--
Michael Austin.
DBA Consultant
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

Re: mssql_pconnect

Shelly wrote:

> So far, all my database programming in php has been with a mysql database.
> I need to connect to a SQL Server database. I looked in the manual and it
> seemed rather easy. It seemed that all I had to do was replace mysql with
> mssql everywhere I had coded before.
>
> So, naturally, on my first call which was to mssql_pconnect I received the
> following message:
>
> Fatal error: Call to undefined function mssql_pconnect()
>
> Now I must say that php was not previously installed on this server. I had
> the admin fellow install it (and this was his first time). Are the
> database routines some sort of additional installation that simply haven't
> been installed?
>
> Thanks for any help
>
> Shely
>
>

It would help if we knew what platform/webserver you are using but a first guess
would be to check your PHP.INI file to make sure that you are loading the MSSQL
module.

--
Michael Austin.
DBA Consultant
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

Re: mssql_pconnect

"Michael Austin" wrote in message
news:PnkJf.29504$Jd.22540@newssvr25.news.prodigy.net...

> It would help if we knew what platform/webserver you are using but a first
> guess would be to check your PHP.INI file to make sure that you are
> loading the MSSQL module.

He loaded the mssql, but did something wrong. It now says:


Fatal error: Call to undefined function mssql_pconnect() in
E:\mysite\sqlLoginNewDB.php on line 9
PHP Warning: PHP Startup: Unable to load dynamic library './php_mssql.dll' -
The specified module could not be found. in Unknown on line 0

Re: mssql_pconnect

"Michael Austin" wrote in message
news:PnkJf.29504$Jd.22540@newssvr25.news.prodigy.net...

> It would help if we knew what platform/webserver you are using but a first
> guess would be to check your PHP.INI file to make sure that you are
> loading the MSSQL module.

He loaded the mssql, but did something wrong. It now says:


Fatal error: Call to undefined function mssql_pconnect() in
E:\mysite\sqlLoginNewDB.php on line 9
PHP Warning: PHP Startup: Unable to load dynamic library './php_mssql.dll' -
The specified module could not be found. in Unknown on line 0

Re: mssql_pconnect

Shelly wrote:
> "Michael Austin" wrote in message
> news:PnkJf.29504$Jd.22540@newssvr25.news.prodigy.net...
>
>> It would help if we knew what platform/webserver you are using but a first
>> guess would be to check your PHP.INI file to make sure that you are
>> loading the MSSQL module.
>
> He loaded the mssql, but did something wrong. It now says:
>
>
> Fatal error: Call to undefined function mssql_pconnect() in
> E:\mysite\sqlLoginNewDB.php on line 9
> PHP Warning: PHP Startup: Unable to load dynamic library './php_mssql.dll' -
> The specified module could not be found. in Unknown on line 0
>
>
>
Two things:
1. in php.ini there is a tag named 'extension_dir'. This needs to point
to the 'ext' directory of wherever you installed php.
2. there is a diagnostic you can run that will tell you all about how
the system is set up (and will help us diagnose things for you). Simply
create a file with the following contents: and run it.

-david-

Re: mssql_pconnect

Shelly wrote:
> "Michael Austin" wrote in message
> news:PnkJf.29504$Jd.22540@newssvr25.news.prodigy.net...
>
>> It would help if we knew what platform/webserver you are using but a first
>> guess would be to check your PHP.INI file to make sure that you are
>> loading the MSSQL module.
>
> He loaded the mssql, but did something wrong. It now says:
>
>
> Fatal error: Call to undefined function mssql_pconnect() in
> E:\mysite\sqlLoginNewDB.php on line 9
> PHP Warning: PHP Startup: Unable to load dynamic library './php_mssql.dll' -
> The specified module could not be found. in Unknown on line 0
>
>
>
Two things:
1. in php.ini there is a tag named 'extension_dir'. This needs to point
to the 'ext' directory of wherever you installed php.
2. there is a diagnostic you can run that will tell you all about how
the system is set up (and will help us diagnose things for you). Simply
create a file with the following contents: and run it.

-david-