Hi
This problem seems similar to SQLXML problem which i posted yesteday.
We are testing our 32-bit .NET application on 64-bit environment ( 64-bit AMD Processor + 64 bit Windows 2003 Server + 64 bit .NET Framework + 32-bit Application).
This application uses SQL Server 2000 notification services.
We register the notification client on web server using NSCONTROL.EXE
Code works fine on 32-bit servers, but on 64-bit servers it is giving following exception.
Exception Details: Microsoft.SqlServer.NotificationServices.NSException: The registry entries for the specified instance of Notification Services could not be found.
we tried by installing notification services component of SQL Server 2005.
After that above registry error goes but following error comes:
System.Data.SqlClient.SqlException: 'schema_id' is not a recognized function name. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata.ValidateStoreExists(SqlConnection sqlConnection, Boolean createStoreIfAbsent) at Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata.FetchMetadataForInstance() Notification Services failed to get the metadata for the specified instance. Instance Name: CafePlace SqlServerError: Source: .Net SqlClient Data Provider Number: 195 State: 10 Class: 15 Server: Parag1 Message: 'schema_id' is not a rec Microsoft.SqlServer.NotificationServices at Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata.FetchMetadataForInstance() at Microsoft.SqlServer.NotificationServices.Common.InstanceMetadata..ctor(String serverName, String instanceName, NSSecureString userName, NSSecureString userPassword) at Microsoft.SqlServer.NotificationServices.NSInstance.Initialize(String instanceName, String serverName) at Microsoft.Msdn.Workspaces.Notifications.NSUtility..ctor() at Microsoft.Msdn.Workspaces.Notifications.UserGeneralMailNotifications.AddUserGeneralMailSubscription(String subscriberId) Void FetchMetadataForInstance()
To run notification services on 64-bit windows what i need to do.
Please reply asap.
Thanks in advance.
Regards
Gagan

SQL server Notification services client does not work on 64-bit os