0

Is it possible to connect to a SQL Server without PDO / sqlsvr extensions? My host does support any SQL Server connections,

i was thinking about a remote page that can do SQL Server stuff and send it to my host, using JSON no idea if this is possible or not

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Janvier123
  • 31
  • 8
  • You can't connect with mssql_connect? – emsoff Jan 14 '14 at 04:23
  • can you specify in what way your host does not support mssql connections ? No driver ? What OS ? – rudi bruchez Jan 14 '14 at 08:02
  • They do not have any support for MSSQL, no PDO, mssql_connect, sqlsvr ... nothing that can connect to a mssql server, only mysql; PS: the run on LINUX – Janvier123 Jan 14 '14 at 13:04
  • Found this => http://stackoverflow.com/questions/6643988/php-to-sql-server-without-odbc-or-mssql-support?rq=1 it does not work – Janvier123 Jan 14 '14 at 20:03
  • Why you dont look for other hosting that support this feature? basically hosting provider provide connect remotely to your database. –  Jan 16 '14 at 05:55
  • Well i used to have an hosting with mssql, but i have 4 domains, so thats 4x hosting costs, therefore i switched to another host that has 1 time server costs and unlimited domains on 1 host so .... – Janvier123 Jan 16 '14 at 12:30

2 Answers2

0

You could put a remote page in between which acts as the connection between the MSSQL server and your webserver. But this remote page has to be hosted on another server, so why not move the whole web application to this other server like Douglas Thomas says?

janhenkes
  • 107
  • 6
0

Yes you can write web services which will communicate with mssql server and then transport data on http for your web application for this you have to maintain both services and web application and sure you donot want to, better is to follow douglas suggestion and find a new hosting.

saqibahmad
  • 962
  • 1
  • 9
  • 18