Heterogenous data sources. Connection requires ANSI_NULLS etc

[jhall156]

My company is moving away from its VFP driven accounting package (mostly free tables with dbc's only used to feed an RF based warehouse package via triggers) toward actual client server technology. In the interim our asp based web site, which has much java script ado programming, seems like as good a place as any to start creating a multi tier, backend independent system. We have settled on creating a generalized DLL using VB to execute SQL Server 2000 stored procedures to return data from what is currently stored in VFP tables. I have used sp_addlinkedserver to create the linked servers but now when I set up my stored procedure with SELECT * FROM OPENQUERY(mylinkedserver,'some sql') and attempt to save it, the system tells me that I must set ANSI_NULLS and ANSI_WARNINGS for the connection. I have these settings set for the SQL Server and I have tried using a connection string but to no avail. Any help would be appreciated.