Page 1 of 1

Help With ODBC Setup

Posted: Fri Feb 04, 2011 2:37 pm
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.

Re: Help With ODBC Setup

Posted: Fri Feb 04, 2011 4:12 pm
by FTP
Which error code did you see in the logs?

Re: Help With ODBC Setup

Posted: Mon Feb 07, 2011 10:43 am
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)

Re: Help With ODBC Setup

Posted: Mon Feb 07, 2011 12:54 pm
by FTP
Do you mean you can connect to ODBC successfully when no user/pass given? So just leave the user/pass empty.

Re: Help With ODBC Setup

Posted: Mon Feb 07, 2011 2:15 pm
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

Re: Help With ODBC Setup

Posted: Mon Feb 07, 2011 2:41 pm
by FTP
I see, it is also referred by this KB article: http://www.wftpserver.com/bbs/viewtopic.php?f=5&t=272