Wednesday, March 7, 2012

possible to access postgresql from sql server ce

I am wondering if it is possible to access a remote postgresql database using the sql server ce access classes. I do not want to run a postgresql server on windows ce, just access one from a mobile device.

No, you can not. As name implies you can only access SQL Server CE with SQL Server CE access classes.

|||Thanks for your reply. I guess the real question I have is: Is there

any way to access a remote database that supports ODBC using Windows CE and Visual Studio .Net?|||

Windows CE has no support for ODBC. It has support for OLEDB, but there's no OLEDB ADO.Net provider not to mention you'd need Postgre OLEDB driver for Windows CE and I doubt Postgre has one.

|||Spasiba|||After doing a little research based on what you said I would need, I

did find a beta OLEDB provider for postgresql

http://pgfoundry.org/projects/oledb/ (which may or may not work on CE)

But if there's not Ado.net provider for CE, then it's a moot point.|||

If you get it to work you can use COM interop to talk to database instead of ADO.Net. May be not as convenient, but should work.

Now, using LGPL beta code which you need to port to CE first is another story…

No comments:

Post a Comment