Error Message 1

[jpb]

I get this Critical error message when I try To assign the Datasource property of control ..at design time

" ADODC1 Unspecified error"...box appears about 4 times..

after it is gone I cant assign a field in DB to a control..(Datafield property.)

This has lead to this critiacl error message when I click the Test Connection Button in ADODC properties panel
"Test Connection Failed because of an error in initialising provider. Unspecified Error."

Does anyone know what this means ,or where I can find out
and how it can be fixed..

Thanks in advance
jpb

 

[Swany]

The ODBC connection isn't working.
Try reinstalling your ODBC driver and making sure your connection details are set up correctly.

The ODBC connection manager can't initialize the ODBC driver so you get the provider failed message.

 

[jpb]

Thanks Swany,

I am using OLEDB...not ODBC does this make a difference..
Also I have Alarge amount of design time controls in my project could this be a problem..
The project still runs perfectly ie..retrieves data from the database...but it give the error if I want to add new bound controls or ADO controls..

 

[Swany]

What provider are you connecting to?

Could it be that you are actually exceeding licenses on the server by making additonal connections?

 

[Guest_imported]

Swany ,
I am using Microsoft Jet 4.0 OLEDB Provider..
Could you explain what you mean by exceeding licences as I do not understand...

My application still runs but surely those errors will effect me down the road

..Thanks in a advance
jpb

 

[Swany]

Some database servers limit the total number of connections that can be made to the database at one time.

If you exceed that number of total connections (say 50 for instance) for all programs connecting to the database, it will return an error because you have exceeded your licensing limit.

Since you are using JET, that isn't the case. Access doesn't have any such limitation. How many dynamic controls are you creating?

 

[jpb]

I have a lot of them ...is there a limit to the number I can create...can this limit be changed...
I have about 60 forms in my project so I have about 100 connections...some of which are set at design time and some at run time

 

[Swany]

Wow..

Perhaps you are running out of open files handles in the OS. Three are needed for each access connection (accessDB, lock file, temp file)

Try FILESHIGH=400 in your config.sys file and see what happens.

 

[jpb]

Swany,

I Tried that but no luck...still gives me the same error.
It does appear as if the size of my application is being limited in some way, like you said because it will run it as it is but will not let me make it any bigger...
Any other suggestions greatly appreciated..

Thanks in advance
jpb