How can I use my LocalDB on other computers? I tried this but it doesn’t work because I get this error: Local Database Runtime error occurred. Cannot create an automatic instance Does someone know how to fix this, or what I can do instead? I don’t want to use SQLServer because I am making a progra…
Tag: database-connection
JSON Connection string configuration
In the app settings JSON file I am passing through a connection string which contains the name of my server ‘ .SQL2017 ‘ I recieve the following warning in error list when entering the server name …
MySQL Error: : ‘Access denied for user ‘root’@’localhost’
$ ./mysqladmin -u root -p ‘redacted’ Enter password: mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘root’@’localhost’ (using password: YES)’ How can I fix …
How to declare sql variable in C#
My requirement is to remove all record but one from a table. For this I am executing a series of two different sql commands. Seems like on ssms it works fine but with C# is not –This is what I run …
Creating a new database and new connection in Oracle SQL Developer
I’ve installed SQL Developer on my system. No connections are being shown in my system yet. How do I create a new connection. Must I create a database first? If yes, then how do I create a new database. The SQL Query Editor window is not opening because there is no connection. All of this because there …
Accessing database connection string using app.config in C# winform
I can’t seem to be able to access the app.config database connection string in my c# winforms app. app.config code C# code: When I try the C# code, I get a message: Warning 1 ‘System.Configuration.ConfigurationSettings.AppSettings’ is obsolete: ‘ This method is obsolete, it has been re…