Connection failed with Access

Moony · Post by **Moony** » Wed 26 Jan 2011 13:13

Hi,

I am using the UniDAC with MSSQL and with MSAccess Provider. I have problems with MSAccess. I programmed 2 applications which are using the same unit. The first one is a service for windows and the second is a test application for the service. It only starts a function of the unit both are using.

While starting the test application everything is fine and all connections are right. If I start the service, I get an exception from my UniConnection while executing the open command with the following message:

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a correct path....

My settings for the UniConnection are as follows:

myDB.Username := 'Admin';
myDB.Password := '';
myDB.Database := 'y:\mydb.mdb';
myDB.Server := '';
myDB.ProviderName := 'Access';
myDB.LoginPrompt := false;

Thanks in advance. Moony

AlexP · Post by **AlexP** » Wed 26 Jan 2011 15:08

Hello,

I could not reproduce the problem.

I have tried to create Windows Service with TUniConnection, create TUniConnection, set connection properties as you've told us, and open it in the OnStart event - all works fine.

Please send a complete small sample to alexp*devart*com to demonstrate the problem problem including the *.mdb file.

Also specify the following information:
- the exact version of UniDAC;
- the exact version of your IDE;
- the version of OS.

Moony · Post by **Moony** » Thu 27 Jan 2011 07:40

I will change my Applications to the smallest and send you via Email today.