SQL Server 2014 Linked SQLite server

[thom]

I'm having issues setting up a linked server in SQL Server 2014. I can create it but receive the following error trying to browse in SQL Server Management Studio:

The OLE DB provider "MSDASQL" for linked server "REDACTED" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "MSDASQL" for linked server "REDACTED". (Microsoft SQL Server, Error: 7399)

I also can't execute queries against the created linked server using OPENQUERY, I just get 'Access Denied' error messages. My ODBC connection is set to use 'Direct' - what settings should I be using to create an SQLite linked server?

[AlexP]

Hello,

We can't reproduce the issue, linked server is created correctly using our driver. Please make sure you are using the system DSN, you have rights to create linked server, and that you are connecting (creating linked server) to a local MS SQL Server.

[thom]

So I'm on Windows 7 64-bit, SQL Server 2014 64-bit using my local default instance. I have a System DSN using your driver, I have previously had a (working) DSN using Christian Werner's driver (which has some limitations, thus my interest in your driver). I'm creating a linked server using MSDASQL and the DSN, and again, the same setup worked using the alternative driver. Any idea where I should look to debug this?

[thom]

Seeing this in ODBC tracing, if it's at all relevant:

Code: Select all

Processid:{2206 1ec-1960	EXIT  SQLSetDescField  with return code -1 (SQL_ERROR)
		SQLHDESC            0x000000000032F478
		SQLSMALLINT                  1 
		SQLSMALLINT               1004 <SQL_DESC_OCTET_LENGTH_PTR>
		SQLPOINTER          0x000000000203E4B8
		SQLINTEGER                   0 

		DIAG [07009] [Devart][ODBC]Invalid descriptor index (54871512) 

[thom]

Ah, this seems to be my fault - I had disabled inproc for the MSDASQL driver, as that helped me with the other SQLite driver. Reenabling it now gives me:

OLE DB provider "MSDASQL" for linked server "redacted" returned message "[Devart][ODBC][SQLite]Trial period is expired".

Which I guess is progress?

[thom]

Any clues what I've done to make my trial expire in under a day? I literally just need to test three or four queries against the driver at which point you'll have a paying customer.

[AlexP]

Please send me your e-mail address (to alexp*devart*com) - and I will send you a prolonged trial.

[thom]

Done - thanks very much in advance.

[AlexP]

Your mail server responded:

Failed Recipient: xxxxxxx
Reason: Remote host said: 552 5.7.0 content and attachment content guidelines. e36si3126378ioj.101 - gsmtp


Most probably, your server doesn't transmit attachment (exe files). Please specify another mail server