Hi,
I am facing an error while deploying contents to SQL SERVER2000.
this is the xml code for the db:
user = "abc"
password = "****"
vendor = "microsoft-inetuna"
timeout = "4"
update-type = "standalone"
delete-tracker = "yes"
enforce-ri = "no"
commit-batch-size="1"
>
...I am getting Deployment successful with error and the log file shows this error.
DBD: Deployment : DataDeploy
DBD: Database Vendor set to microsoft-inetuna
DBD: SQL datatype for column id_content is numeric
DBD: SQL datatype for column ind_content_type is numeric
DBD: SQL datatype for column NME_CMS_COORDINATOR is varchar(50)
DBD: # of columns: 3
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Fri Jun 29 03:11:58 EDT 2007] Begin executing DataDeploy
DBD: Area VPath:/default/main/MercerHR/MHRS/WORKAREA/MHRS
DBD: Setting up TDbSchemaAgent.
DBD: ERROR
eployment to a Microsoft SQLServer database using user-defined dbschema is not supported with JDBC-ODBC bridge. You should use Inet-UNA JDBC driver.Refer to DataDeploy Administration manual.
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaAgent
DBD: Rollback database [jdbc:inetdae:10.203.61.62:1433?MHRSGEO=datadeploy]...
DBD: Deployment[DataDeploy]
DBD: ERROR:TDbSchemaAgent create failure.
DBD: Started : Fri Jun 29 03:11:58 EDT 2007
DBD: Finished: Fri Jun 29 03:11:58 EDT 2007
DBD:
### IWDataDeploy FAILED ###
DBD:
### Sending result ###
ENG: 2007-06-29 03:11:58 EDT GMT-04:00 Database deployment execution returned 1
I have a pre defined database schema where the DCT value should be inserted
Do I need to make the entry of the driver anywhere else other than in the deployment xml???
Can anyone help me out of this.
bye
