I am getting an error trying to connect to PostgreSQL db using Visual
Basic.NET 2005. The error message is "FATAL: invalid command-line
arguments for server process. HINT: Try "postgres --help" for more
information."
Here is a the snippet of code to create connection. Looking for
suggestions on what the problem may be and how to solve it. We just
made the switch recently from MSSQL to PostgreSQL 8.2.
Private sConnString As String _
= "Provider=PostgreSQL;Addr=127.0.0.1;User
ID=postgres;Password=ourpassword;Database=AUDIOCAT"
Private objConn As New OleDbConnection(sConnString)
Private objCmd As New OleDbCommand
Public Function dbOpenConn() As Boolean
Try
objConn.Open()
objCmd.Connection = objConn
Catch ex As Exception
'Console.WriteLine(ex.Message)
OutputToLog("ERROR (Opening Database Connection): " & ex.Message)
frmMain.lblStatus.Text = "Error Occurred! Check
application log for details."
Return False
End Try
Return True
End Function
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend