Access and define the ODBC datasource
for the empty SQL Anywhere 11 repository.
Repositories are held in a collection of tables in a SQL Anywhere database.
Sybase IQ InfoPrimer allows physical separation of repositories by using multiple repository databases.
- Navigate to <IQIPD_install_directory>\etc, copy repositoryEmpty.db and rename to a name of
your choice. For example, myRepository_IQIP153.db.
- Configure the ODBC datasource names to define your
own repository by creating a System datasource that points to myRepository_IQIP153.db.
Select .
Note: To administer datasources on a 64-bit machine, run odbcad32.exe from C:\WINDOWS\SysWOW64.
Click Add.
Select SQL Anywhere and click Finish.
Click the ODBC tab. In the Data source name field,
enter
myRepository_IQIP153.
Click the Login tab and enter
dba
as
the user ID and
sql
as the password.
Click the
Database tab and enter these values:
A server name.
Start line – C:\Sybase\IQIPD-15_3\dbeng11.exe. This
is the default installation location.
Note: IQ InfoPrimer Development runs dbeng11.exe for
configuring the IQ InfoPrimer repository. dbeng11.exe is a single-user database
that cannot be accessed from other machines. To access the repository
from another machine, specify dbsrv11.exe instead
of dbeng11.exe in the Start line field.
Database file – C:\Sybase\IQIPD-15_3\etc\myRepository_
IQIP153.db.
Click the ODBC tab and click Test Connection to
verify the connection.
- Click OK.