From: Craig Ringer <ringerc@ringerc.id.au>
To: karthi keyan <karthi2itnet@gmail.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Data migration to sql server 2008
Date: Thu, 09 Aug 2012 20:49:51 +0800
Message-ID: <5023B1EF.8060709@ringerc.id.au> (raw)
In-Reply-To: <CAM-vHqKAfzcdQ3jt6iSZw5beU86v=aNAc7FbhcYjEJ+_ZOcUQw@mail.gmail.com>
References: <CAM-vHq+wi0jckw+-mHFJeX98FGutkmSPcDnYR75yHinqtHixrg@mail.gmail.com>
<50220DC1.8030007@ringerc.id.au>
<CAM-vHqKAfzcdQ3jt6iSZw5beU86v=aNAc7FbhcYjEJ+_ZOcUQw@mail.gmail.com>
[Replying via mailing list]
On 08/09/2012 08:24 PM, karthi keyan wrote:
> Thank you for u r reply.
> I have establish the same by sql server *linked server method* .its is
> working fine.
> But right now i am facing the problem of .
>
> -- Query i used in sql
> Select * from openquery(Postgre,'
> dblink_connect(''mycon'',''hostaddr=localhost; dbname=explore
> ;user=openerp; password=xplore)')
>
>
> --- the response
>
> Cannot process the object "
> dblink_connect('mycon','hostaddr=localhost; dbname=explore
> ;user=openerp; password=xplore)". The OLE DB provider "MSDASQL" for
> linked server "Postgre" indicates that either the object has no
> columns or the current user does not have permissions on that object.
>
> Pl help me to fix it out.
You haven't really shown enough information. In particular, where does
this 'Postgre' variable/table/whatever come from? What is it?
You should look at the PostgreSQL server logs to see if PostgreSQL is
sending an error when you attempt the connection and if so, what it is.
Consider also setting log_statement = 'all' in postgresql.conf so you
can see exactly what queries this "openquery" tool runs against PostgreSQL.
Please reply via the mailing list ("reply all") in future.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, karthi2itnet@gmail.com
Subject: Re: Data migration to sql server 2008
In-Reply-To: <5023B1EF.8060709@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox