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

Resolved Cannot connect sybase 16 32 bit ODBC driver

  1. How-to
0
Votes
Undo
  1. Rajkumar K S
    Rajkumar K S
  2. PowerBuilder
  3. Saturday, 11 February 2023 15:28 PM UTC

Hello everyone,

I have the following problem: when I´m trying to connect to my SYBASE IQ 16.0 server using Powerbuilder DB Profiles the following message appears: “Could not load the encryption DLL"", can someone help me with this error?

ODBC open : 32 bit ODBC Driver

Data source Driver : SQL Anywhere 16

 

Thanks in advance and kind regards.

Rajkumar K S

Attachments (2)
ODBC setup 1.jpg ODBC setup 1.jpg
ODBC setup 2.jpg ODBC setup 2.jpg
WebBrowser Control - Adobe Acrobat - Page Paramete...
dw_1.ImportFile
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 11 February 2023 16:28 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Rajkumar;

   This sounds like your using the wrong ODBC driver. Sybase IQ is not the same as the Sybase SA DBMS. They are of totally different architectures!

Regards ... Chris 

Comment
There are no comments made yet.
Responses (2)
Rajkumar K S
Rajkumar K S Accepted Answer Pending Moderation
  1. Monday, 13 February 2023 14:10 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris,

Thank you for your reply..

Am adding few more details for your better understanding.

 

Case 1 : Sybase Anywhere 12 

              a) sybase anywhere 12 driver is not installed in exe running on the PC. All the dlls and executables in the Sybase anywhere 12 has been copied in the exe folder.

              b) database is connected using ODBC setup.

              c) ODBC created from my application using RegistrySet function. After this ODBC created in 32 bit and the DSN has been created and regedit values also created successfully.  Refer attached regedit.jpg.

              d) After running my application it's successfully running the application without installing the Sybase Anywhere 12 driver.

The same procedure I have configured in Sybase Anywhere 16 

Case 1 : Sybase Anywhere 16

              a) sybase anywhere 16 driver is not installed in exe running on the PC. All the dlls and executables in the Sybase anywhere 16 has been copied in the exe folder.

              b) database is connected using ODBC setup.

              c) ODBC created from my application using RegistrySet function. After this ODBC created in 32 bit and the DSN has been created and regedit values also created successfully.  Refer attached regeditsybase16.jpg.

              d) After running my application is not connecting the Database. I have check the SQLCA. sqlerrtext it's showing the below error message

 

                      SQLSTATE = IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Kindly help us to resolve this issue.. 

 

Thanks & Regards

Rajkumar K S

Attachments (2)
regedit.jpg regedit.jpg
regeditsybase16.jpg regeditsybase16.jpg
Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 13 February 2023 17:13 PM UTC
I would first check the ODBC connection using the deployment machines ODBC Administrator utility. There is a place in there that can test the DB connection directly from the ODBC layer. If that does not work, then it's not a PB issue, it would be an SA client issue & you would need to recheck the SA documentation or contact SAP support to resolve
  1. Helpful 1
Roland Smith
  1. Roland Smith
  2. Monday, 13 February 2023 17:24 PM UTC
If you are adding an ODBC profile in code, you also have to add it to ...\ODBC\ODBC.INI\ODBC Data Sources where key name is the profile name and value is the name of the driver. Look at existing entries for an example.
  1. Helpful 2
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.