RE: MSSQL Connection question
- From: "Mark S." <MarkS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 Sep 2005 11:55:32 -0700
Not for OLEDB, you can do something like that for ODBC.
Mark
"Jeff" wrote:
> I have the following in some code:
>
> Set objConnection = CreateObject("ADODB.Connection")
> objConnection.open "PROVIDER=SQLOLEDB;DATA SOURCE=(local);INTEGRATED
> SECURITY=SSPI;DATABASE=meta"
>
> What I would like to do is pick up the properties from a Microsoft OLE DB
> Provider for SQLServer that I already have defined in the package.
>
> I am looking for something like this...my connection is call Test.
>
> objConnection.open "Test"
>
> Is there a way to do this?
>
> Thanks,
> Jeff
>
>
>
.
- References:
- MSSQL Connection question
- From: Jeff
- MSSQL Connection question
- Prev by Date: RE: Getting Column Order MS Access, or Copy Table
- Next by Date: Connecting to an Excel spread*** via HTTP
- Previous by thread: MSSQL Connection question
- Next by thread: Connecting to an Excel spread*** via HTTP
- Index(es):
