MSDE 2000 and x64 (WinXP 64 Bit)

Hi,
I do have MSDE 2000 (sr 3a) installed on a 64bit version of WinXP (x64).
Installation worked ok. Selfwritten client-code works ok with a 32bit
application in WOW. So far so good.
Then I ported my client code to native 64bit...compiled ok...but the
64bit-client can not connect to local MSDE desktop engine...connection to a
remote server works ok.
The OLEDB provider for SQLServer is 64bit...I've checked that. Error code
that I get is:
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."
Authentification is "integrated" and works in a 32bit-client. So should work
in a 64bit-client, too. Right? What am I doing wrong?
Thanks
Frank
hi Frank,
Frank wrote:
> "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied."
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks! That did the trick. There were no activated server-protocols
(TCP/IP, Named Pipes, etc.). So I assume the 64bit-client tried to connect
through "shared memory"-access which obviously won't work with a 64bit-client.
Now the 64bit-client connects to the server through loopback interface which
I originally don't wanted but it works for now.
By the way: I am using your DbaMgr tool...it's great!
|||hi Frank,
Frank wrote:
> Thanks! That did the trick. There were no activated server-protocols
> (TCP/IP, Named Pipes, etc.). So I assume the 64bit-client tried to
> connect through "shared memory"-access which obviously won't work
> with a 64bit-client.
> Now the 64bit-client connects to the server through loopback
> interface which I originally don't wanted but it works for now.
> By the way: I am using your DbaMgr tool...it's great!
thank you... please feel free to (privately) contact me for any question or
concern about DbaMgr prj..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply