slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Upgrades
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Upgrades | New Thread

View: Search:

Author

Thread: Exception EOleException: Invalid Column Name 'caption'

Erik Krevh
Posts: 2

Exception EOleException: Invalid Column Name 'caption' Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 09 1:30 PM

I am just trying to put together a test for an upgrade from Version 6.2.3 to 7.5. I have restored a copy of my database onto SQL 2005, set up my connection to the database in Connection manager. When I try to log into admin & client, I get the error. I saw an article poster on here that sounded like people were suggesting to run the syncserver, but we do not have any remote clients, so I don't think that would apply. Besides, I cannot open the sync server manager, when I try to log into that I get the message 'Error attemtpting to log into database. Invalid Column name 'Caption'. I have gone through the upgrade documentation, and have no idea what I am missing. ANyone have any ideas?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Exception EOleException: Invalid Column Name 'caption' Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Mar 09 7:13 AM

Aren't you following the SalesLogix procedure for 6.2.x to 7.5.0 upgrade process? You don't need to move to SQL2005 to do an upgrade to 7.5.

--
RJLedger - www.rjlSystems.net

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Exception EOleException: Invalid Column Name 'caption' Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Mar 09 3:30 PM

You need to convert your database using the conversion routine provided on DVD - you need to install 6.2 *first* - you can't run 7.5 from new with your database at this level.
It needs the provider to run the conversion. Then you upgrade to 7.5.

It's in the 6.2 to 7.0 bundle (added as part of the conversion)

TableNameLOOKUP FieldNameCAPTION

Regards
Mike

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/5/2024 9:47:27 AM