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 am attempting to read some data out of a SQL Anywhere 12 Database using Informatica. I was able to read the tables into Powercenter, but when I go to run my mapping, I am getting errors. I have downloaded the drivers, installed them on our server, but cant seem to get it to work. If anyone has done this, can you please share the setting that you used within your odbc.ini? I think that may be my holdup.


asked 03 Aug '15, 18:11

WIHank's gravatar image

accept rate: 0%

FYI the online Help for SQL Anywhere 12 is located here.

I don't know anything about Informatica, and I don't know if your SQL Anywhere 12 database is already running or needs to be "auto started" when the first ODBC connection is made, but...

Here are the ODBC.INI registry settings for auto-starting and connecting to the SQL Anywhere 12 demo database via the ODBC System DSN "SQL Anywhere 12 Demo"...

Windows Registry Editor Version 5.00

"DatabaseFile"="C:\\Users\\Public\\Documents\\SQL Anywhere 12\\Samples\\demo.db"
"StartLine"="C:\\Program Files\\SQL Anywhere 12\\Bin64\\dbeng12.exe"
"Description"="SQL Anywhere 12 Sample Database"


"SQL Anywhere 12 Demo"="SQL Anywhere 12"
permanent link

answered 03 Aug '15, 21:00

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 03 Aug '15, 18:11

question was seen: 2,724 times

last updated: 03 Aug '15, 21:00