Questions tagged [sql-server-mars]

Multiple Active Result Sets is a feature used on Microsoft's SQL Server to allow multiple batch execution on a single server

Multiple Active Results Sets is a technique used within Microsoft's SQL Server database management system to enable a single database connections to be used for multiple purposes.

Links

43 questions
0
votes
1 answer

How to calculate the hourly Max over a month, promql

I have the following query, intended to calculate for each hour the max value, over a month. The final result should be- for each parentnode, the hourly max over the last month I have this for…
jenny
  • 105
  • 5
0
votes
1 answer

Open DataReader, Must be Closed: Works Locally, Fails Deployed. WEB API

The following code works fine when debugging locally. Whenever I push it up to my development server, it doesn't work anymore. I've found the bit of code that causes the problem and I was able to fix by adding the line that has a comment below but…
interesting-name-here
  • 1,851
  • 1
  • 20
  • 33
0
votes
0 answers

Eclipse Mars 2 Console doesn't show building process

since some days ago the console output window doesn't show nor the building process neither the the building errors any more. The window remains white, even if I build all the projects - as well as the progress-window. The console still shows…
Uwe_98
  • 697
  • 1
  • 8
  • 21
0
votes
0 answers

Can Google Maps API v.3 work for Mars?

I am playing with writing a little javascript solution that would take place on mars. I would love to have the output result in a google map of a lat and long on Mars. Any thoughts? Can the following concept BE called for a location on the red…
0
votes
1 answer

Eclipse Mars Tomcat 8 server disappeared

I'm trying to define a Tomcat 8.5.16 server but everytime I use the 7 I get an error and when I go into preference to use the newer server it tells me the v8 installation is expecting an 8 server although I am pointing it to my tomcat 8. Please…
April_Nara
  • 1,024
  • 2
  • 15
  • 39
0
votes
1 answer

How to enable multiple action result set in PHP

I already added MARS_Connection=yes to my connection string to enable MARS or multiple action result sets. i'm using sql server 2000 and php 5.2 with PDO This is my connection string "odbc:DRIVER={SQL…
King Jherold
  • 129
  • 3
  • 14
0
votes
2 answers

asp.net - adding MARS to connection from web.config

I have this in webconfig Then I call them most of the time in my page via string connstr =…
Fiendcoder1
  • 119
  • 1
  • 1
  • 12
0
votes
1 answer

Calling stored procedures with multiple results tables

Am having difficulty getting both tables from a stored procedure. So far it only return the first table, my code is below: seat_plan seatP = new seat_plan(); apiModel api = new apiModel(); try { seatP.seats = new…
HuwD
  • 1,800
  • 4
  • 27
  • 58
0
votes
0 answers

Database from SQL 2000 to SQL 2005/2008 still not supporting MARS

So I'm experiencing the issue described in the title. I know SQL 2000 doesn't support MARS (Multiple Active Result Sets) but my clients have SQL 2005/2008 and some of them are still having problems when I use MARS because their databases came from…
0
votes
1 answer

EF-Reference.Load() - There is already an open DataReader

Looks like EF Reference.Load() is not working without MARS? Is that right?
Igor Golodnitsky
  • 4,456
  • 7
  • 44
  • 67
0
votes
1 answer

Clicking "Apply" in Options (child) window should set variables in HUD (parent) window, but doesn't

asked a question early but didn't layout my code very well, and the whole question got a bit muddled, then as I changed my code but still have the same issue, the question still remains, however I decided to re-ask the question with my code laid out…
0
votes
3 answers

Linq-To-Sql and MARS woes - A severe error occurred on the current command. The results, if any, should be discarded

We have built a website based on the design of the Kigg project on CodePlex: http://kigg.codeplex.com/releases/view/28200 Basically, the code uses the repository pattern, with a repository implementation based on Linq-To-Sql. Full source code can be…
Swisher Sweet
  • 769
  • 11
  • 33
-4
votes
1 answer

Having trouble running a program in MARs

I have downloaded MARs and also installed Java. I have a M1 Macbook Air. My issue is that when I do write a code, the buttons where you can assemble and press go are all greyed out. This is for an academic assignment
1 2
3