Rank: Administration
Posts: 42
|
The current version of Excel to database 1.0.76 requires you to use trusted authentication with SQL Server.
We are developing an alternative connection method that allows you to store a connection string with a task.
Once implemented you will not need to use an ODBC DSN connection, and sql authentication will work fine.
For security we will encrypt any supplied password within the task setup XML file.
|
|
|
|
|
|
Rank: Administration
Posts: 42
|
Originally Posted by: Admin  The current version of Excel to database 1.0.76 requires you to use trusted authentication with SQL Server.
We are developing an alternative connection method that allows you to store a connection string with a task.
Once implemented you will not need to use an ODBC DSN connection, and sql authentication will work fine.
For security we will encrypt any supplied password within the task setup XML file. Please note this has been overcome since version 1.1.16 which allows you to specify a connection string. Here is an example connection string for SQL Server: Code:
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;
The connection string must specify the provider as in the example above. For other connections strings we recommend this site: http://www.connectionstrings.com/Do ask us for help if needed ..
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.