Reputation: 563
Does anybody know if one can connect to a MSSQL Server database using phalconphp?
When I try to generate a modelI I get the following error :
Phalcon DevTools (1.2.6) Error: Adapter sqlsrv is not supported
Any advice much appreciated.
Thanks
UPDATE :
Hi guys,
The author replied to my email asking for installation instructions, I have asked him to update the README.md in the repository.
Herewith his response :
Sorry that i didn't explain anything~ you could put it anywhere, just remember to add the "namespace" to "folder path" config
add the "namespace" to "folder path" setting //Register some namespaces $loader->registerNamespaces(
array(
"Twm\Db\Adapter\Pdo" => "library/db/adapter/",
"Twm\Db\Dialect" => "library/db/dialect/"
)
);
by the way, i found it only works under 1.2.0 ~ 1.2.4 i'm working on 2.0 using zephir
good luck
Kevin Yu
Upvotes: 0
Views: 3102
Reputation: 36
github.com/fishjerky/phalcon-mssql is your answer. But I had the same issue with this adapter.
So I changed from
"{$descriptor['pdoType']}:host={$descriptor['host']};dbname={$descriptor['dbname']}"
to
"{$descriptor['pdoType']}:server={$descriptor['host']};database={$descriptor['dbname']}"
Also you need to make sure 'sqlsrv' is set for $config->database->pdoType.
Hope it helps.
Upvotes: 2
Reputation: 6136
Currently there is no out of the box connectivity of MSSQL with PhalconPHP but you can use various packages from Composer to provide this functionality.
Here is one package that I found the most promising :-
UPDATE :
Check this link or install it via Composer, and check the documentation on the Github page or refer to this API Documentation
Upvotes: 1