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 - Synchronization
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Synchronization | New Thread

View: Search:

Author

Thread: Can a DB view be pushed out to remotes in any way?

Marc Johnson
Posts: 252

Can a DB view be pushed out to remotes in any way? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 May 07 3:22 PM

We created a specific view in the database to create a Crystal Report. It works great in house but I just realized the admin who needs to run it is on a remote DB. Thoughts?

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Can a DB view be pushed out to remotes in any way? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 May 07 3:57 PM

Looks like we figured out how to do it, so I answered my own question. We used ADO Explorer to connect through the SLX provider and then created the view. Seems to have worked. We won't be accessing the view through SLX but rather a Crystal Report.

The only unknown at this time is our master DB is Oracle. I don't think the remotes (being MSSQL) will have any problems with the script but my fingers are crossed.

BTW, we could not run the SQL create view script in the Execute SQL form. I found that interesting.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Can a DB view be pushed out to remotes in any way? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 May 07 7:29 AM

Quote:

Originally posted by Marc Johnson

.......
BTW, we could not run the SQL create view script in the Execute SQL form. I found that interesting.

Not suprised.. Not all SQL will pass the "provider muster".
--
rjl

[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 4:41:38 PM