For my simple app, I added a new setting named ITworldConn, changed the Type to (Connection String), and Scope to Application. To finish your new connection setting, click the small ellipsis button.

However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect to SQL.<BR><BR>So, instead of specifying a SQL account in teh connection string ...

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the ...