Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #16744 > unrolled thread

PHP and SQL SERVER

Back to article view | Back to comp.lang.php

Contents

  PHP and SQL SERVER michele.braccini@gmail.com - 2016-05-02 13:51 -0700
    Re: PHP and SQL SERVER Jerry Stuckle <jstucklex@attglobal.net> - 2016-05-02 20:03 -0400
      Re: PHP and SQL SERVER Luuk <luuk@invalid.lan> - 2016-05-08 19:46 +0200
    Re: PHP and SQL SERVER info@aadhocc.com - 2016-05-06 01:01 -0700
    Re: PHP and SQL SERVER Arno Welzel <usenet@arnowelzel.de> - 2016-05-08 19:08 +0200
      Re: PHP and SQL SERVER Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-05-09 00:27 +0200
        Re: PHP and SQL SERVER Erwin Moller <erwinmollerusenet@xs4all.nl> - 2016-05-27 11:24 +0200

#16744 — PHP and SQL SERVER

I developed a small script in php some years ago (2007)
This script connected to MS Sql Server using mssql_* function on windows with a simple installation of XAMPP.

It has worked for many years.

Then, some days ago, the server has changed (now there is SQL Server 2014) and now the script  doesn't work. But It can't connect to sql server.

Are mssql_* a good solution to connect to sql server today ? Are there better and so simple technology ?

Thank you 
m.

[toc] | [next] | [standalone]

#16745

On 5/2/2016 4:51 PM, michele.braccini@gmail.com wrote:
> I developed a small script in php some years ago (2007)
> This script connected to MS Sql Server using mssql_* function on windows with a simple installation of XAMPP.
> 
> It has worked for many years.
> 
> Then, some days ago, the server has changed (now there is SQL Server 2014) and now the script  doesn't work. But It can't connect to sql server.
> 
> Are mssql_* a good solution to connect to sql server today ? Are there better and so simple technology ?
> 
> Thank you 
> m.
> 

For starters: What version of PHP are you using?  What errors do you
get?  Why can't you connect to SQL Server?

Way too little information for an intelligent response.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#16748

On 03-05-16 02:03, Jerry Stuckle wrote:
> On 5/2/2016 4:51 PM, michele.braccini@gmail.com wrote:
>> I developed a small script in php some years ago (2007)
>> This script connected to MS Sql Server using mssql_* function on windows with a simple installation of XAMPP.
>>
>> It has worked for many years.
>>
>> Then, some days ago, the server has changed (now there is SQL Server 2014) and now the script  doesn't work. But It can't connect to sql server.
>>
>> Are mssql_* a good solution to connect to sql server today ? Are there better and so simple technology ?
>>
>> Thank you
>> m.
>>
>
> For starters: What version of PHP are you using?  What errors do you
> get?  Why can't you connect to SQL Server?
>
> Way too little information for an intelligent response.
>

This gives more than enough info to know that OP has a problem....

http://php.net/manual/en/mssql.requirements.php

Before their database was migrated to 'SQL Server 2014' they should have 
made a good impact analysys.

They never answered the question, 'What application do make use of this 
database that we are going to upgrade'.

But, because it's a small script, you can always rewrite it with current 
version (see link).

[toc] | [prev] | [next] | [standalone]

#16746

Please contact Aadhocc Software Consultants for Print client from Browser to Dot matrix solution +91 9747205205



On Tuesday, May 3, 2016 at 2:21:54 AM UTC+5:30, Michele Braccini wrote:
> I developed a small script in php some years ago (2007)
> This script connected to MS Sql Server using mssql_* function on windows with a simple installation of XAMPP.
> 
> It has worked for many years.
> 
> Then, some days ago, the server has changed (now there is SQL Server 2014) and now the script  doesn't work. But It can't connect to sql server.
> 
> Are mssql_* a good solution to connect to sql server today ? Are there better and so simple technology ?
> 
> Thank you 
> m.

[toc] | [prev] | [next] | [standalone]

#16747

michele.braccini@gmail.com schrieb am 02.05.2016 um 22:51:

[...]
> Are mssql_* a good solution to connect to sql server today ? Are
> there better and so simple technology ?

Either use ODBC:

<http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html>

Or if the webserver runs in Windows as well:

<https://msdn.microsoft.com/en-us/library/cc296172%28v=sql.105%29.aspx>


-- 
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de
http://fahrradzukunft.de

[toc] | [prev] | [next] | [standalone]

#16749

Arno Welzel wrote:

> michele.braccini@gmail.com schrieb am 02.05.2016 um 22:51:
> [...]
>> Are mssql_* a good solution to connect to sql server today ? Are
>> there better and so simple technology ?
> 
> Either use ODBC:
> 
> 
<http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html>
> 
> Or if the webserver runs in Windows as well:
> 
> <https://msdn.microsoft.com/en-us/library/cc296172%28v=sql.105%29.aspx>

As you can see there, the source code of the “Microsoft PHP Driver for SQL 
Server”, including one variant that is PDO-based, is available on GitHub, 
so, in theory, there should be no need to use the cumbersome low-level ODBC 
PHP driver directly for MS SQL database access anymore.

<https://github.com/azure/msphpsql>

-- 
PointedEars
Zend Certified PHP Engineer 
<http://www.zend.com/en/yellow-pages/ZEND024953> | Twitter: @PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.

[toc] | [prev] | [next] | [standalone]

#16750

On 5/9/2016 12:27 AM, Thomas 'PointedEars' Lahn wrote:
> Arno Welzel wrote:
>
>> michele.braccini@gmail.com schrieb am 02.05.2016 um 22:51:
>> [...]
>>> Are mssql_* a good solution to connect to sql server today ? Are
>>> there better and so simple technology ?
>>
>> Either use ODBC:
>>
>>
> <http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html>
>>
>> Or if the webserver runs in Windows as well:
>>
>> <https://msdn.microsoft.com/en-us/library/cc296172%28v=sql.105%29.aspx>
>
> As you can see there, the source code of the “Microsoft PHP Driver for SQL
> Server”, including one variant that is PDO-based, is available on GitHub,
> so, in theory, there should be no need to use the cumbersome low-level ODBC
> PHP driver directly for MS SQL database access anymore.
>
> <https://github.com/azure/msphpsql>
>

Good advice.
Use “Microsoft PHP Driver for SQL Server”.
Maybe upgrade your PHP install too.

Might be some work to get things running again. :-)
Good luck.

Regards,
Erwin Moller


-- 
"That which can be asserted without evidence, can be dismissed without 
evidence."
-- Christopher Hitchens

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web