s
Contact Inloggen Registreren
h M

Data Springs Modules Community Questions & Answers

Ask a Question

Connection String for External Db - AS400 not working

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.
asked 11-10-2013
psanders1640
psanders16

1 Answer

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-server-connection-strings.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
answered 16-10-2013 David To 40
David To

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...

10 inform moderator flags remaining

I am deleting this question because...

I am flagging this answer because...

10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...

Looking for a DNN Module?

If you’ve used Data Springs modules before, you know how easy they are to install and use. We have built each individual module in our collection with integration in mind, so when you opt for Collection 7.0 you’ll be able to install our entire toolbox quickly and start putting it to work for your business today.Yes, in the blink of an eye you will arrive on the scene like a Superhero!

Data Springs has long been recognized as a leader in the DotNetNuke (DNN) community through hard work, integrity, and commitment. We’ve helped thousands of people POWER UP their website and our Collection 7.0 will do the same for you.

You deserve more than just an average website. You deserve a MACHINE!

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

Subscribe
Copyright 2025 by Data Springs, Inc Gebruiksovereenkomst Privacybeleid

F T L

Site creation : Dune Interactive