Sometimes there can be challenges to linking to external databases because of quirks such as the Database being case sensitive. This opened a dialog box that asked me to select the driver to be used for the new Data Source. View Download Go to post Delete. A System DSN works for anyone using that system. Has anyone a detailed solution for the settings to enable this? I am trying to do this very thing but I have one small problem.

Uploader: Kajihn
Date Added: 25 October 2007
File Size: 56.6 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 12362
Price: Free* [*Free Regsitration Required]

Connecting to an External ODBC database e.g. Sage 100cloud

But something is burning in the back of my brain on this one I saw where someone said the IIS user permissions were different but I have full admin rights on both machines and still no luck. This may be because the service but still processing the operation or because the service was unable to send a reply message.

I set up the DSN just as described in the article and the connect test passed.

I then went into Workflow designer and used a blank workflow and added a Query object and began performing the tasks to utilize the ODBC connection. Although I am working with the Sage cloud I am going to keep things as simple as possible.


It can be stopped by clicking the “Shutdown” button. Click Start to start the service, then click OK to exit Properties. Sage requires membership for participation – click to join. If the other service is not needed, delete it.

Decide which to use before proceeding. Could this be 09 permissions issue?

MAS 90 ODBC – Laserfiche Answers

Most popular Most popular Oldest to newest Newest to oldest. Sage is not responsible for operation 990 caused by incorrectly modifying your Windows security. Enclosing the table name in [] did not fix anything. I found the information provided by the Connection string useful when setting up a linked server.

I have a 64bit SQL Server. They both reference the proper driver dated Are you getting a specific message when you try to connect? The client and myself both recall that the issue was something very very small, like a grain of sand on the beach, but we both have lost all notes and records to the exact “thing”. 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.

64 bit ODBC driver install on SQL Server

Additionally, all documentation I am finding indicates that the system ovbc going to force the 8. If nothow can I establish this goal? In the Production environment, under the x32 C: But on the face of it, there didn’t seem much difference to be honest Then try the bit driver install again, as Admin, making sure the pre-req for that gets installed too.


Anybody found an answer to this one. Is a free port you may need to run netstat -ab to determine this? User DSNs work only for a specific user on a machine.

A System DSN works for anyone using that system. All All Resolved Unresolved. I also have tried deleting the user dsn. The workflows are exceptionally fast compared to what it was before since the native processes have taken over from having to use scripts.

ODBC Drivers for MAS 90 and MAS

Odc CRM can connect to wide variety of database types. Prefix for data files: I then tried to create a new table connection and received the following error:. 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.