Skip site navigation (1) Skip section navigation (2)

Re: ODBC does not work after installation of MS-SQLExpress

From: Vernon Cole <vernondcole(at)gmail(dot)com>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC does not work after installation of MS-SQLExpress
Date: 2011-02-20 05:53:07
Message-ID: AANLkTimUhBO9V3mZ9BGniOhb2RpaB5c8OYZScmDWS757@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Dear Josef:

I have an almost identical system. I installed Microsoft SQLExpress 2008 R2
(with tools) last Thursday, on Windows Vista Home Basic SP1, with
PostgreSQL Uincode 8.03.04.00.  It works fine for me:
v v v v v
C:\hg\adodbapi\test>c:\python27\python.exe testADOdbapi.py
2.7 (r27:82525, Jul  4 2010, 09:01:59) [MSC v.1500 32 bit (Intel)]
adodbapi v2.4.2.1
testADOdbapiConfig.py v 2.4.0
   ...Testing MS-SQL login...
     dbms_name="Microsoft SQL Server"
     dbms_version="10.50.1600"
   ...Testing MySql login...
     dbms_name="MySQL"
     dbms_version="5.1.49-1ubuntu8.1"
  ...Testing PostgreSQL login...
     dbms_name="PostgreSQL"
     dbms_version="8.4.7"
^ ^ ^ ^ ^
  But I note that I am using more current versions than you.  Have you tried
updating to the latest SQLExpress and driver?
--
Vernon Cole

On Sat, Feb 19, 2011 at 9:08 AM, Josef Springer <Josef(dot)Springer(at)joops(dot)com>wrote:

>  Hello everybody,
>
> my ODBC driver does not work allready. If i press the button *Test *in the
> configuration dialog of ODBC-Datasources, i get *Communication closed
> during Authentication; Connection  reset by peer*. Username and password
> is correct !
>
> This worked up to yesterday. Yesterday had to install *Microsoft
> SQLExpress Version 8*. Because of SQLExpress, had to install *Windows
> Management Framework-Kernpaket* too. Now i get the connection error. :-(
>
> Used PostgreSQL-ODBC driver: *PostgreSQL Unicode 8.02.04.00
> (PSQLODBC34W.dll) 27.4.2007*
> System: *Windows Vista SP1*
>
>

In response to

Responses

pgsql-odbc by date

Next:From: Josef SpringerDate: 2011-02-20 10:27:53
Subject: Re: ODBC does not work after installation of MS-SQLExpress
Previous:From: Josef SpringerDate: 2011-02-19 16:08:52
Subject: ODBC does not work after installation of MS-SQLExpress

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group