(q)odbc setup on terminal server Reckon Enterprise 2017

  • 1
  • Question
  • Updated 1 year ago
I'm a bit confused on the setup for accessing data in Reckon Enterprise 2017 using ODBC. I've seen it mentioned that the connector is included with Enterprise, but I don't see the correct menu options. 

Should I be downloading and installing QODBC driver on the Windows Server 2008 where the Reckon DB is hosted? We are only interested in getting read access, to use for projections.

Has anyone had experience with doing a similar setup ( we use win 7 clients with Reckon installed to access the company files normally)?

I believe I need to install QODBC and QRemote on the server, and then should be able to connect using any ODBC app from a client.
Photo of Daniel F

Daniel F

  • 180 Points 100 badge 2x thumb
  • Confused

Posted 1 year ago

  • 1
Photo of Rav

Rav, Community Manager

  • 64,790 Points 50k badge 2x thumb
Hi Daniel,

Admittedly, I don't know too much in this area but check out this KB article, does it help at all?

QODBC download for Reckon Accounts Business
HI Daniel , call me on this pls if you have still issues 0407068942, Chandra
Photo of David Robertson

David Robertson

  • 350 Points 250 badge 2x thumb
Hi Daneil

Hi

Start your ODBC installation under File \ Utilities \ Configure ODBC. You have to be in single user mode and as a starting point select company file now open. Follow the process with clicks and it should work first time and you will get a message Test Connection successful. You can then access Reckon data via Excel ODBC.

I have been using ODBC and other report/ data down loads from Reckon for use by a reporting package called fast Reports.

Give me a call if you want to know more about this David - 0413 837 865

Photo of Daniel F

Daniel F

  • 180 Points 100 badge 2x thumb
Hi David,

Thanks for that. Is the server you have Reckon installed on 32 or 64 bit? And if 64, did you need to install QRemote to get it to work?
Photo of David Robertson

David Robertson

  • 350 Points 250 badge 2x thumb
Hi Daniel,
It was a 32 bit machine. I never had to install QRemote
Photo of Daniel F

Daniel F

  • 180 Points 100 badge 2x thumb
Can someone explain to me why, when logged in as Admin to Reckon Enterprise, I only see File \ Utilities \ ODBC Solutions in the menu, not the aforementioned "Configure ODBC"?
Photo of David Robertson

David Robertson

  • 350 Points 250 badge 2x thumb
Hi Daniel

I looked at my notes  on QODBC and here they are

Download QODBC from Flex

Save downloaded file

Run the install program

Previously when u downloaded this file it had an .exe extension

When u download it now it has no extension, so if u try to open it windows asks what do I open it with

Does not find flex

So u add exe extension, and the program installs,

Regards

David

Photo of Daniel F

Daniel F

  • 180 Points 100 badge 2x thumb
OK, thanks David. I didn't realize I needed to install from flex before getting that menu option.