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.
possible to access postgresql from sql server ce
Hot Topic
- How to remove the blank spaces between subreports in sql server reporting service?
- Unable to start SQLEXPRESS
- ASP AND SQL SERVER 2005
- sp_executesql, Stored Procedure, UPDATE, parameters
- problem in connecting to sql server Express
- Error Creating DSN using odbcconf.exe for SQL Server
- Flat File and uneven number of columns
- Error when file is saved to PDF
- Variables / Package Execution
- DataReader output column length
SQL Server
- ODBC Driver for SQLServer Everywhere/Compact from Access
- Index granularity
- custom Discretization patterns
- extending SSIS Container?
- Domain group logins failing on SQL 2k5 workgroup
- Currency in Analysis Services
- Standard Edition - Product Level Is Insufficient
- Programming SSIS - Exception 0xC0204006
- User Prompts
- how to find out minimum size
possible to access postgresql from sql server ce
ChaosBlade
No, you can not. As name implies you can only access SQL Server CE with SQL Server CE access classes.
SillyMS
But if there's not Ado.net provider for CE, then it's a moot point.
polska2180
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.
grassgrassgrass
Rahul Garg
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…
nhaas