Migration in SQL 6.5 to 2000 using a powerbuilder

  • I have upgraded my SQL Server 6.5 to SQL server 2000, it is successfully migrated. i am using PowerBuilder 5.0, in the DBMS: ODBC it can connect to the database of SQL 2000 but my problem is: when i run my program their is 1 problem i encounter, when i am logging in in the program i says invalid Logon-id & next try invalid password but the logon-id & password i input is correct... then when i switch sql 2000 to 6.5 and i run the program then i log, i can the logon-id & password is correct then i can access the database...

    can u help me if is the problem, is the powerbuilder 5.0 is complicated to sql 2000, because i can access my database in sql 6.5.

  • WHat type of connection method are you using? If ADO then it try an updated MDAC that is compatible with 2000. I believe is a limitation in the connector you are using.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply