Are you getting a specific message when you try to connect? If the service is set to always start Automatically, it will do so each time the server is shut down and restarted. I have a 64bit SQL Server. Most popular Most popular Oldest to newest Newest to oldest. I created the odbc connection and tested and it was successful, but when I go to connect a new database in Sage CRM and try to save it, I get a “unable to connect to database” message. The short cut to manage Data sources can be accessed.

Uploader: Tulrajas
Date Added: 27 March 2005
File Size: 63.89 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 72053
Price: Free* [*Free Regsitration Required]

For example, no matter who logs onto the machine, system DSNs can be seen by all users, and they are stored in the Local Machine section of the Registry. For more information, see the Related Resources section below. The instance in which this applied in my situation, the ODBC lookup wasn’t really in a load intensive environment. I created the odbc connection and tested and it was successful, mss when I go to connect a new database in Sage CRM and try to save it, I get a “unable to connect to database” message.

This article is just one of several that explain how data in a back office system can be surfaced within Sage CRM. Mmas workflows are exceptionally fast compared to what it was before since the native processes have taken over from having to use scripts.


Prefix for data files: Is there a known workaround for this problem? Please wait while this file loads, or download it here. I had to provide the basic information. This article maybe helpful community. I needed to establish a connection to the Sage cloud database to allow me to check details about a customer record within the integrated system.

Modifying Windows security incorrectly can severely affect system operations. Sage requires membership for participation – click to join. I have been able to do this in several other installs.

Wouldn’t this result in a degraded performance install since the server achitecture is x64? Finally to be sure that my settings were correct I tested them using the “Test Connection” button on Debug tab. Does anyone have a work around? I don’t know what to do.

Glad to see you got it sorted Brian! I set up the DSN just as described in the article and the connect test passed. A System DSN works for anyone using that system.

I’m running Version 7. Then try but bit driver install again, as Admin, making sure the pre-req for that gets installed too.

All All Resolved Unresolved.


Sage Support 64bit Office (64bit ODBC driver)

I’m about to pull down a trial version of MAS90 into my sandbox, but before I do this, I wanted to see if there might be an answer that requires less extreme troubleshooting.

Decide which to use before proceeding. I then made sure the information within the options tab was correct. This solution requires advanced knowledge of your computer’s operating system.

ODBC Drivers for MAS 90 and MAS 200

If you are running an antivirus application on either end, try temporarily disabling or uninstalling it from both. State Not Answered Date schnauzerlove.

Forms and reports will print significantly faster from remote workstations. I only need to open the connection to view data and I am not proposing to by pass business logic; I would not use the ODBC connection for data manipulation only for reading. The ODbC connection will not connect through the web portal. Did you notice a reduction in performance using the x32 variant?

Guess the X32 bit burning in my brain wasn’t too far off.