Page 1 of 1
SQL Server 2014 Linked SQLite server
Posted: Mon 12 Oct 2015 12:36
by 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?
Re: SQL Server 2014 Linked SQLite server
Posted: Mon 12 Oct 2015 13:54
by 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.
Re: SQL Server 2014 Linked SQLite server
Posted: Mon 12 Oct 2015 14:38
by 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?
Re: SQL Server 2014 Linked SQLite server
Posted: Mon 12 Oct 2015 14:44
by 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)
Re: SQL Server 2014 Linked SQLite server
Posted: Mon 12 Oct 2015 14:50
by 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?
Re: SQL Server 2014 Linked SQLite server
Posted: Mon 12 Oct 2015 19:10
by 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.
Re: SQL Server 2014 Linked SQLite server
Posted: Tue 13 Oct 2015 10:23
by AlexP
Please send me your e-mail address (to alexp*devart*com) - and I will send you a prolonged trial.
Re: SQL Server 2014 Linked SQLite server
Posted: Tue 13 Oct 2015 15:45
by thom
Done - thanks very much in advance.
Re: SQL Server 2014 Linked SQLite server
Posted: Thu 15 Oct 2015 06:42
by 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