1. Sabir Foux
  2. PowerServer Web
  3. Sunday, 25 August 2019

Hello,

We recently installed SQL SA 16 and loaded our data onto this new version coming from SQL SA 9. We were going through the deployment wizard provided by the PowerServer ToolKit when we reached the part to add a transaction object. We could not find the data source type of SQL SA 16 Native Driver although we certainly do have SQL SA 16 installed. Is there a certain process we have to follow to install a driver? Or are we missing something else we haven't thought of yet?

 

Thank you

Accepted Answer
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Sabir;

  PowerServer will need the 64bit db client to be installed. I suspect that all you have is the 32bit client. If so, just rerun the SA 16 install again and select the missing client bitness. 

HTH

Regards ... Chris

Comment
There are no comments made yet.
  1. Sunday, 25 August 2019
  2. PowerServer Web
  3. # Permalink
Sabir Foux Accepted Answer Pending Moderation
0
Votes
Undo

Hi Chris, thanks for your quick reply.

Unfortunately, after I ran the SQL Anywhere 16 Developer edition install file and clicked the modify button I saw that the 64bit version was indeed installed already and the 32bit version was left out. I ran through the install process again just to be sure but even so we're unable to get AEM to detect the SA 16 Native Drivers.

Do you know of any other troubleshooting steps we could take?

Comment
Make sure that it's the DB "client" 64bit driver and not the DBMS itself - which would default to 64bit. The "client" is the key.

Also, rerun the PS install and select the demo DB & Apps. That should also force the PS installer to verify the SA16's 64bit readiness.
  1. Chris Pollach
  2. Sunday, 25 August 2019
There are no comments made yet.
  1. Sunday, 25 August 2019
  2. PowerServer Web
  3. # 1
  • Page :
  • 1


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