i have setup the drivers for psqlodbc successfully.
but when i click control admin->admin tools->data source -> file dsn ->
add -> postgre ansi -> ok ->
then another window comes that asks for
server,database,port... and other info... i filled all such info given by the client...
but when i click ok.. i recieve an error message
A connection could not be made using the file data source parameters entered. Save non-verified file DSN?
do i need to install any server... and what file are created in pstgresql
There has to be a server somewhere that you are connecting to. And files? You can't access the files and hope to do anything meaningful. You have to attach to the postgres server typically thru a TCP/IP port.
By design, the server isolates you from the files. They are immaterial (number, type, etc.) to you as a database user. About the only thing you might need to monitor, from a file viewpoint, is the file size, which can impact database performance, and thus will have some impact on the database design.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert