Re: Local SQL connection PsotgreSQL in cloud

From: Washington Leung <wleung(at)statementsolutions(dot)com>
To: 'Walter Couto' <Walter(dot)Couto(at)EMBARCADERO(dot)COM>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Local SQL connection PsotgreSQL in cloud
Date: 2014-12-02 18:54:33
Message-ID: 547817ac81234d1d965d96d2f720207e@BLUPR0801MB610.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I figured it out. I needed to install it and configure onto the DB server

______________________________

Washington Leung
Statement Solutions, LLC
3 University Plaza, Suite 500
Hackensack, NJ 07601
Tel: (201) 373-9770
Cell: (201) 370-0309
wleung(at)statementsolutions(dot)com

-----Original Message-----
From: Walter Couto [mailto:Walter(dot)Couto(at)EMBARCADERO(dot)COM]
Sent: Tuesday, December 02, 2014 1:52 PM
To: Adrian Klaver; Washington Leung; 'pgsql-odbc(at)postgresql(dot)org'
Subject: RE: [ODBC] Local SQL connection PsotgreSQL in cloud

There are 32 bit and 64 bit version of the drivers. From your screenshot you installed the 64 bit PostgreSQL driver. If the message that the ODBC Driver Manager is returning is that it can't find the data source name then it is possible that you need to install the 32 bit version of the PostgreSQL driver and open up the 32 bit version of ODBC Data Source Administrator and register the data source there.

Walter

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
Sent: Tuesday, December 02, 2014 10:45 AM
To: Washington Leung; 'pgsql-odbc(at)postgresql(dot)org'
Subject: Re: [ODBC] Local SQL connection PsotgreSQL in cloud

On 12/01/2014 12:50 PM, Washington Leung wrote:
> I downloaded and installed the latest psqlodbc:
>
> I configured ODBC and successfully was able to connect:
>
> But when try to configure MS SQL server Management studio I get this error:
>
> Please advise what is wrong.

This seems to be an issue with MS SQL Server Management not psqlodbc.

Have you contacted MS to see what they say?

>
> ______________________________
>
> Washington Leung
> Statement Solutions, LLC
> 3 University Plaza, Suite 500
> Hackensack, NJ 07601
> Tel: (201) 373-9770
> Cell: (201) 370-0309
> _wleung(at)statementsolutions(dot)com <mailto:wleung(at)statementsolutions(dot)com>_

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

--
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

CONFIDENTIALITY NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

The information in this e-mail, including any attachments, is confidential and intended solely for the addressee(s). Access to this e-mail by anyone else is unauthorized. If you are not an intended recipient, any disclosure, copying, distribution is prohibited and may be unlawful and any action taken or not taken in reliance on this e-mail is not authorized by the sender. If you received this in error, kindly notify the sender by return e-mail and delete this e-mail and any attachments.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Talha OZ 2014-12-03 05:09:07 psqlodbcw.so symbol lookup errors
Previous Message Walter Couto 2014-12-02 18:52:26 Re: Local SQL connection PsotgreSQL in cloud