Connection Strings

Connection Strings 101

• by Nakul Vachhrajani

• SQLServerCentral.com

• Connection Strings

• Article

This article introduces connection strings and suggests using MDAC to easily write efficient connection strings for those new to SQL Integration.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.59 (17)

Log in or register to rate

You rated this post out of 5. Change rating

2010-12-24

5,148 reads

• Discuss

Connection strings for SQL Server 2008

• by Additional Articles

• connectionstrings.com

• Connection Strings

• Article

A set of different connection strings for using with different providers for SQL Server.

2009-12-31

8,480 reads

ADO Connection Strings

• by Additional Articles

• CodeProject.com

• Connection Strings

• Article

A list of ODBC DSN Connection Strings.

2009-10-16

4,524 reads

Logging connection strings

• by Additional Articles

• sqlis.com

• Integration Services (SSIS)

• Article

If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing.

2009-06-22

3,641 reads

RE: Hardware raid Configuration

• by Gabor-Nyul

• SQLServerCentral.com

• Reply

Raid5 is suitable for low cost and mainly read only applications as every write operation needs to calcul the parity to be written to the parity disk. Read operation can be fast because several spindles (physical disks) coud honour the read request.Raid10 is one of the most expensive RAID solution but ont of the best […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-08-26

RE: Invalid object name with '_'

• by mccork

• SQLServerCentral.com

• Reply

...or you might even need to qualify it with the owner name: Select * from [_SMDBA_].[_Actions_]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-22

RE: Relationships cause FK contsraint error

• by PARogers

• connectionstrings.com

• Reply

Thanks for your advice. The problem in having a foreign key on either Person or Organisation is that both can have more than one address. The basic thinking behind all this is that we have details of people and details of companies. Someone who has directorships of multiple companies may wish his correspondance in a […]

2003-07-09

RE: upgrade SQ: 6.5 to 2000

• by Andy Warren

• CodeProject.com

• Reply

DTS will do it pretty easily. I'd make sure you that you all the constraints and indexes, not just the tables. Probably are there, doesnt hurt to check. Might do just as well to drop everything and try again. Andy http://qa.sqlservercentral.com/columnists/awarren/

2003-06-26

RE: group by optimize

• by mworku

• sqlis.com

• Reply

quote: Tim: Index covering is for non-clustered indexes, but in this case the aggregate function would force index covering b/c the optimizer in almost all cases would resort to index covering whenever it encounters aggregates quote: talleman: but WTF is a SARG? What is the point MW Edited by - mworku on 06/19/2003 08:26:10 AM […]

2003-06-19

RE: Special characters

• by James Travis

• SQLServerCentral.com

• Reply

Ok, maybe I missed something all this time but I have never had a special character bother other than ' as long as wrapped in single quotes 'nnnnnn'. So what is everyone running into that I have yet to hit?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-17