ODBC Connection

tadNew Member

I would like to report off of the Maximizer 7 database. When I connect via ODBC I do not see any of the MAX files available. Is there are way to access these files so that I can use Crystal Reports?

10/23/028:07 PM

❤️ 0

Original Post

Replies sorted oldest to newest

jschoddeNew Member

I can see the tables using the ODBC driver and I'm also using Crystal Reports 8.5. My problem is that I don't know how to relate the tables (i.e. "link" them in Crystal).

Does anyone have a relation diagram?

-Jeff

1/4/0311:44 PM

❤️ 0

pillpopperNew Member

Just your regular OCBC connetion will gain you access to the tables. If your using Pervasive you will have to use the pervasive views because you can't hit the table directly. SQL is easy though, keep in mind SA wont work use the MASTER user or another authenticated Max User. All reg tables are linked by Client_ID and Contact_Number, opp related are Opp_ID and Opp_number. Good Luck.

1/15/032:01 AM

❤️ 0

Add Reply

<ul id="{%=id%}ButtonGroup" class="button-group h-popup-buttons even-button-group even-1">
    <li id="{%=id%}Okay_buttonContainer"><a id="{%=id%}Okay" href="javascript:void(0);" class="button success no-margin-bottom h-alert-modal-ok-button" role="button">OK</a><script type="text/javascript">
        (function() {
            function {%=id%}Okay_click(event, data) {
            {%=id%}Popup.hide();
        }
        
                $('#{%=id%}Okay').on('click', {%=id%}Okay_click);
        })();
    </script></li></ul><a href="javascript:void(0);" class="close-reveal-modal" aria-label="Close Modal">&#215;</a><div class="last-modal-focus focus-utility-element" tabindex="0"></div>
</div>
<script type="text/javascript">
        (function() {
            {%=id%}Popup = new SS.Popup.ModalPopup('{%=id%}');
        })();
    </script>

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...