Call to undefined function mssql_connect [#957468]

First of all, thank you for this module. I've only been using it for two days and it's already saved me tons of time!

Anyway, I'm trying to write a migration from MSSQLServer using the MigrateSourceMSSQL class. I've enabled mssql support in PHP and have verified using a non-Drupal .php script that I can, in fact, connect to an MSSQL DB. Actually, I've even created a Drupal module that connects to and displays data from this DB using mssql_connect, etc. However, when I try to use migrate module, I get an error "Call to undefined function mssql_connect() in c:\www\portal\sites\all\modules\contrib\migrate\plugins\sources\mssql.inc on line 106." What do I need to do to get mssql connections working?

Thanks!

Comments

Comment #1

moshe weitzman CreditAttribution: moshe weitzman commented 30 October 2010 at 02:28

Status:

Active

» Fixed

I'm guessing that you are using a php.ini on the command line that differs from the one in use on the web. The command line one does not have mssql php extension enabled (your drush is running on windows?).

You can learn which php.ini drush is using with php -i at the command line or `drush st`. On the web, there is a PHO line in the Status Report page in admin. Or write a small php script that just does phpinfo().