How do you connect your own websites to SQL Server?

[LarvasFaint]

I'll take a look then. Thanks for the info!
Edit: Just realized my app is running on CentOS not linux... saddly.

CentOS is a linux distribution

[LordFede]

CentOS is a linux distribution

Yes but no. I'm running CentOS 6, the driver is for Red Hat 7 / CentOS 7

[SouLSet]

pdo_dblib

[LordFede]

pdo_dblib

Yes, I've seen that one back when I was developing on php5.4. But now, it seems obsolete

If it is not possible to use SqlSrv, you can use the PDO_ODBC driver to connect to Microsoft SQL Server and Sybase databases, as the native Windows DB-LIB is ancient, thread un-safe and no longer supported by Microsoft.

[RevolGaming]

odbc dont work on remote host, its for fast LAN connection, not for remote..

[LordFede]

odbc dont work on remote host, its for fast LAN connection, not for remote..

Any source? I can actually connect to my remote host using odbc driver from my windows 7 PC actually.

[RevolGaming]

Any source? I can actually connect to my remote host using odbc driver from my windows 7 PC actually.

I mean.... its for fast lan connection not for remote... ofc it will work, but its not for WORK you know...

Its not for to make a live and stable connection remote. php_pdo is for that.

php_pdo is the new php_mssql, thats it all.

[navossoc]

I think you're talking about this one https://github.com/Microsoft/msphpsql#known-issues


Inventories' data type is varbinary, and they are pretty lengthy. So I think we can't use that for mu db yet.

I don't think you read the known issues in a proper way...

Linux

• The following features are not supported with connection pooling:
  
  • Unicode connection strings
  • sqlsrv_server_info and sqlsrv_client_info return false
  • In certain scenarios a generic error message maybe returned instead of a specific error when pooling is disabled
  • When retrieving data from columns with a data type of XML, varchar(max), nvarchar(max), or varbinary(max) no data maybe returned or the data maybe truncated depending on the length of the data in the source table.

First of all, this limitation applies only to connection pooling.
Also, varbinary(max) is not used anywhere in the database.

FYI: varbinary(max) are stored out of the row only if they exceed 8000 bytes otherwise it is the same as varbinary(8000).

So, no harm done here...