web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / multiple parallel ODBC...
Microsoft Dynamics NAV (Archived)

multiple parallel ODBC connections

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

we use Microsoft Dynamics NAV 2009 R2, Version DE Dynamics NAV 5.0 SP1 (6.00.32964) (non SQL)

We have about 20 configured ODBC Connection to different clients (companies).

We use the Microsoft Dynamics NAV ODBC Driver in Version 6.0.32964.00 (Windows 7 32bit and 64bit)

It's not possible that one application starts 2 or more connection at the same time - only one connection could be established.

But it's possible to connect at the same time from different applications to different ODBC connections.

Is this a limitation from the ODBC driver, a licensing problem or something else?

Kind regards

Marco

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Standard ODBC driver allows multiple connections but no multiple statements per connection:

    Multiple Active Statements per Connection

    After SQL Server has received a statement, the SQL Server TDS protocol does not allow acceptance of any other statements from that connection until one of the following occurs:

    The client application processes the entire result set.

    The client sends a statement telling the server it can close the remainder of the result set.

    This means that when an ODBC application is using a default result set, SQL Server does not support multiple active statement handles on a connection handle and only one statement can be actively processed at any point in time.

    When an ODBC application is using API server cursors, however, the driver can support multiple active statements on a connection. When the rowset for each cursor command has been received back at the client, SQL Server considers the statement to have completed, and it accepts another statement from another statement handle over that connection handle.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans