Help With ODBC Setup

Please post here if you have problems in using Wing FTP Server.
Post Reply
rboteler
Posts: 7
Joined: Thu Jan 27, 2011 10:12 am

Help With ODBC Setup

Post by rboteler »

Im trying to set-up a test WingFTP server, I want to try the features before we commit and buy the product.

Im having some difficulty setting up the ODBC connection. I have configured a system DSN called "WingFTP" and have tested it. When I set-up the ODBC Connection within the Authentication setting within the Wing Admin area, I keep getting "Database Connection Failed".

I assume the ODBC source is the name of the DSN i have created.
I also assume the the password is for SQL authentication not Windows.

Can someone advise what im doing wrong please,

Thanks.
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Help With ODBC Setup

Post by FTP »

Which error code did you see in the logs?
rboteler
Posts: 7
Joined: Thu Jan 27, 2011 10:12 am

Re: Help With ODBC Setup

Post by rboteler »

The only error I can find related to this is in "C:\Program Files (x86)\Wing FTP Server\Log\System".

The error I get is:
[02] Mon, 07 Feb 2011 10:43:55 ODBC ERROR: Could not connect to DSN 'WingFTP' with SQLSTATE:IM002 (user:WingFTP password:WingFTP)
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Help With ODBC Setup

Post by FTP »

Do you mean you can connect to ODBC successfully when no user/pass given? So just leave the user/pass empty.
rboteler
Posts: 7
Joined: Thu Jan 27, 2011 10:12 am

Re: Help With ODBC Setup

Post by rboteler »

I have figured the issue out now. The installation is on a x64 machine, as the Wing FTP software is running as x86 software ive had to use the x86 odbc config tool.

I found this from a post on the msdn forum, someone had a similar issue:
"DSN’s for 32bit and 64bit are stored separately in registry, those in HKLM/HKCR are for 64bit, 32bit DSN’s are stored in WOW registry.

You need to use the 32bit odbc admin tool (from windows\syswow64) to create 32bit DSN’s for your 32bit application"


Thanks for your help,

Rob
FTP
Site Admin
Posts: 2072
Joined: Tue Sep 29, 2009 6:09 am

Re: Help With ODBC Setup

Post by FTP »

I see, it is also referred by this KB article: http://www.wftpserver.com/bbs/viewtopic.php?f=5&t=272
Post Reply