Powerbuilder 12.5 get error in DB painter when trying to create SQL Anywhere database

[former_member231132]

I'm running Windows 10 version 1803. I recently installed Powerbuilder 12.5.2 and SQL Anywhere 12.0.1. In the PB IDE, I go to the database painter and attempt to create an ASA database by expanding ODB ODBC > Utilities > Create ASA database. When I attempt to create a SQL Anywhere 12 database I get an error "SQLSTATE = 08003 [Microsoft][ODBC Driver Manager] Connection not open" (see below). Based on some research I believe this error is because Powerbuilder itself is 32 bit but the SQL Anywhere drivers are 64 bit. What is the best way to uninstall the 64 bit SQL Anywhere and install 3 bit SQL Anywhere? I tried to do it by re-running the Powerbuilder install program, but the process freezes after I load the license file for "standalone seat - local license" and has be to be terminated in Task Manager.

Thanks for all help,

Tim Sheppard

[former_member231132]

Type-o correction:

Instead of "What is the best way to uninstall the 64 bit SQL Anywhere and install 3 bit SQL Anywhere?"

It should say "What is the best way to uninstall the 64 bit SQL Anywhere and install 32 bit SQL Anywhere?"

[former_member231132]

Thanks Chris, going to Add or Remove programs and doing a 'Modify' on SQL Anywhere 12 allowed me to rerun the install process and select the 32 bit components. This fixed the problem.

[former_member231132]

Chris - if you change your response to an Answer then I'll mark it as the correct answer. Thanks again

[chris_keating]

Good to hear that you are back on track. I suspect that SA7 might work with PB12.5 but is not the version that PB tested. The pbodbX.ini file should still contain a section that covers that version. I do not currently have an install of SA7 so I was not able to easily run a test.

[former_member231132]

Chris - when you say pbodbX.ini I'm assuming you mean pbodb125.ini. I looked in this file and the sections that may be related to SQL Anywhere don't have a version number associated. I see sections for:

[WATCOM SQL WSQLODBC] [WATCOM SQL] [Sybase SQL Anywhere] [Adaptive Server Anywhere] [SQL Anywhere] [Adaptive Server IQ]

Do you still think PB 12.5 supports SQL7?

[chris_keating]

I was able to find a copy of SQLA 7 to try. Based on a quick test, I am not able to get a connection via PowerBuilder 12.6. I am getting an odd error when attempting to connect:

[SAP][ODBC Driver]Invalid use of null pointerThis error is not coming from the SQLA 7 ODBC driver - that driver would not report [SAP] with that version of driver. I cannot explain the cause. As a result, I am unable to commit to whether it could possible work.

[chris_keating · Accepted solution]

The only way that I can reproduce the error that you are seeing is when the driver has been incorrectly installed.

• a 64 bit driver registered in the 32 bit ODBC environment or
• a invalid path/file name for the SQL Anywhere 12 ODBC driver defined in the ODBC environment

I do not see how the SQL Anywhere install would result in these cases - the SQLA ODBC driver is self registering and should correctly handle the bitness of the driver that it registers as well as the pathing used. In any event, you do need to be using a 32 bit driver with PowerBuilder. You can modify the install and ensure that you select the 32 bit components. This can be done by either rerunning the install or doing a modify in the Add or Remove programs. If the install appears to already have 32 bit, you may need to run a repair or reinstall.