We would like to setup a linked server from SQL2000, SQL2005, and
SQL2008 systems to connect and query a SQLite db. Has anyone ever
accomplished this?? How would we query a SQLite db from SQL server??
We have tried to use the Cherry City Software OLEDB provider but it
won't let us activate the locked portion of the code. And with their
limited resources, it doesn't appear we'll get this resolved with
them...
When we execute this syntax:
select * from openquery (WOLFC, 'select * from category')
It returns:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'OleSQLite.SQLiteSource.1'.
[OLE/DB provider returned message: This feature is currently locked. In
order to unlock this feature, SQLite OLE DB Provider must be activated.]
OLE DB error trace [OLE/DB Provider 'OleSQLite.SQLiteSource.1'
ICommandPrepare::Prepare returned 0x800404e8].
Thanks,
Curtis Whitworth
Pilgrim's Pride - Atlanta
770-393-5488 (Direct) 770-355-6721 (Cell)
**************************************************************************************************************
The information contained in this e-mail (along with any attachments) is
intended only for the use of the individual(s) to whom it is addressed. It is
confidential and may contain privileged information. If the reader of this
message is not the intended recipient, you are hereby notified that you should
not read its contents, and any dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received it in error, please
immediately (1) delete this transmission and any attachments and (2) notify
i...@pilgrimspride.com to advise us of the error. THIS E-MAIL IS NOT AN OFFER
OR ACCEPTANCE: Notwithstanding the Uniform Electronic Transactions Act or any
other law of similar import, absent an express statement to the contrary
contained in this e-mail, neither this e-mail nor any attachments are an offer
or acceptance to enter into a contract, and are not intended to bind the
sender, Pilgrims Pride Corporation, or any of its subsidiaries, or any other
person or entity.
**************************************************************************************************************
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
