ODBC driver error

I am all of a sudden getting this error message on a
system, when trying to connect to sql server data:
Unable to load SQL Server ODBC driver resource DLL. The
application cannot continue.
I've reinstalled mdac (2.6 and 2.8), but this has not
helped. I need to get this system up and running asap, so
any help would be greatly appreciated.
Thank you,
Tom
PS I posted this first in the ODBC\data.odbc group, but
there doesn't appear to be too much activity there....Hi Tom,
Please check
http://mcse.ms/arch/66/2003/5/790826
http://mcse.ms/arch/66/2003/1/588214
Surely will help.
Sankar Renganathan
DBA, SPAR Group Inc.,
Please reply only to the newsgroups.
This posting is provided AS IS with no warranties, and confers no rights.
"TomT" <tomt@.tomt.com> wrote in message
news:03a901c3d8d7$8e9d5630$a101280a@.phx.gbl...

quote:

---

> I am all of a sudden getting this error message on a
> system, when trying to connect to sql server data:
> Unable to load SQL Server ODBC driver resource DLL. The
> application cannot continue.
> I've reinstalled mdac (2.6 and 2.8), but this has not
> helped. I need to get this system up and running asap, so
> any help would be greatly appreciated.
> Thank you,
> Tom
> PS I posted this first in the ODBC\data.odbc group, but
> there doesn't appear to be too much activity there....

---

|||Sankar,
Thanks for your help. I checked versions of the files,
and then replaced them since there was a mis-match.

quote:

---

>--Original Message--
>Hi Tom,
>Please check
>http://mcse.ms/arch/66/2003/5/790826
>http://mcse.ms/arch/66/2003/1/588214
>Surely will help.
>Sankar Renganathan
>DBA, SPAR Group Inc.,
>Please reply only to the newsgroups.
>This posting is provided AS IS with no warranties, and

---

confers no rights.

quote:

---

>
>"TomT" <tomt@.tomt.com> wrote in message
>news:03a901c3d8d7$8e9d5630$a101280a@.phx.gbl...
so[QUOTE]
>
>.
>

---

ODBC Driver .... User cannot login ...

Although I am not working on the systems right now, while setting up replication, all of a sudden both systems began giving this error when I attempted to access the Web Portal login screen.
Any suggestions.yep...some sql servers when set up may have been set up using collations that are case sensitive, which means that usernames & passwords will be case sensitive also.

Also, make sure the ODBC is set up to use TCP sockets ( if 7,2000 ) or named pipes if 6.5 ...just seems to be better that way.

Also make sure that you have at least one database the login has access to & the login has access granted to it.

Post back if probs.

J.