Re: [plum] SQL Server 2005

[Jeff Fleitz]

Just as a follow-up, I was finally able to get CF to talk to the pubs database in SQL Server 2005 via a ODBC socket connection.  Don't know why the java driver won't work, but that is a different topic.

I was able to create a sample Plum project against the MS SQL 2005 database, add a table and then re-synch the database no problem.

You did change the db reference in the Plum project file, right?

Jeff

On 12/22/05, Jeff Wells < [EMAIL PROTECTED]> wrote:

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

 

--
v/r,

Jeff Fleitz