Hlelo, I just download bitnami windows installer of DF v2 beta 4, which supposedly fixes the issue with loading MS SQL driver but I keep getting the same error. Bug still present? I am using sqlsrv mode.

Hi scmaverick, I’m newbie. Testing DF for future development. I experienced this bug when installing DF v2 beta 3. Found alternative (unofficial !) drivers here: [image] Unofficial Microsoft SQL Server Driver for PHP (sqlsrv) Here are unofficial modified builds of Microsoft's sqlsrv an…

@scmaverick did you install the sqlsrv drivers? @angelX that issue only exists if you installed Bitnami’s 64 bit package (which is the reason to use the unofficial drivers.) The official MS drivers still work with the 32 bit package.

@formerstaff right, I have re-installed DF with 32 bits package, and works fine with official drivers (I was not happy using unofficial drivers). Still having trouble retrieving one record, filtering by field value. As a newcomer to DF, I think I need a few more hours for testing. Many thanks for…

Aha! I installed the 64 bits version because its labeled as the recommended one, but you are right, I just remembered that Microsoft drivers only exist for 32 bits, I may have gotten confused as somebody once told me the 64b was already available, but I think he was talking about the linux version. …

How did the new Bitnami packages work out for you? They removed the 64-bit stacks and now have a GA release of DreamFactory 2.0.1.

Just a note for anyone following this thread: With the removal of the 64 bit Windows from the Bitnami installers page, there is no need to use the unofficial drivers referenced above. We DO NOT recommend using them. We ONLY recommend using the official sqlsrv drivers from Microsoft.

Actually, not good. I managed to make it work at least for the service creation but it was never able to connect to the database, if I wanted to see the schema it would hang and timeout with an error. If I wanted to test the api calls with the embedded swagger it would fail saying that the token was…

very true. even i couldn’t get this sorted out. I know DF provides good features but it fails for a seamless setup and integration with SQL database. Hope they quickly rectify this problem. I can’t wait anymore as my deadlines have already cross but still following :smile:

Just wanted to clarify a few things on this post. Since 2.0 is now officially released these types of issues have been resolved. Of course you will still have to install the sqlsrv driver separately. This is due to Microsoft’s licensing restrictions, not any kind of deficiency in the DreamFactory …

[image] formerstaff: not any kind of deficiency in the DreamFactory software. Just my $0.02, I think DF could do better than a cryptic error (API/module not loading) if this is a known issue. Or something during the installation phase of the Bitnami image telling me not to bother with MS SQL…

Api Error Required extension or module 'sqlsrv' is not installed or loaded on DF v2 beta 4

Connecting to SQL

Topic		Replies	Views
MSSQL database connection - DF 2 (beta 2 and 3) Connecting to SQL	4	3240	November 9, 2015
Unable to connect to SQL Server 2012 on Windows with DF2.0 Beta 2 Connecting to SQL	3	2673	October 14, 2015
2012 SQL Server Express troubles Connecting to SQL	2	3074	September 28, 2015
MS SQL connection not creating API's Connecting to SQL	9	3538	November 9, 2015
SQL Server - PHP Unable to Load Connecting to SQL	5	7365	April 17, 2020

Api Error Required extension or module 'sqlsrv' is not installed or loaded on DF v2 beta 4

Related topics