So...should I go with the ODBC connection to Pervasive SQL or try to connect to Pervasive via linked server in SQL 2005 Express, or am I barking up the wrong tree?
-----Original Message----- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 8:04 AM To: CF-Talk Subject: Datasource question 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] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
