[TYPO3-dev] Connecting to MSSQL from a extension

[Jason Alexander]

Thank you Xavier for pointing me in the right direction on using MSSQL within a extension. This is exactly what I needed to know. 

Jason R Alexander






On Mar 15, 2010, at 10:43 PM, Xavier Perseguers wrote:

> Hi Jason,
> 
>> I am curious if it is possible to connect to a mssql database from within a extension. Basically I want to query mssql and display the results on a Typo3 page. When I try using the mssql_connect php function I just get a fatal error. I've seen the  import_mssql extension connect to mssql to export. Am I missing anything?
> 
> Basically, the rule is the same with MSSQL than with MySQL, you should not use any mssql_ function nor mysql_ function. If you want to connect to MSSQL from within a TYPO3 extension, you basically have two choices:
> 
> - Use DBAL* with MSSQL. Ref [1] is a tutorial to connect to MSSQL
> - Use extension rvt_adodb which is a (very) lightweight implementation of DBAL (in a sense)
> 
> Official solution from TYPO3 is DBAL and I encourage you to choose this solution.
> 
> Regards
> 
> * Search for it in http://typo3.org/extensions
> [1] http://xavier.perseguers.ch/en/tutorials/typo3/articles/mssql-database.html
> 
> -- 
> Xavier Perseguers
> http://xavier.perseguers.ch/en
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev