|
Hello,
I'm trying to connect Postgres database through
.NET, through OLEDB with following connection string and code
string
conn = "Provider=PostgreSQL;Host=localhost;Password=pwd;User
Id=postgres;Database=psdb;";
OleDbConnection myConnection = new OleDbConnection(conn); OleDbDataAdapter myCommand = new OleDbDataAdapter(sql.ToString(),myConnection); myCommand.SelectCommand.CommandType = CommandType.Text; myCommand.Fill(ds, "tblpsdb"); But it is throwing an error as follows :
System.Data.OleDb.OleDbException:
FATAL: invalid command-line arguments for server process
HINT: Try "postgres --help" for more information. at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at
System.Data.OleDb.OleDbConnection.CreateSession()
at
System.Data.OleDb.OleDbConnection.Open()
at
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState)
at
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable)
Am I missing something? Please let me know how
can I connect by OLEDB through .NET. Following are the information regarding the
environment :
Platform you're running on : Win2000
Pro
Language : C# Distribution you used (source tarball, or binary) : postgresql-8.0.1.zip Version you tested : Release 8.0.1, Release date : 2005-01-31 Also let me know how can I export a database from SQL
Server to PostGres, as I found some tables not being exported in the
process.
Regards,
Amitava Sengupta
Programmer Analyst Web Spiders (India) Pvt. Ltd.
51B, Justice Chandra Madhav Road Calcutta 700 020. India Phone: 91.33.2474.3581 to 85 Fax: 91.33.2474.3500 http://www.webspiders.com (ISO 9001:2000 and IC 9700 Certified. Microsoft Gold Certified Partner) Calcutta (India), Birmingham (UK), Toronto
(Canada), San Francisco (USA)
Disclaimer: The opinions expressed within this
message are those of the author and not necessarily those of the firm The
information contained in this message is intended only for the recipient, may be
privileged and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, please be aware that any
dissemination or copying of this communication is strictly prohibited. If you
have received this communication in error, please immediately notify us by
replying to the message and deleting it from your computer or any other device.
|
