Forum Discussion
USE <database name> is failing
Hi, I ve created a user named my_sys1, a db named my_sys1. Then I ve created another user named my_sub_sys1 and a db named my_sub_sys1. I created a connection using my_sys1@my_sys1 (in a java a...
Sanat1984Where is your SQL Server that you are connecting to? If this is an Azure SQL Server then you can not use the "use" statement because Azure SQL databases are a one database to one connection. Thus your connection must specify a database if using Azure SQL Database. But in general, you should limit a connection to a single database and the connection string should specify your database; "use" statements should be used only when in interactive mode or during database maintenance activities.