"(Pete Cresswell)" <x@y.z> wrote in message
news:lkd4vv89m3cdb5fnlt4rt661c47sb56jdv@4ax.com...
> I rebuilt my machine a few weeks back - re-installed the developer
version...
>
> The app in question can see all it's tables in the SQL back end via ODBC
and
> everything looks normal via Enterprise Manager, but I can no longer create
> an ADO Connection.
>
> Source code is unchanged, what's changed is the PC rebuild and consequent
> re-installatin of SQL Server developer version.
>
> I suspect it's something to do with the provider (at least that's the only
thing
> I can see in the .Connect string that's not verifiably correct....)
>
> The error looks like this after I trap and format it:
>
> -----------------------------------------------------------------
> 12/30/03 21:34:30v0.71 Userid: UPQC on SAG
> Proc: basADO: ADO_ConnectionCreate
> -2147467259: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does
> not exist or access denied.
> Errors encountered when trying to connect:
> ''''''''''[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or
> access denied.
>
> ----------Connect String:
> Provider=SQLOLEDB.1;SERVER=SAG;DATABASE=TRETS;UID=Trets;PWD=trets
> -----------------------------------------------------------------
>
>
> Can anybody see anything obvious to look for?
>
> I'm thinking I need to know how to verify/validate the presence of
provider
> "SQLOLEDB.1"... But how?
> --
> PeteCresswell