Global Drivers

Connect to Sage 50—U. The data source can be seen in Spotfire’s SourceView: Haven’t found what you are looking for? One use case for this is when moving between a test and a production database. I have searched for a solution to no avail.

Uploader: Shakara
Date Added: 23 December 2010
File Size: 59.56 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 58421
Price: Free* [*Free Regsitration Required]

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. The new 2 table is visible in the SourceView. I am using Peachtree Complete Accounting Close this window and log in. YOu can do the same test on the container.

How do I connect to the program using ODBC/OLEDB?

Replacing an ODBC data source while keeping data transformations intact A common enhancement request is the ability to replace Spotfire’s ODBC data sources while keeping data transformations and calculations based on the data table intact.

Server is 64 bit and workstation is 32 bit. This is where the 32 bit odbc manager is: Idbc Sage Intelligence Blog.

Keith, I don’t know how to get to the Pervasive control center. Give the data source a name.

  CHAINTECH ES-675M DRIVER DOWNLOAD

How to create ODBC DSN drivers for Sage BusinessWorks

I’d assume you make a bjsinessworks DSN”, but what file exactly does it point to? This is not yet possible without the workaround below but please vote for the idea here. Select the Use Data Link File check box. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Connect to Sage 50—U. Choose Refresh Data – With Prompt from the menu to the right in the dialouge.

It’s easy to join and it’s free.

Select a table from the list, click Nextand click Finish. Before you can connect to your ODBC data source in Spotfire, there are a few prerequisites to keep in mind. However, I need to tell the client how busienssworks set his end up, and how to set up our end.

How to create ODBC DSN drivers for Sage BusinessWorks

Please make sure that there are sufficient user permissions on the alchemex. That said, it’s a simple way for you to simulate a production SAM pool.

I understand that the underlying Pervasive. Then double click on any of the buinessworks and confirm no errors occur. In the Specify Tables and Columns dialog, specify what data you want to include by selecting the checkboxes of the tables and columns in the list.

  EN8600GT SILENT/HTDP/256M/A DRIVER

When you do the ODBC connection, do you have to pass a username and password? Please busijessworks your Sage business partner, network administrator, or accountant for assistance. Wildcard Characters in Sage Intelligence.

Can you open up report manager and check system variables. Click Here to join Tek-Tips and talk with other members! Enter the User Name and Password on the login window. If you have stored the username and password in the DSN you don’t need to enter them in Spotfire’s dialog below. I don’t know how to get to the Pervasive control center. Skip to main content.