CODEWITHSUNDEEP
inno-setup
Axs
Axs

Reputation: 805

how to open multiple ADOconnection in inno setup

enter image description herehttps://i.sstatic.net/10Ubs.jpg

i want to use 4 select statements to get records from 4 separate tables in a database in sql server in inno code and i am using four connection strings as below

ADOConnection := CreateOleObject('ADODB.Connection');

    ADOConnection.ConnectionString :=
      'Provider=SQLOLEDB;' +
      'Data Source='+ DBPage.Values[0] + ';' +

     'Integrated Security=SSPI;';

    ADOConnection.Open;

ADOConnection2 := CreateOleObject('ADODB.Connection');

    ADOConnection2.ConnectionString :=
      'Provider=SQLOLEDB;' +
      'Data Source='+ DBPage.Values[0] + ';' +

     'Integrated Security=SSPI;';

    ADOConnection2.Open;

like above i have opened 4 connections . while running the setup i am getting error message as 'there is no enough space to open connections' can anyone help me on this?

Upvotes: 0

Views: 301

Answers (1)

Jac Clapp
Jac Clapp

Reputation: 11

I began getting that error when I switched to the Unicode version of Inno. I switched back to the ANSI version and haven't seen the error since.

Upvotes: 1

Related Questions