ODBC does not work after installation of MS-SQLExpress

This is a multi-part message in MIME format.
--------------080601020907010705000604
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello everybody,

my ODBC driver does not work allready. If i press the button /Test /in=20
the configuration dialog of ODBC-Datasources, i get *Communication=20
closed during Authentication; Connection reset by peer*. Username and=20
password is correct !

This worked up to yesterday. Yesterday had to install *Microsoft=20
SQLExpress Version 8*. Because of SQLExpress, had to install *Windows=20
Management Framework-Kernpaket* too. Now i get the connection error. :-(

Used PostgreSQL-ODBC driver: *PostgreSQL Unicode 8.02.04.00=20
(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)

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

JOOPS
(HRB München 86239)

*-- the software company --*


--------------080601020907010705000604
Content-Type: multipart/related;
boundary="------------010202040606040308040701"


--------------010202040606040308040701
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit






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. class="moz-smiley-s2"> :-(



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)

height="16" vspace="2" width="17">	Address	color="#cc0000">	Orlando-di-Lasso Str. 2	D-85640 Putzbrunn
src="cid:part2.04080901.06050806@joops.com" alt="Phone" height="15" vspace="2" width="13">	Office color="#000099">	+49 (0)89 600 6920
alt="Phone" height="15" vspace="2" width="13">	Fax color="#000099">	+49 (0)89 600 69220
alt="Web" height="15" vspace="2" width="15">	Web color="#000099">

alt="JOOPS" align="left" height="61" hspace="0" width="220">

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

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

--001636848295b3566a049cb05d35
Content-Type: text/plain; charset=ISO-8859-1

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

--001636848295b3566a049cb05d35
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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.=A0 It works fine for me:
v =
v v v v


C:\hg\adodbapi\test>c:\python27\python.exe testADOdbapi.py
2.7 (r27:8=
2525, Jul=A0 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...<=
br>

     dbms_name=3D"Microsoft SQL Server"
     d=
bms_version=3D"10.50.1600"
   ...Testing MySql login... >     dbms_name=3D"MySQL"
     dbms_version=3D=
"5.1.49-1ubuntu8.1"
=A0 ...Testing PostgreSQL login...


     dbms_name=3D"PostgreSQL"
     dbms_versio=
n=3D"8.4.7"
^ ^ ^ ^ ^
=A0 But I note that I am using more c=
urrent versions than you.=A0 Have you tried updating to the latest SQLExpre=
ss and driver?
--


Vernon Cole

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

This is a multi-part message in MIME format.
--------------040602020006040108030501
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello Vernon,

thanks for quick answer.

I downloaded the latest SQLExpress and driver from
http://www.microsoft.com/downloads/details.aspx?FamilyID=58c e885d-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
> > 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*
>
>



--------------040602020006040108030501
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit








Hello Vernon,



thanks for quick answer.



I downloaded the latest SQLExpress and driver from
.

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:
cite="mid:AANLkTimUhBO9V3mZ9BGniOhb2RpaB5c8OYZScmDWS757@mail .gmail.com"
type="cite">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