for "fyireporting" users: PostgreSql connection question?
for "fyireporting" users: PostgreSql connection question? i have postgreSQL 8.4 as a database for a Windows .Net application
i am trying to connect this database to FYIreporting software.
i opened a new (blank) report, then chose postgresql then wrote on the connection textbox either of the following:
(1) Server=(local)VSDotNet;DataBase=Northwind;Integrated Security=SSPI;Connect Timeout=5
-this 'code' produces a message box with "connection string argument missing, parameter name:User ID"
- this 'code' produces the message: "the requested name is valid and was found in the database, but it does not have the correct associated data being resolved for"
can anyone please give me a solution to this, not just an explanation of the problem?
i haven't even made one report because of this problem.
If you can't answer the question, will you please recommend another DotNet reporting software that supports postgreSql 8.4, and where i won't have a problem connecting to?
1) it is a BAD idea to use built-in userIDs for DB connections.
Create a user and set default DB/Schema/permissions (I don't remember what is needed for PostgreSql, but it is one of those that is not set for postgres (default) user