[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4237
  • Last Modified:

Test connection failed because of an error in initializing provider. Invalid UDL file.

Hi experts, When I try to open an xlsx file from the OLEDB manager it gives me this error"Test connection failed because of an error in initializing provider. Invalid UDL file.", I sued the same file before for few packages but I didnot have it before, I am not sure why I would have it all of a sudden.
Please help!
0
shyamaladevib
Asked:
shyamaladevib
1 Solution
 
David ToddSenior DBACommented:
Hi,

Can you post the connect string?

Cheers
  David
0
 
shyamaladevibAuthor Commented:
Hi Murli,
Thanks for the links, though I do it according to the link it does not work if the order is not maintained, the trick here is first give the path and next in excel 12.0 should be typed in extended properties, vice versa will not work.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now