Hi.I'm in the educational research field and we routinely the bulk of our data with SAS (www.sas.com/software/sas9/) at the home office while database in the filed use a desktop DBMS such as Access or xBase. We are considering SQL CE as a replacement for a new application and it would be great to just grab the data directly into SAS and bypass options such as syncing to a SQL Server and then reading that. SAS has an OLEDB interface that allows me two configure the provider, source, user names and all the usual seetings. CE 3.5 is installed and I can connect to it just fine from, say, Excel using ADO and the Microsoft.SQLSERVER.CE.OLEDB.3.5 provider string. SAS however gives me cryptic errors and I'm not sure whether it is a limitation of SAS or SQL CE. I can also configure my connection through the Windows "Data Link Properties" dialog but the SQL CE provider doesn't appear there despite being correctly configured in the registry.I have tried ...
test oledb init_string='Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=d:\northwind.sdf';run;
... and the result is ...
ERROR: Error trying to establish connection: Unable to get create accessor; Error in columns :Errors occurred. [,,,,,]
Anyone who is also working with SAS (either 9.1 or 9.2) and got it right? Any way to add SQL CE provider to that "Data Link Properties" window?Greetings
View Complete Post