Connect to MS SQL server?

Squiz Matrix General Discussion
1

Hi All,


Can someone let me know what connection string I could use to connect to a network MS SQL server in a DBConnector?

I'm running the new version of Matrix from the virtual machine image. Do I need to set any other settings? like in PHP?



Many Thanks!

2

[quote]
Hi All,



Can someone let me know what connection string I could use to connect to a network MS SQL server in a DBConnector?

I'm running the new version of Matrix from the virtual machine image. Do I need to set any other settings? like in PHP?



Many Thanks!

[/quote]



add this: http://download.fedora.redhat.com/pub/epel/5/x86_64/repoview/php-mssql.html



then 'dblib' becomes available to use in the DSN eg.



[sql]dblib:host=myhost.com;dbname=mydb;charset=UTF-8[/sql]



There are caveats that its 'experimental' and that you might be better off using the pdo_obdc driver instead… but it does work.



K