I now have a clean virtual machine built on Win7, MySql, and DTS 3.5.2.203. I
have set up a DTS user and DTS Schema in MySql. But when I try to run KbCreate
I get errors complaining about the Data connection. The documentation is
silent about how to get kbcreate.bat to run on MySql. I have commented out the
other dbms connections in kbcreate.xml and removed the comments for MySql.
ParseConfig: parseForConnection
org.xml.sax.SAXParseException: The content of element type "DBConfig" must
match
"(connection|property|namespace)*".
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
By default kbcreate uses DTS_HOME/bin/kb/target-connection.xml file for
connection information. You need to add connection parameters for mysql in
that file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I now have a clean virtual machine built on Win7, MySql, and DTS 3.5.2.203. I
have set up a DTS user and DTS Schema in MySql. But when I try to run KbCreate
I get errors complaining about the Data connection. The documentation is
silent about how to get kbcreate.bat to run on MySql. I have commented out the
other dbms connections in kbcreate.xml and removed the comments for MySql.
ParseConfig: parseForConnection
org.xml.sax.SAXParseException: The content of element type "DBConfig" must
match
"(connection|property|namespace)*".
By default kbcreate uses DTS_HOME/bin/kb/target-connection.xml file for
connection information. You need to add connection parameters for mysql in
that file.