Strange ODBC error after upgrading to 6.4.4

Please post here if you have problems in using Wing FTP Server.
Post Reply
JohnsonCat
Posts: 10
Joined: Mon Nov 02, 2020 5:58 am

Strange ODBC error after upgrading to 6.4.4

Post by JohnsonCat »

got strange errors in domain log after upgrading to 6.4.4

ODBC ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'wftp_table_upgrade622'

it seems to happen everytime after i edit user properties.
i can tell the table is there in the sql database. any idea?
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Strange ODBC error after upgrading to 6.4.4

Post by FTP »

OK, please check whether exists the table "wftp_table_upgrade622", if not exist, please create this table manually:
CREATE TABLE wftp_table_upgrade622 (version int)
JohnsonCat
Posts: 10
Joined: Mon Nov 02, 2020 5:58 am

Re: Strange ODBC error after upgrading to 6.4.4

Post by JohnsonCat »

i actually figured out after i post.
the database was created with the service account as db scheme, for example, it was created as [domain\account].database, so i transfer the scheme to sql default scheme [dbo]., and restart wftp server, the error is gone.
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Strange ODBC error after upgrading to 6.4.4

Post by FTP »

That's great! Thanks for your feed back!
Post Reply