sqlops | SQL自动审核-自助上线平台
kandi X-RAY | sqlops Summary
kandi X-RAY | sqlops Summary
SQL自动审核-自助上线平台
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- send email
sqlops Key Features
sqlops Examples and Code Snippets
Community Discussions
Trending Discussions on sqlops
QUESTION
I have successfully connected to a production SQL Server database and queried it using knex. I then restored that database locally using Docker and SQL Operations Studio on macOS (following this walkthrough). I was able to connect to it and query it from within SQLOPS. I am now attempting to connect to and query that local database programmatically instead of the production database. I updated the configuration to fill in the relevant info for the locally hosted database but I believe it's not entirely correct as I am receiving the following error:
RequestError: select top (@p0) * from [OurTableName] where [SomeID] = @p1 - Invalid object name 'OurTableName'.
Researching that error revealed it could be a configuration issue. Here is my config object:
...ANSWER
Answered 2018-Aug-01 at 16:46This is frequently a problem with which database you are connected to, versus which database holds the table. An 'sa'
login defaults to the master
database. Try using this type of request:
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install sqlops
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page