• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 91 views
  • Users 0 members are here
Related

Order Import - SQL Error

Lee-Anne Inglis (Past Member)
$organization

Hi All

I'm trying out the Order Export/Import for the first time but am stuck on the below error message:

Error getting data from \\YVSQL2\tessitura\OrderImports\Trial.txt - Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

I've made the import as simple as possible.  My data file includes only those fields which are essential (commenting out the necessary columns in the format file).  I've attempted the import with just a couple of orders, that have the standard basic information, in case there is an unusual character lurking about.  The format file is the example from Tessitura Network - I've not edited this apart from commenting out the unneccessary lines.  No matter what I try I get the above error message.  

Does anyone know what could be causing this?  Is it data related or something to do with the database?

Very many thanks

Lee-Anne

  • $organization in reply to Tom Brown (Past Member)

    Hi Tom

    Thank you for your reply.

    I had a feeling it was something to do with permissions but I thought I would ask here first to see if there was anything I could fix at my end.  We use a third party to manage our database/network, while I love bothering them unfortunately they don't feel the same way :)

    All the best

    Lee-Anne

  • $organization in reply to Lee-Anne Inglis (Past Member)

    I would agree that this sounds like a file permissions issue.  The order import process runs from the context of the SQL server (not the client.)  The import data file must be accessible directly by the SQL server.   

     

  • $organization
    We have seen that import problems are often related to the SQL server not having the right to read or write to the file location listed. I'd open a TASK support ticket regarding an issue like this.

    --Tom

    On Fri, May 22, 2015 at 8:08 AM, Tessitura Technical Forum wrote:

    Hi All

    I'm trying out the Order Export/Import for the first time but am stuck on the below error message:

    Error getting data from \\YVSQL2\tessitura\OrderImports\Trial.txt - Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

    I've made the import as simple as possible. My data file includes only those fields which are essential (commenting out the necessary columns in the format file). I've attempted the import with just a couple of orders, that have the standard basic information, in case there is an unusual character lurking about. The format file is the example from Tessitura Network - I've not edited this apart from commenting out the unneccessary lines. No matter what I try I get the above error message.

    Does anyone know what could be causing this? Is it data related or something to do with the database?

    Very many thanks

    Lee-Anne



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!