sql connection

Hi I am using Windows applications. For local network, my application works fine. But my company they designed a static website and hence they request me to keep their database with website. Once I login to my website - DirectAdmin, from Databases, I create my SQL Database. By I don't know how...

Hi, from my C# windows application, when I try to connect with my SQL Database, located in my website, I receive the following error message A connection was successfully established with the server, but then an error occurred during pre-login handshake (provider-TCP Provider; error-0 An...

Hi, I am trying to run this code but getting error. code: try { SqlConnection conn = new SqlConnection("Data Source = .; " + "Initial Catalog = users; Persist Security Info = True; " + "User ID = sa; Password = ***********"); SqlCommand cmd = new SqlCommand("select * from...

Hello, I get an encoding related error when I want to check if my database connection is working when I press the "Connection" button on my form. The error is on "conn.Open();". I have attached my static class which contains the function for connection and the code where I call my function...

I am using Northwind database in Sql Server. I am using Stored Procedure to connect Visual Studio with Sql Server and draw data from database. In CRUD operations, I am tring to write a SEARCH button that is using Stored Procedure. Other CRUD buttons are working okay. Search button is not...

I have implemented some checks to a settings form in my app to validate some of the data and test DNS resolution and SQL connections. For some reason, if I purposely enter an incorrect username and password for the SQL database, my test function hangs without catching any exceptions. The app...

What is the format of a SQLConnection connection string that is passed in the constructor method? I have run a search engine search online and all I could find so far is examples like: "Data Source=(local);Initial Catalog=AdventureWorks; Integrated Security=SSPI;"; or "User...