I am attempting to configure a datasource in an AJAX web page from an existing postgreSQL database that resides on our server. I have done this many times with MySQL, no problem. When I finish the configuration for the PostgreSQL Database in the "Add Connection" wizard of Visual studio 2008, the "Test Connection" is Successful, but there are no tables in the server explorer icon that appears. Can anyone there shed some light on this mystery? I have been stuck for two days and will be eternally grateful...

7 Years
Discussion Span
Last Post by jimib

Most likely you're running in to a schema issue based on how you are authenticating with the PostgreSQL. Keep in mind by default the ASP.NET account runs as an unprivileged user, IUSER_ASP_NET or something like that... and if you're doing any kind of LDAP authentication with the server you won't have admin credentials.



I will look into that. I am new to both asp.net and postgresql so I have double trouble. Good thing I only have four projects!


I was able to solve this problem by using a system DSN that i added in ODBC (Start->Contol Panel->Administrative tools->ODBC->System DSN->Add) The rest is pretty straitforward: Choose type, enter databasename,username,password,ect. Then, in the configure data source wizard, choose "one user or system datasource name" from the dropdown menu. Hope I helped someone with the same problem i had and thanks to all of you who replied.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.