> Hope someone out there can tell me what is wrong. I recently upgraded
> a system to test out if things would work, and I am having no success.
>
> It seems that I cannot get a DS verified by the CF Administrator. I
> created the datasource via ODBC Manager and it created successfully
> with the username/password. Also tried accessing the machine from
> numerous machines via Enterprise Manager and they all seem to work.
> But CF won't budge.
>
> I get this error, perhaps someone is more familiar with it:
> Cannot generate SSPI context
SSPI is the new Microsoft security layer: Security Support Provider
Interface. This is only used by DCOM connections, as far as I know, and
shouldn't affect what you're trying to do. I've been able to connect to SQL
6.5 and 7 databases from Win2K without any trouble, even before I fixed my
broken MDAC problems.
Did you try creating the datasource from within the CF Administrator?
In the ODBC Manager configuration, are you using a specific username and
password, or a trusted connection?
Are you accessing this datasource via the default network protocol (usually,
named pipes)?
One other thing you might try is the Microsoft Data Component Checker. This
will run through your MDAC component setup, and report any configuration or
file errors it finds. You can get it from http://www.microsoft.com/data/.
You'll get a few errors you can safely ignore - it will tell you that it's
looking for one file version, but you've actually got a newer version;
that's ok.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
