Connections: SQLServer - MySQL - ORACLE


SQLServer - MySQL



Connection String:


Server=<SERVER_NAME>;Database=<DATABASE_NAME>;UID=<UID_NAME>;pwd=<PASSWORD>

The connection string is always used to establish a link to a specific server. For SQLServer and MySQL, the data connection is the same, with only the parameters being different.



Oracle Connection



First, you need to have your "tnsnames.ora" file configured. The file is located in the directory of the Oracle driver installed on your server.





Next, you need to configure an ODBC connection and add it to the system DSN. Then, in Netcontent, when generating the connection string, it should be as follows: "Data Source=DSNName;User Id=myUsername;Password=myPassword;Integrated Security=no;".



Created with the Personal Edition of HelpNDoc: Maximize Your Documentation Capabilities with HelpNDoc's User-Friendly UI