Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hello, I have installed Power Designer evaluation version and SQL Anywhere. In order to setup the repository, I need to create a ODBC connection for SQL Anywhere. Now the problem that I face is that PD is 32 bit and SQL anywhere is 64 bit. So every time I try to connect using this odbc, I am getting IS014 error (that is because of different ODBC drivers in this case). I tried creating a 32 bit odbc driver from windows, but SQL anywhere is not showing up in User/System DSN. Could anyone please help me here?

Thanks

asked 09 Dec '11, 22:55

JGS's gravatar image

JGS
16112
accept rate: 0%


To access the 32 bit ODBC settings you have to use the 32-bit version of the odbc administration, in Win7 just search for odbc and you should see it with the (32-bit) behind it, alternatively here is the full path: C:\Windows\SysWOW64\odbcad32.exe

permanent link

answered 12 Dec '11, 02:48

Martin's gravatar image

Martin
9.1k131170257
accept rate: 14%

edited 12 Dec '11, 02:48

Please note that the 32 bit and 64 bit administrator are named the same so you need to ensure that you run it using the full path.

And if you have not done so, you may need to install the 32 bit SQL Anywhere ODBC driver

(12 Dec '11, 09:15) Chris Keating
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×39

question asked: 09 Dec '11, 22:55

question was seen: 2,670 times

last updated: 12 Dec '11, 09:15