[plum] SQL Server 2005

[Jeff Wells]

Curious if anyone has migrated a current plum project (and site) to SQL Server 2005?  My current problem is that ColdFusion can connect to the database just fine but when I go into my already existing Plum project and attempt to sync the DB, no luck.  The exact error is: [DBNETLIB][ConnectionOpen (InvalidInstance()).] Invalid connection.   I’ve Googled this error message and I get a bunch of stuff on TCP/IP ports and Named Pipes and even stuff on DBNETLIB and worm viruses all under SQL Server 2000 not 2005, none of which makes any sense since my ColdFusion server can connect just fine.   More details:  in my Plum project I have verified that Environment, ColdFusion Data Source AND Database properties are using the same mapping, username, password as CF (and it worked fine under SQL Server 2000).  Again, my exist site works fine and CF Admin verifies the data source.   If anyone has any hints, tips, tricks or .45 caliber bullets it would be greatly appreciated.  (My apologies if this has been covered before on the reflector, I’m on a new laptop and don’t have access to the past issues).               -Jeff