INtools Forum

Forum Home

Aggregated

FAQ

Admin Module

Database Profil...

Database Profile

4/3/2008 6:09:52 AM

jay221182

66 posts

Database Profile

Hi All,

I am using SPI 7 with SQL.

I have 2 different database on same SQL server. Each time I have to change .ini file to change database.

I have read to set Database Profile in .ini file in User Guide-> Administrator Module-> page 55.

I have tried same but showing error "Database not defined"

Might be I have done some systex error.

Anyone knows how to define profile?
_________________
JAY JOSHI

4/4/2008 3:56:00 AM

admin

178 posts

Re: Database Profile

Hi,

It should be like that:

[database]
DBMS=MSS

LogId=in_dbamn
LogPassword=in_dbamn
ServerName= MSS_SERVER_NAME
Database=INTOOLS_DB1_DATABASE

UserId=
DatabasePassword=
TableDir=0
StayConnected=1
AutoCommit=0
DBParm='DISABLEBIND=1',PBDbms=1
Prompt=110
Commit=100

[Profiles]
Database1=DB1

Database2=DB2

Default=DB3

[DB1]
DBMS=MSS

LogId=in_dbamn
LogPassword=in_dbamn
ServerName= MSS_SERVER_NAME
Database=INTOOLS_DB1_DATABASE

UserId=
DatabasePassword=
TableDir=0
StayConnected=1
AutoCommit=0
DBParm='DISABLEBIND=1',PBDbms=1
Prompt=110
Commit=100

[DB2]
DBMS=MSS

LogId=in_dbamn
LogPassword=in_dbamn
ServerName= MSS_SERVER_NAME
Database=INTOOLS_DB2_DATABASE

UserId=
DatabasePassword=
TableDir=0
StayConnected=1
AutoCommit=0
DBParm='DISABLEBIND=1',PBDbms=1
Prompt=110
Commit=100

[DB3]
DBMS=MSS

LogId=in_dbamn
LogPassword=in_dbamn
ServerName= MSS_SERVER_NAME
Database=INTOOLS_DB2_DATABASE

UserId=
DatabasePassword=
TableDir=0
StayConnected=1
AutoCommit=0
DBParm='DISABLEBIND=1',PBDbms=1
Prompt=110
Commit=100

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com

Page 1 of 1

Aggregated

FAQ

Admin Module

Database Profil...