ODBC and Windows 98

We set up a MSDE 2000 database on a Windows 98 machine. We're trying to
connect to the W98 DB from a XP machine using an ODBC and a Windows
authentication. We get the following error when trying to test-connect the
DB:
SQL Server error 18452 : Login failed. Not associated with trusted SQL
server.
The machines are on the same workgroup, and we made the Windows logins and
passwords the same as the SQL logins and password. What is the issue, and
can it be solved?
Thanks,
Matt
I forgot to mention that the ODBC is in mixed mode.
Matt
"Matt" <mrocha@.camicro.com> wrote in message
news:uC8%23XqNKFHA.1540@.TK2MSFTNGP14.phx.gbl...
> We set up a MSDE 2000 database on a Windows 98 machine. We're trying to
> connect to the W98 DB from a XP machine using an ODBC and a Windows
> authentication. We get the following error when trying to test-connect
the
> DB:
> SQL Server error 18452 : Login failed. Not associated with trusted SQL
> server.
> The machines are on the same workgroup, and we made the Windows logins and
> passwords the same as the SQL logins and password. What is the issue, and
> can it be solved?
> Thanks,
> Matt
>

ODBC and Windows 98

We set up a MSDE 2000 database on a Windows 98 machine. We're trying to
connect to the W98 DB from a XP machine using an ODBC and a Windows
authentication. We get the following error when trying to test-connect the
DB:
SQL Server error 18452 : Login failed. Not associated with trusted SQL
server.
The machines are on the same workgroup, and we made the Windows logins and
passwords the same as the SQL logins and password. What is the issue, and
can it be solved?
Thanks,
MattI forgot to mention that the ODBC is in mixed mode.
Matt
"Matt" <mrocha@.camicro.com> wrote in message
news:uC8%23XqNKFHA.1540@.TK2MSFTNGP14.phx.gbl...
> We set up a MSDE 2000 database on a Windows 98 machine. We're trying to
> connect to the W98 DB from a XP machine using an ODBC and a Windows
> authentication. We get the following error when trying to test-connect
the
> DB:
> SQL Server error 18452 : Login failed. Not associated with trusted SQL
> server.
> The machines are on the same workgroup, and we made the Windows logins and
> passwords the same as the SQL logins and password. What is the issue, and
> can it be solved?
> Thanks,
> Matt
>

ODBC and SQLServer : does I need the client installed on ?

Hi,

Does I need to install the mssql client binaries to use ODBC to
connect to a mssql database ?

TYIA
rjp"rjp" <rjp.l@.laposte.net> wrote in message
news:9b7a7215.0402100934.5fe5b830@.posting.google.c om...
> Hi,
> Does I need to install the mssql client binaries to use ODBC to
> connect to a mssql database ?
> TYIA
> rjp

You should be able to use the latest version of MDAC - there's a link from
this page:

http://msdn.microsoft.com/data/

Simon|||rjp (rjp.l@.laposte.net) writes:
> Does I need to install the mssql client binaries to use ODBC to
> connect to a mssql database ?

ODBC comes with MDAC that comes with Windows, so you don't need to install
anything - if you are on a Windows box, that is. (And it's a decently
modern version of Windows. Windows 95 is not likely to have any MDAC.)

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp