Login   Bookmark:Subscribe:
You are here: Home » Programming & Design » for "fyireporting" users: PostgreSql connection question?

Question:

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"

(2)Server=(localhost:5432);DataBase=postgres;User ID=postgres;Password=postgres;
- 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?

Submitted: 1178 days ago
chizu
 

Answers:

 
Submitted: 1178 days ago

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

Answer
1/1

Germann A
 
 
 
 

Copyright © 2013 ChiefAdvice.com All Rights Reserved