1. Clarence Chamorro
  2. PowerServer Mobile (Obsolete)
  3. Tuesday, 12 February 2019 04:29 AM UTC

I am writing and app with PB17 and PowerServer. The app connects to Quickbooks database via QODBC. In the IDE of Powerbuilder all the datawindows worked perfect; Retrieving the data from QB database. Thru IDE of powerbuilder 17 I can connect with QB database showing me all the tables. I can view, edit, insert, delete the data.

Now I am trying to connect with Quickbooks database thru PowerServer but firstable the QODBC data source type does not show in the list (do I have to do something else to show it in this list). So if the data source type does not show in the list then I can not connect. It will be greatly appreciated any Advice or pointing me in the right direction to solve my issue.

Regards,

Clarence.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 February 2019 04:39 AM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 1

Hi Clarence;

   The cause is most likely that QODBC is 32 bit in nature and so is the PB IDE. I'm guessing that the PowerServer you are using is a 64 bit version and thus, you would need a 64 bit driver. Unfortunately, QODBC is only available as a 32 bit driver.

   QuickBooks does support 64 bit access but, you would need to use the QRemote driver product instead.

HTH

Regards ... Chris

Comment
  1. Chris Keating
  2. Tuesday, 12 February 2019 14:07 PM UTC
  1. Helpful
There are no comments made yet.
Clarence Chamorro Accepted Answer Pending Moderation
  1. Tuesday, 12 February 2019 23:25 PM UTC
  2. PowerServer Mobile (Obsolete)
  3. # 2

I was wondering wich Data Source Type: should I use but testing it I found that ODBC work perfect, of course after following your advice (using the Qremote utility). It works super good.

Thank you again Dr Pollach.

 

Regars,

Clarence.

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 13 February 2019 01:34 AM UTC
That's excellent news Clarence ... I'm glad that my prescription worked! ?
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.