I have been trying to make the connection string work for a while, but I seem to not be able to make the connection.  I can however use a connection string in another module and it works fine it is using OLEDB as the method.

This is the connection string that works in another module, but not in Dynamic Forms(I am using version 4.0.10.36827);

Provider=IBMDASQL;Data Source=172.16.1.15;Password=secret;User ID=super;

When I choose debug for the form I get;

Attempting SQL Data Bind:SELECT CWSTR#,CWDATE FROM QS36F.CC_WKCWA WHERE CWSTR#=201

Failed SQL Data Bind:SELECT CWSTR#,CWDATE FROM QS36F.CC_WKCWA WHERE CWSTR#=201

Any ideas on how to make this connection work? 

I want to use it review update a database on this external database so that we can integrate it with the web.

HI, please check out this page (it shows examples for OLEDB and SQLConnection). You might try adding in the "initial Catalog" option to specify your particular database name as well. See if it will work for you.

http://www.sqlstrings.com/sql-serve...trings.htm

SQL OLE DB connection strings

Standard Security:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL SqlConnection .NET strings

Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;" < br>2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:
1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"
2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

--David To