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 - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Logging into copy of SLX database?

Brian Smith
Posts: 18

Logging into copy of SLX database? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Jun 08 1:11 PM

I just duplicated our production SLX database for the purpose of testing an external app. I would have used the eval database but I need our real production data in there. I've configured it in the connection manager and that connects fine. I can also connect to it via Administrator with no problem. However, I'm getting the "Unable to initialize data dictionary" error when I try to connect via Client. I read the other posts regarding this error but the circumstances do not apply. Does any one have suggestions? I'm running 7.2 SP2 with SQL Server 2000. Thanks!

[Reply][Quote]

Todd Herman
Posts: 52

Re: Logging into copy of SLX database? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Nov 08 8:21 AM

Brian,

Did you find a root cause for your scenario? I am dealing with this error message, but cannot get to the bottom of it. It comes back after a while, basically once a day in a testing environment for 7.2.2 I've tried everything else I can find on the error, with no fix yet.

[Reply][Quote]

Brian Smith
Posts: 18

Re: Logging into copy of SLX database? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Nov 08 9:19 AM

I never did find a fix for it. I finally gave up and just tested my app against production. Good luck!

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Logging into copy of SLX database? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Nov 08 3:21 AM

When you restore a database - you must run the sysdba fix. A simple test is to go into Query Analyser/Studio as sysdba and execute "select * from userinfo". NB: There is deliberately no prefix (sysdba.userinfo) and there should not be. If all goes well, you will get data back - otherwise, it will complain.

[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): 11/25/2024 2:49:03 PM