x

Test Connection failed while exporting from Access to SQL SErver 2008 R2

Hi,

I am importing data from access to SQL SErver 2008 R2 using IMPORT / Export Wizard.

But as soon as I select Source as Access and enter my admin username and password, I get following error message :

Microsoft Data Link Error :

Test Connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

Any inputs ?

Thanks,
more ▼

asked Oct 20, 2011 at 12:01 PM in Default

jerill gravatar image

jerill
41 10 14 14

Are you running this on X64 machine?
Oct 20, 2011 at 12:07 PM Pavel Pawlowski
I am running on Windows Server 2008 R2. And I am using 32 bit import wizard. At that I am getting above error message.
Oct 20, 2011 at 12:17 PM jerill
Any idea wat is causing that error message
Oct 20, 2011 at 12:41 PM jerill
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x51

asked: Oct 20, 2011 at 12:01 PM

Seen: 1080 times

Last Updated: Oct 20, 2011 at 12:01 PM