
Error 536 (Incorrect logon parameters) when trying to logon to a access-db via PELogonServer
I use
Crystal Reports Developer. Version 8.5.0.217
Within my VB6-Programm I'm trying to logon to a secured Access-Database
(Access 97).
Now I have a ugly problem when distributing the programm:
* installed on WinME everything works fine. The reports starts without
error. (My devellopping-system is also WinME, maybe...)
* installed on Windows XP or Win 2000 the error 536 (Incorrect Logon
Parameters) occurs.
The only hint I found about that error was the Crystal-Knowledge-Base
Article "c2000028" (...call PESetNthTableLogonInfo and pass only the
ServerName and DatabaseName. Leave UserID and Password empty...).
But that doesn't help me, cause I need to use a special UserID and password
because of my secured database .
(And I'm not trying to connect to a Sql-Server)
I make the necessary registry-entries for ODBC "manually" in my programm.
Maybe that's the point; but why does it then work fine when installed on a
(new) WinME?
Has anybody any idea ?????
My code:
LogOnInfo.ServerName = sServerName & Chr$(0)
LogOnInfo.DatabaseName = sDatabaseName & Chr$(0)
LogOnInfo.UserID = sUserId & Chr$(0)
LogOnInfo.Password = sPassword & Chr$(0)
If PELogOnServer("P2SODBC.DLL", LogOnInfo) = False Then
'error handling
End If
best regards
Marion