Question

Forms DataSource Error for SQL Database

Forms

Updated March 2, 2015

asked on February 11, 2015

I'm setting up a data source in Forms to query a SQL database. Currently the same database is being queried in Workflow via a direct SQL connection to an instance via Windows Authentication. In setting the connection up in Forms, with the same configuration and AD account, I get the following error: Invalid object name: 'Sys.Databases'. It is the same server info and AD account used for both so in theory it should be working. Has anyone else run into this issue?

0 0

Replies

replied on February 11, 2015

I ran into a similar issue but different error. Right click the database you are trying to connect to through SQL Management Studio. Right click on the database and select "Properties" On the left hand side select "Options". For the compatibility level make sure it says "SQL Server 2008". When I had the error, I made this change and it solved my error. Changing the level had no impact on the other systems when I made the change.

1 0

replied on February 27, 2015

Thanks Derek. That customer's project is on hold so I can't test but once it picks back up I'll post back if it works. I appreciate the suggestion.

0 0

replied on March 2, 2015

Great, look forward to hearing if that takes care of the issue

0 0

You are not allowed to follow up in this post.

Question

Question

Forms DataSource Error for SQL Database

Replies

Sign in to reply to this post.