Cannot create ADO connection to DB anymore...

[(Pete Cresswell)]

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

[John Bell]

Hi

Maybe it's a SID type problem! Have you tried a trusted connection?

John

"(Pete Cresswell)" <x@y.z> wrote in message
news:lk********************************@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