System.Exception: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The network path was not found at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ShopVisible.Core.HelperClasses.cFunctions.getRS(String sql, String& ErrorDesc) in D:\working\ShopVisible.v2\Ver\Shoplogic\20130328\ShopVisible.Shoplogic\ShopVisible.Core.HelperClasses\cFunctions.vb:line 389 ClientConnectionId:00000000-0000-0000-0000-000000000000, sql: SELECT TOP 4 (CASE WHEN g.Product_ID IS NOT NULL THEN 1 ELSE 0 END) Is404, a.Product_ID, a.Dept_ID, a.Product_Code, a.Product_Name, a.ImagePath, b.Brand_ID, b.Brand, c.Sale, c.Sale_Special, d.Dept_Alt FROM Product a with (nolock) INNER JOIN Brand b with (nolock)ON a.Brand_ID = b.Brand_ID INNER JOIN Price c with (nolock)ON a.Product_ID = c.Product_ID INNER JOIN Departments d with (nolock) ON a.Dept_ID = d.Dept_ID INNER JOIN Website e with (nolock)ON c.Site_ID = e.Site_ID INNER JOIN Featured_Groups f with (nolock) ON f.Group_Name = '404 Products' INNER JOIN Featured_Products g ON f.Group_ID = g.Group_ID AND a.Product_ID = g.Product_ID WHERE e.Site_ID = 1 AND a.Orderable = 0 AND a.Deleted = 0 and a.imagePath is not null and a.imagePath <> 'noimage_sm.gif' ORDER BY Is404 DESC,g.display_order -- First Exception: System.Exception: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The network path was not found at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ShopVisible.Core.HelperClasses.cFunctions.getRS(String sql, String& ErrorDesc) in D:\working\ShopVisible.v2\Ver\Shoplogic\20130328\ShopVisible.Shoplogic\ShopVisible.Core.HelperClasses\cFunctions.vb:line 389 ClientConnectionId:00000000-0000-0000-0000-000000000000, sql: SELECT TOP 4 (CASE WHEN g.Product_ID IS NOT NULL THEN 1 ELSE 0 END) Is404, a.Product_ID, a.Dept_ID, a.Product_Code, a.Product_Name, a.ImagePath, b.Brand_ID, b.Brand, c.Sale, c.Sale_Special, d.Dept_Alt FROM Product a with (nolock) INNER JOIN Brand b with (nolock)ON a.Brand_ID = b.Brand_ID INNER JOIN Price c with (nolock)ON a.Product_ID = c.Product_ID INNER JOIN Departments d with (nolock) ON a.Dept_ID = d.Dept_ID INNER JOIN Website e with (nolock)ON c.Site_ID = e.Site_ID INNER JOIN Featured_Groups f with (nolock) ON f.Group_Name = '404 Products' INNER JOIN Featured_Products g ON f.Group_ID = g.Group_ID AND a.Product_ID = g.Product_ID WHERE e.Site_ID = 1 AND a.Orderable = 0 AND a.Deleted = 0 and a.imagePath is not null and a.imagePath <> 'noimage_sm.gif' ORDER BY Is404 DESC,g.display_order at BaseCommonWebControl.queryAndCache(String sql, String& lsResult) at UserControls_cntrlRandomProducts.PopulateProductList() Site is undergoing maintenance

Site Maintenance

Atlantic Cigar appologizes for the inconvenience. We are currently undergoing site maintenance to enhance your shopping experience.

Click here to try again.

Looking for something?

You may be trying to access a page that has changed. We apologize for any inconvenience but we are working to improve your shopping experience.

Go to the home page  You may have received this message for several reasons:

If you reached this page from another com page, click to go back .

As always, thank you for shopping with us.

Site is undergoing maintenance

Site Maintenance

Atlantic Cigar appologizes for the inconvenience. We are currently undergoing site maintenance to enhance your shopping experience.

Click here to try again.