Is there an open standard for databases that still work? RRS feed

  • Question

  • I have an application that I want to be able to allow the user to point at any database they wish.  Problem is I can't find a connection type that will do this. 

    I have tried OleDB (OleDbConnection) and it works in x86 environment, but breaks on just about everything when compiled 64.

    I have tried ODBC (OdbcConnection) and exact same issue.  Move to 64bit and the world ends.

    SqlConnections work great but now I am limited to just SQL Server, which is what I DON'T want to do.  What if this is a small environment and they want to use access or maybe a completely different database.

    All PCs are moving to 64bit, the OS is 64bit.  So why should I have to compile x86?

    Isn't this what the standards are supposed to be for ?? (oledb,jet,odbc,ADO,etc...)

    Is there any connection type left that I can compile on both x86 and 64bit and be able to connect to just about anything?

    Tuesday, November 15, 2011 9:03 PM