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

Resolved ODBC connection error

  1. Advice
0
Votes
Undo
  1. Kevin Thompson
    Kevin Thompson
  2. PowerBuilder
  3. Thursday, 15 December 2022 14:35 PM UTC

When creating an ODBC Configuration for PB Demo 2022, and when I click on the Test Connection button I receive an error, that it is unable to start server.  I followed the steps in the Appeon doucment guide, and looking for any insight that will help me.
My ODBC login tab

  1. ODBC
What to learn for PowerServer?
SendGetRequest Reject only on Powerbuilder 2021 or...
Responses (4)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Saturday, 17 December 2022 18:52 PM UTC
  2. PowerBuilder
  3. # 1

Kevin -

1. Double-click on dbeng.exe to ensure that SQL ANYWHERE has been installed correctly and the application starts correctly.

2. Once SQL ANYWHERE opens, point it to your database to ensure that it can open the database.

          

3. Remember to use the 32 bit version of the database when running with PowerBuilder (I know you know this).

4. Delete your existing DSN. Delete your DW Painter profile. Reboot the platform (PC or VM).

5. Rebuild the SYSTEM DSN.

6. Rebuild the Profile.


FYI:  Here's an ODBC database I have:













 Good Luck!

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 15 December 2022 18:38 PM UTC
  2. PowerBuilder
  3. # 2

Hi Kevin;

   Make sure that you are crating a System type DSN.  HTH

Regards .. Chris

Comment
There are no comments made yet.
Kevin Thompson
Kevin Thompson Accepted Answer Pending Moderation
  1. Thursday, 15 December 2022 15:25 PM UTC
  2. PowerBuilder
  3. # 3

both 32 and 64 bit drivers are connected. When trying to connect using the shortcut I get the same message Database server not found.

[SAP][ODBC Driver][SQL Anywhere]Database server not found
    SQLCODE=-100
    SQLSTATE=08001

Connection parameters:
    User=dba
    Password=***
    Server=PBDemoDB2022
    DBN=pbdemo2022
    LINKS=ShMem

Comment
Load more comments
Kevin Thompson
  1. Kevin Thompson
  2. Thursday, 15 December 2022 16:31 PM UTC
I uninstalled and re-installed as Administrator and still no joy. I'm still getting the same message 'Connection failed: Unable to start database server' when I try to connect.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 15 December 2022 20:29 PM UTC
As Christ mentioned, are you creating a System DSN?
  1. Helpful
Kevin Thompson
  1. Kevin Thompson
  2. Thursday, 15 December 2022 20:52 PM UTC
I've tried both User DSN and System DSN and getting the same result.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 15 December 2022 15:17 PM UTC
  2. PowerBuilder
  3. # 4

When you installed SQL Anywhere, did you install both 32-bit and 64-bit drivers?  

When selecting SQL Anywhere shortcut from Windows start menu, are you able to start the DB server?

Comment
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.