Hi, I have just downloaded PostgreSQL and would like to add it into my new projects. I have never used PostgreSQL before so I don't know any of its technical details yet. I have registered the PostgreSQL provider using regsvr32 pgoledb.dll or something like that on my Winows partition, everything registered successfully according to a pop-up message, and I went into Delphi and saw that it now shows PostgreSQL under the provider list.
I tried to use it with an TADOQuery but after I wanted to test the connection, I got the following error: "Test connection failed because of an error in initializing provider. Unspecified error." Now I'm confused... Is it because PostgreSQL 9 is too new for the PostgreSQL OLE DB Provider? Or did I just to something wrong?
In the connection string, I assumed that the Data Source field is the Server or Database name, Location is the Port, Username is the same as in PostgreSQL, as well as the password... Or will it be better to connect via code?
Any help will be greatly appreciated