background preloader

SQL

Facebook Twitter

SQLite

System.Data.SQLite: System.Data.SQLite Download Page. Build Product Names Beginning with System.Data.SQLite version 1.0.74.0 (3.7.7.1), the following templates will be used for the names of the build products: sqlite-netFx-source-version.zip sqlite-netFx-source-version.tar.gz sqlite-framework-setup-cpu-year-version.exe sqlite-framework-setup-bundle-cpu-year-version.exe sqlite-framework-binary-platform-year-version.zip sqlite-framework-binary-bundle-platform-year-version.zip sqlite-framework-static-binary-platform-year-version.zip sqlite-framework-static-binary-bundle-platform-year-version.zip sqlite-netFx-source-date.zip System.Data.SQLite.version.nupkg System.Data.SQLite.variant.version.nupkg Templates (1) and (2) are used for source-code packages.

Template (1) is used for generic source-code packages and template (2) is used for source-code packages that are generally only useful on unix-like platforms. Template (3) is used for the setup package. Template (4) is used for the setup package containing the mixed-mode assembly. How Can I Delete All the .BAK Files in a Folder That Are More Than 7 Days Old? - Hey, Scripting Guy! Blog. Hey, Scripting Guy! How can I delete all the .BAK files in a folder that are more than 7 days old?

-- KT Hey, KT. You know, on his way to work this morning the Scripting Guy who writes this column heard an advertisement for a local seafood restaurant. Now, this Scripting Guy doesn’t like seafood, so he normally wouldn’t pay any attention to an ad for a restaurant like this. However, his interest was piqued when the ad pointed out that this was the only restaurant in the Seattle area that served crab ice cream.

As you might expect, the Scripting Guy who writes this column was shocked: Seattle considers itself a world-class city, yet it only has one restaurant that serves crab ice cream?!? And we agree with you: someone should be fired over that. Admittedly we’re still a little shaken by all this, but we’ll try to answer your question anyway, KT. And don’t worry; as soon as we finish this dish of crab ice cream we’ll explain how this all works. OK. DtmDate = Date - 7 What are we doing here? How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433? Code Capers | How to Backup a SQL Express Database.

How to connect to SQL Server from another computer. SQL Server 2008 Express How-To-Guide Series. How to: Configure Express to accept remote connections - SQL Server Express WebLog. How to: Enable the TCP/IP Protocol for a Database Instance. In a multi-server deployment of Team Foundation Server, you must enable the TCP/IP protocol for the Team Foundation database. By enabling this protocol, you gain support for remote connections such as the connection between the application-tier server and the data-tier server for Team Foundation. If the TCP/IP protocol is not enabled for both the database instance and the SQL Server Native Client, the following errors might appear: Error 29108. Team Foundation report server configuration: cannot connect to the Team Foundation data-tier when trying to configure the report server database. TF31001: Team Foundation cannot retrieve the list of team projects from Team Foundation Server.

The Team Foundation Server returned the following error: The request failed with HTTP status 503: TF30059: Fatal error while initializing Web service. Required Permissions To enable the TCP/IP protocol for the database instance Log on to the data-tier server on which the database instance is defined. How to: Configure a Windows Firewall for Database Engine Access. This topic describes how to configure a Windows firewall for Database Engine access in SQL Server 2014 by using SQL Server Configuration Manager.

Firewall systems help prevent unauthorized access to computer resources. To access an instance of the SQL Server Database Engine through a firewall, you must configure the firewall on the computer running SQL Server to allow access. For more information about the default Windows firewall settings, and a description of the TCP ports that affect the Database Engine, Analysis Services, Reporting Services, and Integration Services, see Configure the Windows Firewall to Allow SQL Server Access. There are many firewall systems available. For information specific to your system, see the firewall documentation.

The principal steps to allow access are: Configure the Database Engine to use a specific TCP/IP port. Applies to Windows Vista, Windows 7, and Windows Server 2008 To open a port in the Windows firewall for TCP access [Top] Paging records in SQL Server 2005, SQL Server 2000, MS Access and MySQL.