Connection Issues PostgreSQL via Microsoft OLE DB Provider for ODBC Drivers
I am trying to connect to a database that was set up using PostgreSQL. I connected to the database via Microsoft OLE DB Provider for ODBC Drivers. When I test the connection, it says that the connection was successful but when I get to the end to open up the database it says "Failed to initialize tables for connection - out of present range." I am wondering if there is something wrong with my connection string:
"Provider=MSDASQL.1;Password=pwd;Persist Security Info=True;User ID=userid;Data Source=datasource;Initial Catalog=databasename;"
If I open the database in Excel, I don't have any problems... just when I am trying to access the database via the connection string.