cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Anywhere 12 Informatica ODBC.ini settings

Former Member
0 Kudos
2,880

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Breck_Carter
Participant
0 Kudos

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"