INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL Cluster Linked Server to SQLite DB

SQL Cluster Linked Server to SQLite DB

(OP)
Trying to setup a linked server to a SQLite database in a SQL 2012 cluster (active/passive) environment.
I'm able to get the linked server setup and have had SOME success querying, but it is very inconsistent.
For example, when I first setup this linked server, I was able to run the query from the active SQL server (Windows Authentication, logged in as administrator), the passive SQL server (Windows Authentication, logged in as administrator), and Management studio on my computer (Windows Authentication, logged in as myself). I had this setup Monday evening before going home. Next morning, I came in and tried running the query again and could only query from the two SQL servers, but not my desktop (below errors show up).
Configuration:
SQL 2012 Enterprise Cluster (active/passive) with multiple SQL instances installed and running balanced across each of the two servers.
Connecting to Windows Server 2012 with SQLite DB using SQLite ODBC driver 64-bit

In essence, below has been my testing so far.
1) Setup linked server (Server #1 Active, Query from all clients ok [Server #1, Server #2, My Desktop])
2) Next day tested query (Server #1 ok, Server #2 ok, My Desktop NOT OK)
3) Moved active SQL server instance to Server #2 (Server #1 NOT OK, Server #2 ok, My Desktop NOT OK)
4) Moved active SQL server instance back to Server #1 (Server #1 ok, Server #2 ok, My Desktop NOT OK)

Now I have played with other things as well such as:
  • using SQL authentication instead.
  • set security to be made using security context "X" with Windows Login
  • setup permissions on the SQL Servers c:\users\[SQL Service User]\appdata\local\temp folder to allow read/write to certain groups and users
  • looked into dcom settings on SQL Servers
  • changed security on MSDAINITIALIZE according to other articles regarding this
OLE DB provider "MSDASQL" for linked server "DBNAME" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "DBNAME" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "DBNAME" returned message "connect failed".
Msg 7303, Level 16, State 1, Procedure ViewName, Line 5
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "DBNAME".

Hoping that someone else can provide some ideas here.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close