MSSQL database connection

Please could someone offer some advise. I am developing on Mac OSX and up until now using MySQL which is fine, however i have a specific requirement to connect to MSSQL database and i am now starting to struggle, when using the MSSQL Server DBMS Driver i get the following error when trying to connect.

Connection Error

mssql_connect(): Unable to connect to server: 10.5.1.102

I have tested the connection credentials and all are correct.

I would be most grateful for some help and advice.

Thanks.

Has ser ver ports opened? Maybe some firewall locking connection?

The SQL Server is on the same subnet there is no firewall involved. Are there any MSSQL drivers needed to connect ?

Are you using Scriptcase conneon manager or is it a connection string made on your own? If the latest, share your connection string.

regards

I am connecting to the database using the Scriptcase connection manager.

I assume that you have the right licence to use SQL Server. Try to connect to this server by writing a few lines of code. If that works then it’s likely a SC problem. We have an enterprise licence and connection to sqlserver is running w.o. problems, even in combination with oracle.

Wich kind of connection are you using?

http://support.scriptcase.net/index.php?/Knowledgebase/Article/View/637/0/connection-with-mssql-database

Ok … I have the enterprise version of script case installed on a MAC running yosemite. I have attempted to use the scriptcase MSSQL Server connection option but get

mssql_connect(): Unable to connect to server: 10.5.1.102.

In addition I have installed and verified the FreeTDS and can verify and connect to an MSSQL server via terminal . However i cannot get Scriptcase to connect. I just don’t know what i am missing and where.

I have installed SC on a windows PC and all works fine but i would rather not commit such a sin and move to the dark side !!!

I would be most grateful for any advice.

Thanks

lmfao… the dark side… lol… come on Luke… you know you wanna use that dirty windowsy hard drive. lmfao.

Hmm I found one reference that may be usefull:
http://www.glatter-gotz.com/blog/2011/06/06/connecting-to-microsoft-sql-server-from-php-on-osx-and-xampp/
But I havent tested it at all.
Be aware that you then also have to set the proper rights for homebrew.

Maybe this one: http://stackoverflow.com/questions/13371281/how-can-i-connect-to-sql-server-from-a-mac-with-php-pdo

I suggest you make a simple connection with straight php first before trying scriptcase. Specially since OSX kinda blocks various stuff since php and so is not an officially OSX certified which you may need to set by hand as well.

I found a link here: http://lkrms.org/php-with-freetds-on-os-x-mavericks/