About 766,000 results
Open links in new tab
  1. How to add custom attributes to SQL connection string?

    Aug 30, 2014 · There is no generalized method to pass custom connection string attributes via Client APIs and retrieve using T-SQL. You have a number of alternatives, though. Below are a few. Method …

  2. Getting current connection properties in SQL Server

    Jul 17, 2009 · 11 In MS SQL Server, the Database Properties dialog has the "View Connection Properties" link over on the left. Clicking that brings the "Connection Properties" dialog with …

  3. How to set custom connection properties on DataSource in Spring …

    I need to set some specific Oracle JDBC connection properties in order to speed up batch INSERTs (defaultBatchValue) and mass SELECTs (defaultRowPrefetch). I got suggestions how to achieve this …

  4. java - How can I set a connection property? - Stack Overflow

    Aug 28, 2012 · I can connect fine to an Oracle 11.2 database using JDBC driver and the following Java code: import java.sql.*; import javax.sql.DataSource; import javax.naming.Context; import javax.naming.

  5. How do I read a properties file and connect a MySQL database?

    Jan 3, 2017 · A sample db.properties file has been provided to me for my reference. The five lines of the file correspond to the host, port, database name, username and password for the database. I need to …

  6. .net - The connection properties object must be of type ...

    Oct 25, 2023 · The connection properties object must be of type SqlConnectionProperties or OleDBSqlConnectionPropertiies Asked 2 years, 2 months ago Modified 1 year, 9 months ago …

  7. JDBC connection failed, error: TCP/IP connection to host failed

    Error: The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on …

  8. java - The TCP/IP connection to the host localhost, port 1433 has ...

    Nov 8, 2015 · Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port …

  9. java - SQL Server jdbc connection - Stack Overflow

    Apr 20, 2013 · Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make …

  10. java - How to use .properties file to store database connection ...

    Properties property = new Properties(); This is an issue of NullPointerException in your code, because you referenced not initialized variable. If you open a stream you should close it after it's not used. Do …