SQL Server 2014 Linked SQLite server

SQL Server 2014 Linked SQLite server

Postby thom » Mon 12 Oct 2015 12:36

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?
thom
 
Posts: 6
Joined: Mon 12 Oct 2015 12:21

Re: SQL Server 2014 Linked SQLite server

Postby AlexP » Mon 12 Oct 2015 13:54

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.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: SQL Server 2014 Linked SQLite server

Postby thom » Mon 12 Oct 2015 14:38

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
 
Posts: 6
Joined: Mon 12 Oct 2015 12:21

Re: SQL Server 2014 Linked SQLite server

Postby thom » Mon 12 Oct 2015 14:44

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
 
Posts: 6
Joined: Mon 12 Oct 2015 12:21

Re: SQL Server 2014 Linked SQLite server

Postby thom » Mon 12 Oct 2015 14:50

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
 
Posts: 6
Joined: Mon 12 Oct 2015 12:21

Re: SQL Server 2014 Linked SQLite server

Postby thom » Mon 12 Oct 2015 19:10

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.
thom
 
Posts: 6
Joined: Mon 12 Oct 2015 12:21

Re: SQL Server 2014 Linked SQLite server

Postby AlexP » Tue 13 Oct 2015 10:23

Please send me your e-mail address (to alexp*devart*com) - and I will send you a prolonged trial.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: SQL Server 2014 Linked SQLite server

Postby thom » Tue 13 Oct 2015 15:45

Done - thanks very much in advance.
thom
 
Posts: 6
Joined: Mon 12 Oct 2015 12:21

Re: SQL Server 2014 Linked SQLite server

Postby AlexP » Thu 15 Oct 2015 06:42

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
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to ODBC Drivers