MySQL Bugs: #11073: Cannot connect within MS SQL Enterprise Manager

Bug #11073	Cannot connect within MS SQL Enterprise Manager
Submitted:	3 Jun 2005 13:13	Modified:	4 Jan 2006 10:42
Reporter:	Udo Lindner	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MaxDB	Severity:	S1 (Critical)
Version:	7.5.0.26	OS:	Windows (Windows2000)
Assigned to:	Ulf Wendel	CPU Architecture:	Any

Description:
When I try to create a DTS package in MS SQL 2000 Enterprise Manager to establish a connection to MaxDB on a Linux Server

I allways get an error:

Hresult 0x80040e4d (xxx)returned
Unexpected error occured. An error result was returned without an error message.

OS Windows 2000 Server SP4
MS SQL Server SP4

Max DB ODBC 7.5.0.26

ODBC Datasource defined as system DSN

How to repeat:
Create local Package

choose MaxDB as ODBC source

choose DNS

enter UserID and Password

=> recieve error message

Trying to access the  MaxDb with Access XP is working fine

Udo,

as you say that other clients can access the MaxDB database using ODBC, I doubt that this is a MaxDB related problem.

Please check the KNLDIAG / Database Messages file if MaxDB closes the connection for whatever reason. If there's no hint in this files, continue your search by turning on the ODBC trace, check http://dev.mysql.com/doc/maxdb/en/14/1d733cefd63c38e10000000a114084/frameset.htm for details. 

If there's an error message in the trace, please post it.

Best regards,
Ulf

When I activate the ODBC trace the following is logged:

_____________________________________________________

<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body ><PRE><PLAINTEXT>
PRODUCT : MaxDB C-PreComp Runtime
VERSION : 7.5.0
BUILD   : 026-123-094-430

DATASOURCE: WDDSap
SESSION   : 1;    
SQLMODE   : INTERN
SERVERDB  : WDD               
SERVERNODE: Servername.sap.intra
CONNECT "USERID            " IDENTIFIED BY :A   ISOLATION LEVEL 1
SQLCODE:  -4008      Unknown user name/password combination
START  :  DATE :  2005-06-17    TIME :  0009:37:29
END    :  DATE :  2005-06-17    TIME :  0009:37:29
 
SQCFINISH         

________________________________________________________

Is there maybe a problem which character set is used by the MSSQL Server and the MaxDB which make problem for the login?

Hi,

according to the log you're not providing correct login credentials. Please verify 
username and password.

I don't think that there's any issue with the character sets.

Regards,
Ulf