I am designing a form on a machine that only has MS SQLServer installed. I have DTS'd a copy of my clients Oracle table and have created a data connection to it to allow me to develop a form.
In the form initialize I have the following code to modify the connection properties to connect to the Oracle database.
var dObj = xfa.sourceSet.DataConnection;
dObj.connect.connectString.value = "User Id=xxxx;Data Source=FIS70.MTA;Password=xxxxxxxx;Persist Security Info=TRUE;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2";
dObj.connect.user.value = "xxxx";
dObj.connect.password.value = "xxxxxxxxx";
The connection is failing and I assume it is because the connection string is not formatted correctly. I probably need to secify the Provider and some other values but I'm not sure what they should be for an Oracle 10g database.
Does anyone have a sample Oracle connection string?
Thanks