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

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*
>
>