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

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

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

thanks for quick answer.

I downloaded the latest SQLExpress and driver from 
http://www.microsoft.com/downloads/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff&displayLang=de.
I beleave this is the current version.
The sequence of installing may be important.
I installed first (some month ago) PostgreSQL. Second (yesterday), i 
installed MS-SQLExpress. This is the problem ? But if yes, i dont kn
Did you install with the same sequence ?

The exact versions of my installed MS-SQLExpress components are:
Microsoft Server                                                     
10.50.1600
Microsoft SQL Server Management Studio             10.50.1600.1
Microsoft Data Access Components (MDAC)        6.0.6001.18000
Microsoft MSXML                                                3.0 4.0 
5.0 6.0
Microsoft Internet Explorer                                      
7.0.6001.18000
Microsoft .NET Framework                                    2.0.50727.3053
Betriebssystem                                                        
6.0.6001

The version of installed PostgreSQL-ODBC driver: *PostgreSQL Unicode 
8.02.04.00 (PSQLODBC34W.dll) 27.4.2007

*Josef Springer*

*Vernon Cole wrote:
> 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 <mailto: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

pgsql-odbc by date

Next:From: Arnaud LesauvageDate: 2011-03-03 11:16:30
Subject: Access Autonumber fields not detected in 9.0.0200
Previous:From: Vernon ColeDate: 2011-02-20 05:53:07
Subject: Re: ODBC does not work after installation of MS-SQLExpress

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