Welcome! Log In Create A New Profile

Advanced

MS SQL OLE DB error importing

Posted by kenknight 
Forum List Message List New Topic
kenknight
MS SQL OLE DB error importing
April 26, 2023 10:16PM
Hi all,

I'm trying to use some tables from an SQL server and if the tables are not part of the dbo schema, they fail to import. It errors saying that it was unable find / open the files.

If I rename the table schema to 'dbo', they import fine.


Any thoughts on how to import the data files into the analysis without having to purchase the native drivers?

Thanks,
Ken
Reply Quote
Newer Topic Older Topic
Author:

Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: