Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (8)

Resolved How to get ODBC Data Source to appear in Profiles\Add Data Source

  1. How-to
0
Votes
Undo
  1. Tom Peters
    Tom Peters
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 8 October 2018 13:03 PM UTC

Howdy!

I am trying to use a 32 bit ODBC Data Source in the PowerServer Web Toolkit, but I cannot get my Data Sources to appear there.

I have tried adding 32 bit sources (SQL Server 11.0) to my User DSN and System DSN, but neither appear in the toolkit when I go to Data Source Profiles/Add... I select ODBC Driver, but in the ODBC Data Source the only DSN I see are the SQL Anywhere CustDB and Demo DSN.

I have not been able to find anything in the documentation about how to set up your own SQL Server DSN and then using them in the PowerServer Web Toolkit.

Any assistance would be appreciated. 

Thanks,

Tom

  1. PowerServer Web
Is there any type of debugger output in PowerServe...
Other app server support?
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 13:19 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Tom;

   Make sure that you declare your DSN's a SYSTEM based ones - not User.

Regards .. .Chris

Comment
Tom Peters
  1. Tom Peters
  2. Monday, 8 October 2018 13:29 PM UTC
Hi Chris -

Thanks. I have tried system DSN. >> I have tried adding 32 bit sources (SQL Server 11.0) to my User DSN and System DSN

Even when it's a System DSN it's not appearing. Is SQL Server 11.0 the wrong driver for the ODBC DSN?

Thanks,

Tom
  1. Helpful
There are no comments made yet.
Responses (8)
Tom Peters
Tom Peters Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 13:27 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Chris -

Thanks. I have tried system DSN. >> I have tried adding 32 bit sources (SQL Server 11.0) to my User DSN and System DSN

Even when it's a System DSN it's not appearing. Is SQL Server 11.0 the wrong driver for the ODBC DSN?

Thanks,

Tom

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 13:36 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

are you sure you installed 32 bit powerserver?  (why is this even offered anymore?)

if it is 64 bit powerserver than setup 64 bit dsn  system connections.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 8 October 2018 13:39 PM UTC
Hi Mike;

Both the PB IDE & and its PS Toolkit are 32 bit - even though PS is 64 bit.

Regards ... Chris
  1. Helpful
mike S
  1. mike S
  2. Monday, 8 October 2018 13:47 PM UTC
yeah, i didn't read 'toolkit'.



Tom, you are going into the db profiles tab of the toolkit configuration in powerbuilder?

or are you talking about the 'data source profiles' tab? If it is the data source profile tab, then you need to connect using the AEM website to set those up on powerserver.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 13:43 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Hi Tom;

  Did you configure SS in the PS Toolkit?

1) 

2)

Regards ... Chris

Comment
There are no comments made yet.
Tom Peters
Tom Peters Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 13:51 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

Hi Chris - Yes, the 32 bit System ODBC does, in fact, work in the toolkit's Database Type Profile Configuration. It's all set up and it connects. I just cannot get it to appear in Data Source Profiles/Add.

Thanks,

Tom

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 8 October 2018 14:09 PM UTC
Ahhhhh ... yes, if you are trying to add (create) a PowerServer DB Profile (aka Data Source) while in the midst of creating a PS Toolkit profile (vs just selecting an existing PS data source) - then you must have a 64bit System based ODBC profile defined.

Run the 64 bit ODBC Admin and create a SS DSN. Then you should be able to create a 64 DataSource in PS via AEM. The the 64bit DSN should appear in your ODBC lists for PS.
  1. Helpful
There are no comments made yet.
Tom Peters
Tom Peters Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 17:00 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 5

The Data Source appears, now, but things are still not working. I will mark this as resolved and open another thread about all the 32/64/Toolkit/Server/connection/DWSQL stuff... ugh... 

Comment
There are no comments made yet.
Clarence Chamorro
Clarence Chamorro Accepted Answer Pending Moderation
  1. Sunday, 14 October 2018 12:21 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 6

What Operating system are you on?

Comment
There are no comments made yet.
Vanessa Barnes
Vanessa Barnes Accepted Answer Pending Moderation
  1. Tuesday, 16 October 2018 12:54 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 7

I 'm facing the same problem. The only way I found to show the DSN in the list was setting up a 64-bit ODBC System DSN. But I'm still not able to connect the database... I don't know what to do anymore, in the System DSN the ODBC is connecting the DB successfully, but in the datasource selection whn I test not work....

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 16 October 2018 14:53 PM UTC
Remember that in the PowerServer TOOLKIT App configuration, the DB Connection test will need to use the 32bit ODBC connection declaration.
  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.