The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
I have been using php scripts to access MySQL database with no problems on Freeola.
I have just had a requirement to connect to a SQL server database elsewhere and my initial attempt to connect threw up a worrying messge:
Call to undefined function mssql_connect()
Anyone else in FreeolaLand using this and has experience on
what php commands Freeola is supporting in this field.
I have just had a requirement to connect to a SQL server database elsewhere and my initial attempt to connect threw up a worrying messge:
Call to undefined function mssql_connect()
Anyone else in FreeolaLand using this and has experience on
what php commands Freeola is supporting in this field.
Hi Eccles,
Thanks for your feedback. Could you let me know via email if/when MSSQL can be supported folowing your trials.
Many thanks.
Thanks for your feedback. Could you let me know via email if/when MSSQL can be supported folowing your trials.
Many thanks.
Hello,
Just been doing a quick bit of research on this and there seems to been a free extension we could use called FreeTDS that can be compiled into PHP. I will have to check whether it will be possible to run this and if so some tests will have to be made before it can go live on the VIP hosting servers so please hold off switching to VIP until I can confirm whether we can support MSSQL for you.
The php.net manual is a bit misleading as it fails to mention (even if it is obvious to some) that MSSQL is compiled by default for Windows machines running PHP not for unix machines.
Just been doing a quick bit of research on this and there seems to been a free extension we could use called FreeTDS that can be compiled into PHP. I will have to check whether it will be possible to run this and if so some tests will have to be made before it can go live on the VIP hosting servers so please hold off switching to VIP until I can confirm whether we can support MSSQL for you.
The php.net manual is a bit misleading as it fails to mention (even if it is obvious to some) that MSSQL is compiled by default for Windows machines running PHP not for unix machines.
Hi Eccles,
Thanks for that. I was starting to suspect that was the case. I wilI look into the VIP hosting for that particular website.
Thanks for that. I was starting to suspect that was the case. I wilI look into the VIP hosting for that particular website.
Whilst we don't support MSSQL if you are using our VIP hosting service it may be possible for us to install the PHP MSSQL extension so that you can use PHP MSSQL functions.
If you are using our free hosting then I'm afraid it's MySQL support only.
MSSQL support has to be compile into PHP just as MySQL support does. By default this is not done, hence the lack of mssql_ functions.
If you are using our free hosting then I'm afraid it's MySQL support only.
MSSQL support has to be compile into PHP just as MySQL support does. By default this is not done, hence the lack of mssql_ functions.
The server with the MSSQL database I am trying to access is not on Freeola and so I assumed (perhaps wrongly) that I should still be able to use the approriate PHP commands which should be supported to remotely access the database.
The scenario is I have a website hosted on Freeola which I would like to pull some data to from a SQLSERVER database which is on a server elsewhere. It may be this is not possible (although it should be). PHP includes a variety of commands that may access different databases so I don't understand why I am getting the message I am.
The scenario is I have a website hosted on Freeola which I would like to pull some data to from a SQLSERVER database which is on a server elsewhere. It may be this is not possible (although it should be). PHP includes a variety of commands that may access different databases so I don't understand why I am getting the message I am.
"mssql_connect()"
Is a command for MSSQL rather than MySQL.
I'd of thought the problem would lie there somewhere as we do not support MSSQL, unless I'm missing something.
I'm not too sure about this one but I hope that helps somewhat - our servers are unix-based and thus use MySQL.
Is a command for MSSQL rather than MySQL.
I'd of thought the problem would lie there somewhere as we do not support MSSQL, unless I'm missing something.
I'm not too sure about this one but I hope that helps somewhat - our servers are unix-based and thus use MySQL.
I have been using php scripts to access MySQL database with no problems on Freeola.
I have just had a requirement to connect to a SQL server database elsewhere and my initial attempt to connect threw up a worrying messge:
Call to undefined function mssql_connect()
Anyone else in FreeolaLand using this and has experience on
what php commands Freeola is supporting in this field.
I have just had a requirement to connect to a SQL server database elsewhere and my initial attempt to connect threw up a worrying messge:
Call to undefined function mssql_connect()
Anyone else in FreeolaLand using this and has experience on
what php commands Freeola is supporting in this field.