I need connect to external MSSQL DB, I have installed MSSQL driver. And the connection info is:

uri: mssql://erpcristalylavisa.dyndns.org:1234/ERPCRISTAL
user: dadosprep
password:
Database: dadosprep

But then, I find this error:

Warning: mssql_connect(): Unable to connect to server: mssql://erpcristalylavisa.dyndns.org:1234/ERPCRISTAL en FrxMSSQL->__construct() (línea 38 de home/newwweb/public_html/tequilasdenuestratierra/boutique/sites/all/modules/forena/plugins/FrxMSSQL.inc).

What is that I do wrong?

CommentFileSizeAuthor
error-mssql.connection.jpg162.58 KBMontserramia
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

metzlerd’s picture

metzlerd CreditAttribution: metzlerd commented

uri for MSSQL native php driver support should look similar to what you'd pass to the mssql_connect php function. It looks like you are using a PDO style connection string, but a native MSSQL query. The correct uri depends on your freetds configuration when using unix. You might check #1919362: Connection to external MS SQL database for more information. Some are having success using ODBC PDO data connections to get to the mssql database.

metzlerd’s picture

metzlerd CreditAttribution: metzlerd commented
Issue summary: View changes
Status: Active » Closed (cannot reproduce)

It's been a few months without any feedback... assuming this was resolved or else the user moved on without forena?

abid koodathai’s picture

abid koodathai CreditAttribution: abid koodathai commented

Mr metzlerd.... You Got any ideas.........
did you complete this work??....... pls help me