1. CJ Lai
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 4 May 2020 15:04 PM UTC

Hi all

I am trying to Add Data Source by clicking on the Add button in Add Transaction Object window in the Application Profile Configuration.

I am able to set up a Database Type Profile Configuration (please see attached)

However, I am not able to add any Data Source for my application's Transaction Object with the same input info (screenshot is also attached)

(Note. after clicking Test, it takes about 2-3 mins before the Information popup appears)

 

I came across this post https://bit.ly/3djcpJz 

 

Is there any known and working solution available?

Please help

 

Thank you

 

Attachments (2)
Accepted Answer
CJ Lai Accepted Answer Pending Moderation
  1. Tuesday, 12 May 2020 20:13 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

After digging through Appeon's online documentation, I found that the IP for TCP/IP port setting on our database server was missing. After it's filled in, my data source connection was able to get established. (attached)

 

Thank you all for providing your input. It helped a lot

 

CJ

Attachments (1)
Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Saturday, 9 May 2020 21:23 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

you specifically configured for port 1433 and seem to have a named instance.

Out of the box sql server does NOT specifically use port 1433 for named instances.  The database server  must be set for that port specifically.  

 

Comment
There are no comments made yet.
CJ Lai Accepted Answer Pending Moderation
  1. Wednesday, 6 May 2020 20:39 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

I configured an ODBC driver 64 bit on my Win 10 (attached) successfully. Why do I not see any in the Data Source dropdown in AEM? (also attached)

 

Please help

Thanks!

Attachments (2)
Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 6 May 2020 20:50 PM UTC
Hi CJ .. as per the PowerServer documentation, you cannot use ODBC to connect through to SS. You *must* use the built-in PS Native driver for SS.
  1. Helpful
  1. CJ Lai
  2. Thursday, 7 May 2020 12:42 PM UTC
Thank you, Chris, for this info. I am glad you told me that so I can add it to my documentation for my database server people to help me.
  1. Helpful
There are no comments made yet.
CJ Lai Accepted Answer Pending Moderation
  1. Wednesday, 6 May 2020 17:05 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

I tried to establish the Data Source in AEM

I used Both the credentials to the server itself and the database on the server. Unfortunately, they both failed. (please see the attached Error)

Please help

Thanks

Attachments (1)
Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 6 May 2020 18:49 PM UTC
This is SQL Server configuration issue. Your PowerServer is configured correctly.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 4 May 2020 18:11 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

Hi CJ;

  The problem could probably because your do not have both the 32bit and 64bit SQL Server DB Client software installed. In the App Profile that you run within the PB IDE confines, the connectivity is 32bit. In the PowerServer environment, the DB connectivity is 64bit.

Regards ... Chris

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 5 May 2020 21:05 PM UTC
Hi CJ .. Yes, the DB Profile set-up & check worked in the PS Toolkit's App Profile because the toolkit is run underneath the PB IDE and thus, 32 bit in nature (like the DB Profile and DB Painters in the IDE). The DataSource in AEM (and thus running underneath PS) requires a 64bit DB driver to be installed. HTH
  1. Helpful
  1. CJ Lai
  2. Wednesday, 6 May 2020 12:29 PM UTC
Thank you, Chris



I verified that my DB server is running as 64bit.

Now that's clear, I am more confused and frustrated than ever...



Since my DB server is running on 64bit, why can I not establish a data source in PwerServer? Is there some docs about this or secret settings that I don't know about?...



Not venting at you; I appreciate your input.



CJ

  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 6 May 2020 18:02 PM UTC
My best guess is that the SQL Server 64bit DB Client is still somehow not available on the PS Server machine.
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.