# Connecting to SQL **URL:** https://community.dreamfactory.com/c/connecting-to-sql/9.md [Latest](https://community.dreamfactory.com/latest.md) · [Categories](https://community.dreamfactory.com/categories.md) · [Tags](https://community.dreamfactory.com/tags.md) --- ## [About the Connecting to SQL category](https://community.dreamfactory.com/t/about-the-connecting-to-sql-category/16)
**Author:** [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Replies:** 0
Info on securely connecting DreamFactory to your own SQL database, like MySQL, Microsoft SQL Server, and PostgreSQL. --- ## [Migrating from MySQL to...?](https://community.dreamfactory.com/t/migrating-from-mysql-to/5438)
**Author:** [@skipatrolmobile](https://community.dreamfactory.com/u/skipatrolmobile)\ **Replies:** 1\ **Last updated:** [January 12, 2023, 5:21pm UTC](https://community.dreamfactory.com/t/migrating-from-mysql-to/5438 "2023-01-12T17:21:28Z")
I’m a looong-time user of DreamFactory. I got started with v1.x. And… I’m still on v 2.8.1 (from 2017!) Two reasons I’m on that old version. 1) I’ve got a relatively simple and small MySQL database underneath and DreamF… --- ## [Migrating from SQL Lite to Actual SQL server connected with Dreamfactory](https://community.dreamfactory.com/t/migrating-from-sql-lite-to-actual-sql-server-connected-with-dreamfactory/5431)
**Author:** [@dinesh\_mna](https://community.dreamfactory.com/u/dinesh_mna)\ **Replies:** 0\ **Last updated:** [November 21, 2022, 4:56pm UTC](https://community.dreamfactory.com/t/migrating-from-sql-lite-to-actual-sql-server-connected-with-dreamfactory/5431 "2022-11-21T16:56:57Z")
Hi Team, We are currently using SQL lite with DreamFactory. Now we are planning to move/migrate from Lite to Standard/enterprise edition of SQL server. We have setup a database externally, but couldnt connect it through… --- ## [Can dreamfactory connect to trino](https://community.dreamfactory.com/t/can-dreamfactory-connect-to-trino/5348)
**Author:** [@Subbareddy425](https://community.dreamfactory.com/u/Subbareddy425)\ **Replies:** 1\ **Last updated:** [September 28, 2022, 10:50am UTC](https://community.dreamfactory.com/t/can-dreamfactory-connect-to-trino/5348 "2022-09-28T10:50:22Z")
Can dreamfactory connect to trino sql query engine --- ## [POST a Dataset as a JSON-object to a MS SQL Server 2019 stored procedure](https://community.dreamfactory.com/t/post-a-dataset-as-a-json-object-to-a-ms-sql-server-2019-stored-procedure/5394)
**Author:** [@Willi](https://community.dreamfactory.com/u/Willi)\ **Replies:** 1\ **Last updated:** [September 28, 2022, 10:46am UTC](https://community.dreamfactory.com/t/post-a-dataset-as-a-json-object-to-a-ms-sql-server-2019-stored-procedure/5394 "2022-09-28T10:46:30Z")
Hello, as mentioned in the topic i have to insert multiple records with one post api call that uses a mssql stored procedure in the background, but i couldn’t find a solution or guide for this problem. The only thing th… --- ## [Lessons Learned with MS SQL Server](https://community.dreamfactory.com/t/lessons-learned-with-ms-sql-server/230)
**Author:** [@DKL](https://community.dreamfactory.com/u/DKL)\ **Replies:** 1\ **Last updated:** [June 7, 2022, 6:42am UTC](https://community.dreamfactory.com/t/lessons-learned-with-ms-sql-server/230 "2022-06-07T06:42:37Z")
I am using DreamFactory in Azure to connect to a Microsoft SQL Server 2012 that is also running in Azure. I learned a few things today that I thought I would share. First, your Azure SQL Endpoint has both an external … --- ## [Create record by identifier not currently supported](https://community.dreamfactory.com/t/create-record-by-identifier-not-currently-supported/5361)
**Author:** [@wayne](https://community.dreamfactory.com/u/wayne)\ **Replies:** 0\ **Last updated:** [March 26, 2022, 7:23am UTC](https://community.dreamfactory.com/t/create-record-by-identifier-not-currently-supported/5361 "2022-03-26T07:23:36Z")
Got below error when requesting postman with: https://company.apps.dreamfactory.com/api/v2/Postman/\_table/listings/1##### { “error”: { “code”: 400, “context”: null, “message”: “Create record by identifier not curren… --- ## ["500 Failed to retrieve records" error using PostgreSQL](https://community.dreamfactory.com/t/500-failed-to-retrieve-records-error-using-postgresql/5264)
**Author:** [@akaHeimdall](https://community.dreamfactory.com/u/akaHeimdall)\ **Replies:** 1\ **Last updated:** [February 16, 2021, 6:59pm UTC](https://community.dreamfactory.com/t/500-failed-to-retrieve-records-error-using-postgresql/5264 "2021-02-16T18:59:38Z")
I’ve configured the service, app, and roles for my endpoint. I can successfully run API calls on /schema, /function, /table - basically all the single nodes that don’t have a table name. When I do add a table name (e.g… --- ## [Connect to PostgreSQL Database](https://community.dreamfactory.com/t/connect-to-postgresql-database/5255)
**Author:** [@kstcdaniel](https://community.dreamfactory.com/u/kstcdaniel)\ **Replies:** 1\ **Last updated:** [December 24, 2020, 1:54pm UTC](https://community.dreamfactory.com/t/connect-to-postgresql-database/5255 "2020-12-24T13:54:03Z")
Hello I am hoping someone here can help me. I need auto-generate APIs to my PostgreSQL database. the database is hosted on my hosting provider shared server. I have to connect to it using SSH tunnels. Direct SSH access … --- ## [Where do you provide SSL keys when creating service](https://community.dreamfactory.com/t/where-do-you-provide-ssl-keys-when-creating-service/5257)
**Author:** [@akaHeimdall](https://community.dreamfactory.com/u/akaHeimdall)\ **Replies:** 0\ **Last updated:** [December 15, 2020, 12:10pm UTC](https://community.dreamfactory.com/t/where-do-you-provide-ssl-keys-when-creating-service/5257 "2020-12-15T12:10:16Z")
On the “Create New Services” page, I’m setting us a service and want to use SSL keys as part of the security model. I can see a place to provide the SSL mode (in my case, required) but there is no space to provide an SSL… --- ## [Should Firebird driver work without additional config?](https://community.dreamfactory.com/t/should-firebird-driver-work-without-additional-config/5011)
**Author:** [@davidknaack](https://community.dreamfactory.com/u/davidknaack)\ **Replies:** 4\ **Last updated:** [October 30, 2020, 9:02am UTC](https://community.dreamfactory.com/t/should-firebird-driver-work-without-additional-config/5011 "2020-10-30T09:02:54Z")
I am using the docker dreamfactorysoftware/df-docker image. I can successfully connect to a PostgreSQL database, but when I try to connect to a Firebird database I receive the “could not find driver” error message. I se… --- ## [SQLSTATE\[HY000\] \[1045\] Access denied for user 'df\_admin'@'localhost' (using password: YES)](https://community.dreamfactory.com/t/sqlstate-hy000-1045-access-denied-for-user-df-admin-localhost-using-password-yes/2711)
**Author:** [@aamir\_rais](https://community.dreamfactory.com/u/aamir_rais)\ **Replies:** 8\ **Last updated:** [April 24, 2020, 12:20pm UTC](https://community.dreamfactory.com/t/sqlstate-hy000-1045-access-denied-for-user-df-admin-localhost-using-password-yes/2711 "2020-04-24T12:20:13Z")
I created database 'dreamfactory' in mysql and connected it with dreamfactory platform but when i tried to fetch and upload tables in mysql db ,the access denied error occurred. Mysql running on port 3306 in my system .… --- ## [Cannot connect to remote mysql with error 500 "HY000"](https://community.dreamfactory.com/t/cannot-connect-to-remote-mysql-with-error-500-hy000/5059)
**Author:** [@Mike\_Dawson](https://community.dreamfactory.com/u/Mike_Dawson)\ **Replies:** 1\ **Last updated:** [April 23, 2020, 6:54pm UTC](https://community.dreamfactory.com/t/cannot-connect-to-remote-mysql-with-error-500-hy000/5059 "2020-04-23T18:54:44Z")
See the error below, I have searched and cannot understand the issue. I am able to telnet into the database and have added the ip to the remote mysql table. Any help is appreciated. { “error”: { “code”: “HY000”, “m… --- ## [SQL Server - PHP Unable to Load](https://community.dreamfactory.com/t/sql-server-php-unable-to-load/1642)
**Author:** [@Bob\_McAllan](https://community.dreamfactory.com/u/Bob_McAllan)\ **Replies:** 5\ **Last updated:** [April 17, 2020, 6:03pm UTC](https://community.dreamfactory.com/t/sql-server-php-unable-to-load/1642 "2020-04-17T18:03:07Z")
I'm unable to configure the SQL server service. I've add the extension to the php.ini and php tries to load, however I receive the following errors. PHP Warning: PHP Startup: Unable to load dynamic library 'C:/Bitnam… --- ## [MS SQL issue in GUI](https://community.dreamfactory.com/t/ms-sql-issue-in-gui/4984)
**Author:** [@umardraz](https://community.dreamfactory.com/u/umardraz)\ **Replies:** 1\ **Last updated:** [April 17, 2020, 5:53pm UTC](https://community.dreamfactory.com/t/ms-sql-issue-in-gui/4984 "2020-04-17T17:53:20Z")
Hi I am running Dreamfactory 2.1.0 now I have a very strange issue, I am unable to connect one of my SQL server through GUI/API. Here is the error “message”: “Failed to connect to database.\\nConnection failed to open … --- ## [Postgresql: connexion to a specific schema](https://community.dreamfactory.com/t/postgresql-connexion-to-a-specific-schema/2693)
**Author:** [@Nico\_Dv](https://community.dreamfactory.com/u/Nico_Dv)\ **Replies:** 6\ **Last updated:** [April 17, 2020, 5:14pm UTC](https://community.dreamfactory.com/t/postgresql-connexion-to-a-specific-schema/2693 "2020-04-17T17:14:50Z")
HI, i'm trying to connect to a postgresql database with multiple schemas in it. However it looks like only the "public" schema is wired. i can only see the tables of the public schema in the "Schema manager Overview". I… --- ## [Fetch more than 1000 records in one step](https://community.dreamfactory.com/t/fetch-more-than-1000-records-in-one-step/97)
**Author:** [@rainer\_denner](https://community.dreamfactory.com/u/rainer_denner)\ **Replies:** 17\ **Last updated:** [March 27, 2020, 3:47pm UTC](https://community.dreamfactory.com/t/fetch-more-than-1000-records-in-one-step/97 "2020-03-27T15:47:04Z")
Hi, I have dreamfactory 1.5.9 running on my debian machine. I attached a mysql database and use several tables via rest api. Now I discovered one problem. I have one table which has 1097 records. I want to fetch them in … --- ## [One service with multiple databases](https://community.dreamfactory.com/t/one-service-with-multiple-databases/5082)
**Author:** [@Kryger](https://community.dreamfactory.com/u/Kryger)\ **Replies:** 1\ **Last updated:** [March 20, 2020, 5:10am UTC](https://community.dreamfactory.com/t/one-service-with-multiple-databases/5082 "2020-03-20T05:10:59Z")
Hi all Is it possible to have one service, which can connect to multiple SQL databases? We have a SQL server with multiple databases, all with the same schemas, but right now we have to create a new service for each da… --- ## [\[mysql error\] 1615 Prepared statement needs to be re-prepared](https://community.dreamfactory.com/t/mysql-error-1615-prepared-statement-needs-to-be-re-prepared/4918)
**Author:** [@kinoue](https://community.dreamfactory.com/u/kinoue)\ **Replies:** 2\ **Last updated:** [February 27, 2020, 3:14pm UTC](https://community.dreamfactory.com/t/mysql-error-1615-prepared-statement-needs-to-be-re-prepared/4918 "2020-02-27T15:14:48Z")
When I try to get data from “view” in mysql service, the following error occurs. DreamFactory Table Module Failed to retrieve records from ‘myview’. SQLSTATE\[HY000\]: General error: 1615 Prepared statement needs to be r… --- ## [Connect Laravel to Dreamfactory](https://community.dreamfactory.com/t/connect-laravel-to-dreamfactory/5015)
**Author:** [@nathanaelluchetta](https://community.dreamfactory.com/u/nathanaelluchetta)\ **Replies:** 0\ **Last updated:** [August 16, 2019, 11:22pm UTC](https://community.dreamfactory.com/t/connect-laravel-to-dreamfactory/5015 "2019-08-16T23:22:15Z")
Is it possible? Connect Laravel by the .env file to the Dreamfactory created database? I ask this because I want to use Eloquent besides the HTML get and posts. --- ## [Using stored procedures on MySQL version \< 5.5.3](https://community.dreamfactory.com/t/using-stored-procedures-on-mysql-version-5-5-3/3744)
**Author:** [@efunneko](https://community.dreamfactory.com/u/efunneko)\ **Replies:** 3\ **Last updated:** [May 13, 2019, 9:21am UTC](https://community.dreamfactory.com/t/using-stored-procedures-on-mysql-version-5-5-3/3744 "2019-05-13T09:21:36Z")
I am trying to call a stored procedure on mysql version 5.0.77. When I try to do a simple call of the procedure, I get the following error: SQLSTATE\[42S22\]: Column not found: 1054 Unknown column ‘DATA\_TYPE’ in ‘field l… --- ## [How to query the DB with the ILIKE filter](https://community.dreamfactory.com/t/how-to-query-the-db-with-the-ilike-filter/3629)
**Author:** [@Sumanth\_Neppalli](https://community.dreamfactory.com/u/Sumanth_Neppalli)\ **Replies:** 4\ **Last updated:** [April 8, 2019, 8:37am UTC](https://community.dreamfactory.com/t/how-to-query-the-db-with-the-ilike-filter/3629 "2019-04-08T08:37:05Z")
When I am querying my table with the Like function, the result doesn't display different case results. For example, if I am specify a filter "column like %washington" it doesn't display the result which has "Washington… --- ## [Remote Database API with XCode](https://community.dreamfactory.com/t/remote-database-api-with-xcode/813)
**Author:** [@paulchatwin](https://community.dreamfactory.com/u/paulchatwin)\ **Replies:** 12\ **Last updated:** [February 7, 2015, 12:46am UTC](https://community.dreamfactory.com/t/remote-database-api-with-xcode/813 "2015-02-07T00:46:42Z")
HI All, I have recently discovered Dream Factory and am working my way through the various tutorials / screen casts etc. I have one question that I can't seem to find an answer to though. I want my iOS app to connect… --- ## [Gateway timeout when fetching records from MySQL database](https://community.dreamfactory.com/t/gateway-timeout-when-fetching-records-from-mysql-database/4793)
**Author:** [@shobana](https://community.dreamfactory.com/u/shobana)\ **Replies:** 0\ **Last updated:** [February 9, 2019, 2:08pm UTC](https://community.dreamfactory.com/t/gateway-timeout-when-fetching-records-from-mysql-database/4793 "2019-02-09T14:08:02Z")
Hi, I’ve created a service for a mysql database which is in AWS RDS. In the service configuration i saw a field “schema”, if i give it as “default” that service will work only with that particular DB’s schemas and table… --- ## [Dream Factory MySQL database error](https://community.dreamfactory.com/t/dream-factory-mysql-database-error/4730)
**Author:** [@volga629](https://community.dreamfactory.com/u/volga629)\ **Replies:** 6\ **Last updated:** [December 14, 2018, 4:27am UTC](https://community.dreamfactory.com/t/dream-factory-mysql-database-error/4730 "2018-12-14T04:27:15Z")
Hello Everyone, Kubernetes deployed Dream Factory any operation include log in getting errors. Used docker image https://hub.docker.com/r/dreamfactorysoftware/df-docker/ If I am looking into correct place database.p… --- ## [ I am hosting the DreamFactory API web server on my localhost and I am accessing it through my iOS app.](https://community.dreamfactory.com/t/i-am-hosting-the-dreamfactory-api-web-server-on-my-localhost-and-i-am-accessing-it-through-my-ios-app/4738)
**Author:** [@SarikaA](https://community.dreamfactory.com/u/SarikaA)\ **Replies:** 0\ **Last updated:** [December 11, 2018, 9:49pm UTC](https://community.dreamfactory.com/t/i-am-hosting-the-dreamfactory-api-web-server-on-my-localhost-and-i-am-accessing-it-through-my-ios-app/4738 "2018-12-11T21:49:16Z")
I’m new to swift and iOS development in general, However I can’t motivate my capacity to restore the outcome from an API GET ask. I am running a Microsoft SQL server on my companion’s PC and I am remotely getting to it w… --- ## [Open source Version](https://community.dreamfactory.com/t/open-source-version/4719)
**Author:** [@Hussein](https://community.dreamfactory.com/u/Hussein)\ **Replies:** 1\ **Last updated:** [December 3, 2018, 4:04pm UTC](https://community.dreamfactory.com/t/open-source-version/4719 "2018-12-03T16:04:55Z")
Is open Source Contains part of connecting to SQL Server with license rules or Not contains it ? --- ## [MySQL (MariaDB) GET Stored Procedure with two parameters are returning no results](https://community.dreamfactory.com/t/mysql-mariadb-get-stored-procedure-with-two-parameters-are-returning-no-results/4715)
**Author:** [@CrystalTaggart](https://community.dreamfactory.com/u/CrystalTaggart)\ **Replies:** 2\ **Last updated:** [December 3, 2018, 3:55pm UTC](https://community.dreamfactory.com/t/mysql-mariadb-get-stored-procedure-with-two-parameters-are-returning-no-results/4715 "2018-12-03T15:55:25Z")
I’ve created a stored procedure with two parameters - a string and a bit. Now when I Execute my GET API call, nothing is returned. if I remove the string and keep the bit, works perfectly. DreamFactory Version: 2.14.0 … --- ## [DB: Table-Valued Function Support](https://community.dreamfactory.com/t/db-table-valued-function-support/3681)
**Author:** [@deanstalker](https://community.dreamfactory.com/u/deanstalker)\ **Replies:** 3\ **Last updated:** [November 26, 2018, 5:29pm UTC](https://community.dreamfactory.com/t/db-table-valued-function-support/3681 "2018-11-26T17:29:06Z")
I would love know how progress is going on further extended table-valued function support. ie. SELECT \* FROM tableFunction(param1) WHERE param2 = 'etc' I did notice this commit which implements basic handling to th… --- ## [Can't connect to Remote MySQL server](https://community.dreamfactory.com/t/cant-connect-to-remote-mysql-server/100)
**Author:** [@Pavel](https://community.dreamfactory.com/u/Pavel)\ **Replies:** 13\ **Last updated:** [July 31, 2018, 12:10pm UTC](https://community.dreamfactory.com/t/cant-connect-to-remote-mysql-server/100 "2018-07-31T12:10:35Z")
Hi guys, love your application but there's one issue that really drives me crazy. For some reason I just can't connect to a remote MySQL server I have. This is what I am doing: http://i.imgur.com/S9WHZ5i.pngAnd this is t… [Next page](https://community.dreamfactory.com/c/connecting-to-sql/9.md?page=1)