Обсуждение: 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 !!!
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
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
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:
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 ColeOn 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