• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to Connect to MsSQL

[eluser]Obasi George[/eluser]
Good Day folks,

I have recently started to port some applications over to CI, but there seems to be a stumbling block at the moment.

Q: How do you connect to a MsSQL server that is not on the standard port?

I have already added the port to the database array (does not work), and don't want to use an ODBC connection.

Any ideas will be welcomed.

You'll set it as part of the hostname (the mssql driver doesn't handle port as it should from the looks of it).

['hostname'] = "" for example, would connect to port "1234". ":port"

[eluser]Obasi George[/eluser]
I tried that one first.

No dice. Then I checked the PHP configuration and it works just fine with ADOdb.

Will have to do something else I suppose.

Silly question -- you set PHP up to use MsSQL right (client tools on windows/freetds on linux)? We had this problem when we migrated to mssql originally.

[eluser]Obasi George[/eluser]
Most definitely a silly question, but one non the less.

Yes it has been setup, and works great with the ADOdb library.

[eluser]Obasi George[/eluser]
I gave up and did the odbc connect, it works just fine.

Will work in the other connection over the weekend. Thanks much guys for your assistance.

why use mssql? mysql is so much better!

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.