-
Hits: 1627
-
Hits: 2017
XPSMTP provides a SMTP based SQL Mail solution for sending MIME based email over SMTP, implemented as an Extended Stored Procedure.
It does not require any software to be installed, just a SMTP email server that can handle the outgoing mail request. XPSMTP is using TCP/IP sockets to communicate to port 25. XPSMTP does not spawn additional threads, the xp_smtp_sendmail request is handled on the same thread as it is being called on by SQL Server. Each call to xp_smtp_sendmail establishes a connection to the SMTP server and disconnects when done sending the email. The connection is created using asynchronous communication and aborts based on a timeout value (@timeout which by default is 10000 milliseconds, so 10 seconds).
-
Hits: 1922
We're a wiki, like Wikipedia:
all of the information you see here is freely editable by any logged-in user.
Anyone can contribute to articles, add new code, edit articles, you name it. This site is by the community, for the community. Content is moderated by the community and our own panel of database experts, all with a high level of expertise and passion in their field.
-
Hits: 1731
A Microsoft SQL Server community of 1,397,592 (Jun 22, 2011) DBAs,developers and SQL Server users
-
Hits: 1970
Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.
Overview
The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:
Redistributable components for SQL Server 2008.
Add-on providers for SQL Server 2008.
Backward compatibility components for SQL Server 2008.
-
Hits: 1826
ODBC is a standard definition of an application programming interface (API) used to access data in relational or indexed sequential access method (ISAM) databases. SQL Server supports ODBC, via the SQL Server Native Client ODBC driver, as one of the native APIs for writing C, C++, and Microsoft Visual Basic applications that communicate with SQL Server.
-
Hits: 1682
There are a number of differences between SQL Native Client and Microsoft Data Access Components (MDAC). Although both provide native data access to SQL Server databases, SQL Native Client has been specifically designed to expose the new features of SQL Server 2005, while at the same time maintaining backward compatibility with earlier versions.
In addition, although MDAC contains components for using OLE DB, ODBC, and ActiveX Data Objects (ADO), SQL Native Client only implements OLE DB and ODBC (although ADO can access the functionality of SQL Native Client).
-
Hits: 1904
When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server. For example, you receive the following error message when you use the SQLCMD utility to connect to SQL Server:
Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
This problem may occur when SQL Server 2005 is not configured to accept remote connections. By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:
Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
This article describes how to complete each of these steps.
-
Hits: 1533
This article will focus on the use of Windows Groups for security in your SQL Server instances in lieu of relying on SQL Server logins for administering your security contexts.
-
Hits: 1297
The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Windows Azure SQL Database.
-
Hits: 1003
In this topic, you will learn how to enable network protocols with Microsoft SQL Server Code-Named “Denali” Express (SQL Server Express) by using SQL Server Configuration Manager. You will also learn how to configure a protocol for your specific needs. For more information, see Protocols Supported by SQL Server Express.
-
Hits: 3118
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.accdb and .mdb).
Introduction
This article describes how to create a connection to Microsoft SQL Server for linked tables in Microsoft Access that does not use a data source name (DSN). This is also known as a DSN-less connection.