upgrade to sql2K can't login to Macola

[debbieo]

We upgraded to SQL Server 2000 last night and now the only users that can log in to Macola are those using PC's where we forgot to upgrade the SQL Server Client to 2000, they are still SQL Server 7 (client connectivity).
The error is:

Severe COM/ADO error occured in MacMSS.dll
DB Provider Error: Native Error number:0
Error number: 0x00000000
MSLLOCKDBNative Error number: 207
Error number: 0x80040E14
Invalid column name 'MacMSS'.

COM Error: Error
Code = 0x80040E14
Code meaning = IDispatch error # 3092
Source = Microsoft OLE DB Provider for SQL Server
Description = Invalid column name'MacMSS'.

Any ideas?

 

[kscheeler]

It's possible that you are missing a stored procedure that Macola creates in the Master database. It's called sp_macmsslockeraser. If it's not listed under the Master database, run the following script using query analyzer against the master database to create it.

-------------------------------------
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE sp_MacMSSLockEraser
@dbname varchar(30),
@cur_spid smallint = NULL
AS
/* This Procedure will remove all orphaned records out of the
the MacLocks table of the specified database. This will be executed
each time a user launches a new app using the MacMSS.DLL
*/
DECLARE @lspid varchar(11)
SET @lspid = CAST(@cur_spid AS varchar(11))

BEGIN
PRINT @dbname
EXEC("delete from " + @dbname + "..MacLocks where SessionID not in
(select spid from master..sysprocesses where program_name = 'MacMSS')")
EXEC("delete from " + @dbname + "..MacLocks where SessionID =" + @lspid )
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
------------------------------------------

Kevin Scheeler

 

[grossow]

Also, upgrade your clients to MDAC 2.8.