Обсуждение: ODBC does not work after installation of MS-SQLExpress

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

What can i do ? Any tipps are wellcome !!!

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

	Address	Josef.Springer@joops.com	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
	Office	+49 (0)89 600 6920
	Fax	+49 (0)89 600 69220
	Web	http://www.joops.com

(HRB München 86239) -- the software company --

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

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.Springer@joops.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