MS SQL Server 2005 64 bit CTP:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o

I am facing a problem with SQL Server 2005 64-bit CTP June 2005 on Windows 2003 64 Bit.

When i try to connect to the SQL Server Instance using any of Windows/SQL Server Authentication from My Application using SQLOLEDB interfaces (From Win32 Code) it is not able to connect and throws following error:

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

When in the same code I use SQL Native Client (SQLNCLI), it is able to Create and Initialize the interfaces.

When i tried to research on this issue, i found out in Books Online SQL Server 2005 CTP June 2005. That this release only supports SQLNCLI and MDAC support has been removed for this release on 64 bit Windows.

The article says:
"SQL Native Client (SNAC) is available on the 64-bit platform. MDAC has been removed for this release."

Reference:
Books Online Microsoft SQL Server 2005 CTP June 2005
See Topic: "Differences Between 32-bit and 64-bit Editions of SQL Server 2005"

(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/e0556daa-19cb-4c08-af02-f542641365a5.htm)

Please let me know if any of you have similar problem. Is there any solution to this other than using SQLNCLI.

I did have similar issue that could not register several Yukon servers from one big brother server. After a little research, solution to the issue was Windows 2003 SP1.

Now, I am facing another issue which is deal with MDAC in 64 bit environment. I've got Win 2003 SP1 64bit and Yukon April CTP i64. One of developer trying to deal with distribute query against to an excel file, it returns an error

"The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. "

I looked around and realized that we don't have much ODBC driver available from that 64 bit box. Only available drivers are SQL Native Client and SQL server.

I ran Component checker and it found MDAC2.8 SP2. I also tried to install Jet40 SP8 64 bit, but it say no install needed because there is a newer verion found on system. When I try to create a new data source, I don't have much selections but only two.

As you stated that we don't have much control on MDAC nor Jet40 at this stage. And I've been look for a workaround but no luck yet last two days.

I am keep looking and will post here to imform you if I find some thing.

Thanks
Sunny

|||Hi, Deepak,

Thank you for reporting the problem. Can you tell us:

- is your SQL Server 2005 a default instance or a named instance?
- How do you specify the server in your connection string (the server name, ".", "(local)", etc.)?
- What protocols are enabled on your SQL Server 2005 (TCP/IP, Named Pipes, Shared Memory)?

Thank you,
Peter|||

iam facing this error message kindly assit

Thank you