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.

Thanks

asked 03 Aug '15, 18:11

WIHank's gravatar image

WIHank
1111
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

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SQL Anywhere 12 Demo]
"Driver"="C:\\PROGRA~1\\SQLANY~3\\Bin64\\dbodbc12.dll"
"UID"="DBA"
"PWD"="sql"
"DatabaseFile"="C:\\Users\\Public\\Documents\\SQL Anywhere 12\\Samples\\demo.db"
"ServerName"="demo12"
"StartLine"="C:\\Program Files\\SQL Anywhere 12\\Bin64\\dbeng12.exe"
"AutoStop"="YES"
"Description"="SQL Anywhere 12 Sample Database"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 12]
"Driver"="C:\\PROGRA~1\\SQLANY~3\\Bin64\\dbodbc12.dll"
"Setup"="C:\\PROGRA~1\\SQLANY~3\\Bin64\\dbodbc12.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"SQL Anywhere 12 Demo"="SQL Anywhere 12"
permanent link

answered 03 Aug '15, 21:00

Breck%20Carter's gravatar image

Breck Carter
26.2k430600863
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

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:

×10

question asked: 03 Aug '15, 18:11

question was seen: 514 times

last updated: 03 Aug '15, 21:00