Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-07-2011
Member
 
Join Date: Jun 2011
Posts: 55
Is NEW MSSQL Driver SQLSRV compatible with ADODB

My question is not that big. I just want to know that is ADODB is compatible with new MSSQL Driver SQLSRV? I have connected in the following way. Just check it for me whether it is correct or not?

Code:
$db = ADONewConnection($config['db_type']);
$rs = $db->PConnect($config['db_host'], $config['db_user'], $config['db_pass'], 
$config['db_name']) or die("Unable to connect!");
Reply With Quote
  #2  
Old 01-07-2011
Member
 
Join Date: May 2009
Posts: 533
Re: Is NEW MSSQL Driver SQLSRV compatible with ADODB

Yes, ADODB is compatible with new MSSQL Driver SQLSRV. It easily works with new MSSQL driver. I would like to let you know that the type will be 'mssqlnative'. The connection code which you have mentioned is correct. According to be it should work fine. You can do your projects smoothly. If you want to confirm then you can visit to the official website and check by yourself.
Reply With Quote
  #3  
Old 01-07-2011
Member
 
Join Date: May 2009
Posts: 525
Re: Is NEW MSSQL Driver SQLSRV compatible with ADODB

If you face any troubleshooting like Is NEW MSSQL Driver SQLSRV is not working with ADOB then I have suggestions for you. Remove all addons and install it via web platform. After that everything will be ok. Know you can connect MSSQL DB. The actual problem is that my website does not connect the MSSQL. If you connect it via ADODB then it will work smoothly. The newer versions of ADODB support the SQLSRV server.
Reply With Quote
  #4  
Old 01-07-2011
Member
 
Join Date: Apr 2009
Posts: 567
Re: Is NEW MSSQL Driver SQLSRV compatible with ADODB

I think there is a problem in the code of connection. The code seems to be incomplete. If you follow that, it won’t work whether your other things are compatible or not. Just use the code that I have done it for you.
Code:
$db = ADONewConnection($config['db_type']);
$db->locale = 'us_english';
$db->debug = $_config['dbdebug'];$rs = $db->PConnect($config['db_host'], 
$config['db_user'], $config['db_pass'], $config['db_name']) 
or die("Unable to connect!");
Reply With Quote
  #5  
Old 02-07-2011
Member
 
Join Date: Apr 2009
Posts: 484
Re: Is NEW MSSQL Driver SQLSRV compatible with ADODB

If your NEW MSSQL Driver SQLSRV is not compatible with ADODB then you will get the below error.
Code:
function ADODB_mssqlnative(){ if ($this->debug) { error_log("
");
            sqlsrv_set_error_handling( SQLSRV_ERRORS_LOG_ALL );
            sqlsrv_log_set_severity( SQLSRV_LOG_SEVERITY_ALL );
            sqlsrv_log_set_subsystems(SQLSRV_LOG_SYSTEM_ALL);
            sqlsrv_configure('warnings_return_as_errors', 0);
        } else {
            sqlsrv_set_error_handling(0);
            sqlsrv_log_set_severity(0);
            sqlsrv_log_set_subsystems(SQLSRV_LOG_SYSTEM_ALL);
            sqlsrv_configure('warnings_return_as_errors', 0);
        }
}
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Is NEW MSSQL Driver SQLSRV compatible with ADODB"
Thread Thread Starter Forum Replies Last Post
Types of Cursors in ADODB Jagdish Gada Software Development 4 28-11-2009 01:36 PM
Lock Type in ADODB of Visual Basic 6.0 REDBULL Software Development 4 28-11-2009 01:04 PM
ADODB 0x80020009 error problem Halyn Software Development 3 28-08-2009 06:50 PM
ADODB Connection String with password Xan Software Development 2 21-04-2009 03:29 PM
Opening .DBF file using ADODB Pratap Gad Software Development 3 21-04-2009 02:52 PM


All times are GMT +5.5. The time now is 03:57 PM.