I see this question posted back in 2004 with no responses. It's funny how Microsoft doesn't recognize any other software. On to the question. I have gotten this far:
Code:
...
OleDbConnection conn;
...
OleDbConnectionStringBuilder conStr = new OleDbConnectionStringBuilder();
conStr.DataSource = "localhost";
conStr.Provider = "PostgreSQL.1";
conStr["User ID"] = "<SomeUsername>";
conStr["Password"] = "<SomePassword>";
...
conn = new OleDbConnection(conStr.ConnectionString);
...
conn.Open();
This will connect me to the database engine. But doesn't get me to the database I'm using so queries fail. If I try ... From MyDatabase.MyTable ... I get a schema not found error.
Is there anyone out there who realizes that Microsoft isn't the only software company?
What you don't know can hurt you!
Has anyone learned how to connect to Postgres SQL?
