The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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: 21%

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: 821 times

last updated: 03 Aug '15, 21:00