Devart Forums

Hi

I have a problem connecting when running my application through the IDE. If I drop an msconnection on to my form I can open it and browse my sql servers. When I run the application through the IDE the program just errors out and won't connect.
I have put an msconnectDialog on the form when the application is run it will not find a list of the servers. When I drop down the server box I get an error EconvertError with message 'Format '%i' invalid or incompatible with argument.
If I compile the application and run it from the folder outside the IDE all is normal.

No fire wall on.

The odd thing is some applications work correctly

Windows 7 64
Delphi XE
SDAC 5.10.0.7

Hello,

Please try the following:
- create a new application;
- drop the TMSConnection and TButton components onto the form;
- add the SdacVcl unit to the USES clause (to enable the default connect dialog);
- write the following code: - run the application and click the button.
Can you connect this way? Does the error with the server list occur?

Thank you

Yes this works creating from new.

I have a small application which I have edited to have the same as your example. When I run it I get the error. If I start a new project and copy the components off the original form to the new project it works. But I cannot go through the main application like this.

This is a completely clean install of windows and Delphi.

It seems that the problem is caused by some project options. Please send me your small application that demonstrates the problem to andreyz*devart*com.

I have now sent you an example

I've investigated your project. The problem with connecting to SQL Server is caused by the following lines in your project (Project1.dproj):If you remove these lines from the Project1.dproj file, you will be able to connect to SQL Server. This problem isn't caused by SDAC. I've checked ADO components as well, and they showed the same error. For more information about this problem, please contact the Embarcadero support.

Andrey

Brilliant thank you very much. All working now

Feel free to contact us if you have any further questions about SDAC.