I have a brand new intranet server with Blue Dragon and SQL Server 2005 Express. I need it to connect to a Pervasive SQL database on another server so I can put this thing to work. I have configured an ODBC datasource for the Pervasive SQL connection. Is it better or even possible to configure the connection using a linked server in SQL 2005 instead? The Pervasive connection is critical since it contains reporting data. Thanks, Billy Cox Old World Spices [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4