|
/
|
Пустой анкор
|
|
|
/
|
Developers number one Connection Strings reference
|
|
|
/kb/
|
Knowledge Base
|
|
|
/questions/
|
Q & A forums
|
|
|
/about/
|
About
|
|
|
/contribute/
|
Contribute
|
|
|
/
|
Knowledge base
|
|
|
/formating-rules-for-connection-strings/
|
<header>
<h2>Formating Rules for Connection Strings</h2>
</header>
<p>There are no built in checks or constraints on how to format a connection string. This walk-through shows the basic rules for creating a connection string that will work.</p>
|
|
|
/connection-strings-explained/
|
<header>
<h2>Connection Strings Explained</h2>
</header>
<p>Connection strings can be a bit obscure and are often not defined consistently. This article straightens things out and sheds some light on how connection strings are used to connect an application to a data source.</p>
|
|
|
/sql-server-data-types-reference/
|
<header>
<h2>SQL Server Data Types Reference</h2>
</header>
<p>Do you know exactly every sql data type in SQL Server and their usage and storage requirements? If not, look them all up in this reference sheet.</p>
|
|
|
/define-sql-server-network-protocol/
|
<header>
<h2>Network Protocol for SQL Server Connection</h2>
</header>
<p>To explicitly define which network protocol to use when connecting to an SQL Server gives you more control over your connection. This guide explains how to do that.</p>
|
|
|
/all-sql-server-connection-string-keywords/
|
<header>
<h2>All SQL Server SqlConnection Properties</h2>
</header>
<p>There are plenty of combinations when creating an SQL Server connection string. This reference table explains each option available per keyword.</p>
|
|
|
/sql-native-client-use/
|
<header>
<h2>When to use the SQL Native Client</h2>
</header>
<p>The SQL Native Client should only be used in certain contexts. This is the definition of when to use it, and when not to.</p>
|
|
|
/how-to-open-password-protected-excel-workbook/
|
<header>
<h2>Open a password-protected Excel workbook</h2>
</header>
<p>This article explains a workaround for the "could not decrypt file" error when trying to open a password-protected Excel workbook.</p>
|
|
|
/using-jet-in-64-bit-environments/
|
<header>
<h2>Jet for Access, Excel and Txt on 64 bit systems</h2>
</header>
<p>This article explains how to use Jet to connect an application to Access, Excel or Text data files on 64 bit systems.</p>
|
|
|
/use-application-name-sql-server/
|
<header>
<h2>Application Name for SQL Server Connections</h2>
</header>
<p>This optional parameter can be a life saver. The DBAs will love that you provide this info for the connection.</p>
|
|
|
/store-connection-string-in-webconfig/
|
<header>
<h2>Store Connection String in Web.config</h2>
</header>
<p>It is very easy to store the connection string in a config file and there are several benefits in doing so. This article describes why and how to store the connection string in web.config.</p>
|
|
|
/connection-pooling/
|
<header>
<h2>Connection Pooling</h2>
</header>
<p>To get the most out of connection pooling there are some things to keep in mind when developing your application. Learn to stay away from the pitfalls and utilize the full power of connection pooling.</p>
|
|
|
/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/
|
<header>
<h2>The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine</h2>
</header>
<p>There are several reasons this message pops in your application or website. This article tries to clarify each particular situation.</p>
|
|
|
/cdata-ado-net-cache-provider/
|
<header>
<h2>CData ADO.NET - use an External Cache Provider</h2>
</header>
<p>Caching data in an external cache database increase performance and provides additional querying features. This article explains how to specify an external cache database to be used by the CData ADO.NET Providers.</p>
|
|
|
/provider-progid-com-clsid/
|
<header>
<h2>The Provider Keyword, ProgID, Versioning and COM CLSID Explained</h2>
</header>
<p>Behind the Provider keyword is a chain of mappings to the software implementation contained in a dll file. This article explains that chain and how COM works in general.</p>
|
|
|
/sql-server-2000-data-types-reference/
|
<header>
<h2>SQL Server 2000 Data Types Reference</h2>
</header>
<p>Do you know exactly every sql data type in SQL Server 2000 and their usage and storage requirements? If not, look them all up in this reference sheet.</p>
|
|
|
/sql-server-2005-data-types-reference/
|
<header>
<h2>SQL Server 2005 Data Types Reference</h2>
</header>
<p>Do you know exactly every sql data type in SQL Server 2005 and their usage and storage requirements? If not, look them all up in this reference sheet.</p>
|
|
|
/sql-server-2008-data-types-reference/
|
<header>
<h2>SQL Server 2008 Data Types Reference</h2>
</header>
<p>Do you know exactly every sql data type in SQL Server 2008 and their usage and storage requirements? If not, look them all up in this reference sheet.</p>
|
|
|
/sql-server-2012-data-types-reference/
|
<header>
<h2>SQL Server 2012 Data Types Reference</h2>
</header>
<p>Do you know exactly every sql data type in SQL Server 2012 and their usage and storage requirements? If not, look them all up in this reference sheet.</p>
|
|
|
/caching-metadata-cdata-provider/
|
<header>
<h2>Caching Data Source Metadata with CData Provider</h2>
</header>
<p>The Cache Metadata feature can be used to speed up the connection process significantly for data sources where the schema information is otherwise retrieved dynamically.</p>
|
|
|
/download-oracle-11g-release-2-client-odbc-drivers/
|
<header>
<h2>Download Oracle 11g Release 2 Client ODBC Drivers</h2>
</header>
<p>The setup differs between 64-bit and 32-bit windows.</p>
|
|
|
/ase-unsupported-charset/
|
<header>
<h2>ASE - Unsupported Charset</h2>
</header>
<p>Sometimes it is necessary to specify the character set in the connection string. This is done by adding charset=xxx where xxx is a valid Sybase charset code. See the table below for the translation and valid values.</p>
|
|
|
/download-sql-server-native-client/
|
<header>
<h2>Download SQL Server Native Client</h2>
</header>
<p>There have been new versions of the Native Client ODBC and OLEDB with each new version of SQL Server. Distributed through several different "Feature Packs" it has been confusing to find the right component. This article explains, instructs and provides download links for all versions and distributions of the SQL Server Native Client.</p>
|
|
|
/oauth-cdata-ado-net-connect-data-services/
|
<header>
<h2>Using OAuth and CData ADO.NET Providers to Connect your App to OData Services</h2>
</header>
<p>How to use the CData GetOAuthAccessToken stored procedure to connect your app to OAuth protected OData services.</p>
|
|
|
/the-new-microsoft-data-sqlclient-explained/
|
<header>
<h2>The new Microsoft.Data.SqlClient explained</h2>
</header>
<p>Why did Microsoft move SqlClient to new binaries into NuGet package Microsoft.Data.SqlClient. Should I swap? Future releases? Namespaces?</p>
|
|
|
/store-and-read-connection-string-in-appsettings-json/
|
<header>
<h2>Store and read connection string in appsettings.json</h2>
</header>
<p>There are different ways to store and read connection strings in appsettings.json. Learn some easy ways to work with connection strings in .NET Core.</p>
|
|
|
/how-to-access-oracle-from-bi-tools-tableau-power-bi-dbxtra/
|
<header>
<h2>How to Access Oracle from BI Tools: Tableau, Power BI, DBxtra</h2>
</header>
<p>Tableau, Power BI, and DBXtra are powerful business intelligence and reporting tools that you can use to create dashboards and perform analytics.</p>
|
|
|
/kb/
|
All articles and how-tos<span>×26</span>
|
|
|
/kb/generic/
|
Connections & strings<span>×6</span>
|
|
|
/kb/access/
|
Access<span>×2</span>
|
|
|
/kb/azure-sql-database/
|
Azure SQL Database<span>×2</span>
|
|
|
/kb/excel/
|
Excel<span>×3</span>
|
|
|
/kb/html-table/
|
HTML Table<span>×2</span>
|
|
|
/kb/odata/
|
OData<span>×1</span>
|
|
|
/kb/oracle/
|
Oracle<span>×2</span>
|
|
|
/kb/sql-server/
|
SQL Server<span>×11</span>
|
|
|
/kb/sql-server-compact/
|
SQL Server Compact<span>×1</span>
|
|
|
/kb/sybase-adaptive/
|
Sybase Adaptive<span>×1</span>
|
|
|
/kb/textfile/
|
Textfile<span>×2</span>
|
|
|
/
|
connectionstrings
|
|
|
/kb/
|
articles
|
|
|
/search/
|
search
|
|
|
/questions/
|
Q & A
|
|
|
/questions/ask/
|
ask question
|
|
|
/contribute/
|
contribute
|
|
|
/retrospective/
|
retro
|
|
|
/about/
|
about
|
|
|
/contact/
|
contact
|
|
|
/user/logon/
|
log in
|
Запрет в robots.txt
|
|
/user/signup/
|
join
|
|
|
/contribute/
|
Contributing Developers
|
|
Kestrel