Error importing from MSSQL-Database

[Peter Schuerch]

Hi,

When importing form a SQL-Database we get the follwing error:

'VBoreholeLV95'
[FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt

 

(sorry it's german).

I attach the import template for further reference and a screenshot.

My questions:

What is the problem with the import?

Why are the connection settings not stored in the template file attached?

 

thanks, Peter

ImportTemplate_fuer_V_Borehole_LV95.xml

[Jim Jackson]

This is a problem with SQL Server and the number of result sets it can hold open at a time.  Under "Project Folder" drop down, click on "Database Settings". In the Connection Editor dialog click on the "Advanced" button. In the FireDAC Connection Editor look for the "MARS" setting, make sure this is set to "Yes". MARS stands for "Multiple Active Result Set".

When importing from an SQL Server this is accessed from the "Select Import Source" button, the after choosing the MSSQL Driver, you should look for the MARS setting and make sure it is set to Yes.

[Jim Jackson]

Also to save the connection settings in the template file you must check the "Include Data Source in Template file" check-box before saving the template.

[Peter Schuerch]

Hi Jim

My MARS setting is "yes" but I still get the same error. below you find the import template I'm using. Any ideas?

cheers, Peter

ImportTemplate_fuer_V_Borehole_LV95.xml

[Jim Jackson]

On 12/14/2023 at 2:21 AM, Peter Schuerch said:

Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt

Connection is busy with results for another hstmt.

Is usually solved with the MARS setting. I created a new project and imported from an existing MSSQL with out a problem.  Your template looks fine, assuming you added the extra fields before the import.  So all I can suggest is to export the data from GEOSFER as a text file and then import that file using the import from a text file.

You could also use the "Microsoft SQL Management Studio" to transfer the data. Right-Click on "Management" and choose Import will bring up the "SQL Server Import and Export Wizard" or from the start menu.

If you want to run the wizard, but you don't have Microsoft SQL Server installed on your computer, you can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).

[Peter Schuerch]

Is this a RockWorks Error or a Database Error?

How can I list the connections causing this? I'm unaware of other connections from this rockworks project.

thanks, Peter