I am new to dreamfactory and I am trying to get a webservice working on top of a existing MSSQL database. I am using the hosted version and got an error. [image] Is this a bug or did I forget to set something. Thanks for your advice

Hi, Did anybody solve this issue in an other way? Thanks, JJ

Jan, are you using the hosted version at enterprise.dreamfactory.com or cloud.dreamfactory.com ? Also, did you create this table using the Schema manager in the admin UI?

Hi Drew, I am experiencing the exact same issue. I have created an instance via cloud.dreamfactory (old v1.9) to a MS SQL database and can return records from the tables without any issue. I have also created an instance via enterprise.dreamfctory to the same database to test v2.0 and although the …

We were having a problem on the hosted system with MS SQL, but I believed it to be resolved. What is the name of the example table you are using? Is it case sensitive?

Issue does occur with VMware bitnami-dreamfactory-2.0.beta-3-ubuntu-14.04 as well. Connected to Northwind db hosted on Azure. http://192.168.178.37:80/api/v2/Northwind/_table comes back with all tables, but trying to access one like http://192.168.178.37:80/api/v2/Northwind/_table/Categories fails…

I am experiencing similar issues. I will bring this to the attention of the engineering team.

Same thing here on DreamFactory 2.0.beta-3 (64-bit) Windows. Note: the SQL server system tables work

Is everybody who is experiencing this issue using case sensitive table names?

If you by case sensitive mean capital and small letters mixed then yes, e.g. “Customers”. Any solution to this yet?

I’m experiencing this issue with DF v2 beta-4 locally hosted, and SQL Server 2008 R2, when trying to retrieve records from table myTableName: http://127.0.0.1/api/v2/sql/_table/myTableName Works fine when retrieving list of tables. ¿Anything wrong?

Table doesn't exist in database (2.0 Beta issue w/ sql server)

Connecting to SQL

Topic		Replies	Views
Table does not exist in database REST API	15	6515	January 18, 2016
Bitnami OSX install of Dreamfactory 2 - Table does not exist in the database Schema & Data	3	3125	October 20, 2015
MS SQL Tables being returned but no data within them in 2.0 Connecting to SQL	12	2997	November 3, 2015
Api Error Required extension or module 'sqlsrv' is not installed or loaded on DF v2 beta 4 Connecting to SQL	13	7386	December 2, 2015
SQLSTATE[HY000] [1049] Unknown database 'dreamfactory' Connecting to SQL	1	3646	May 24, 2016

Table doesn't exist in database (2.0 Beta issue w/ sql server)

Related topics