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

Reply via email to