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 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to