Databases
StackOverflow2013
Postsdbo
POCONNECT TO NAVISION USING ASP.NET
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCONNECT TO NAVISION USING ASP.NET
    text
    copied!<p>Hi can any one please advise me, how to connect Navision using ASP.NET. This is the connection string I have set in Web.Config</p> <pre><code>&lt;connectionStrings&gt; &lt;add name="Navision" connectionString="dsn=TEST;uid=user1;pwd=paswd;database=Test;CompanyName=HHT Test;" /&gt; &lt;/connectionStrings&gt; </code></pre> <p>But when I am trying to connect, I am getting this error:</p> <pre><code>System.Data.Odbc.OdbcException: ERROR [S1000] [Simba][SimbaEngine ODBC Driver] [DRM File Library] The operating system returned the error (183):Cannot create a file when that file already exists. Error: 183 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Simba][SimbaEngine ODBC Driver]Invalid connection string attribute. ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at Service.Getdataset(String SqlStr) </code></pre> <p>I am using <strong>Navision 4.0 SP3</strong> and same ODBC driver.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload