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.
Help With ODBC Setup
-
- Site Admin
- Posts: 2083
- Joined: Tue Sep 29, 2009 6:09 am
Re: Help With ODBC Setup
Which error code did you see in the logs?
-
- Posts: 7
- Joined: Thu Jan 27, 2011 10:12 am
Re: Help With ODBC Setup
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)
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)
-
- Site Admin
- Posts: 2083
- Joined: Tue Sep 29, 2009 6:09 am
Re: Help With ODBC Setup
Do you mean you can connect to ODBC successfully when no user/pass given? So just leave the user/pass empty.
-
- Posts: 7
- Joined: Thu Jan 27, 2011 10:12 am
Re: Help With ODBC Setup
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
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
-
- Site Admin
- Posts: 2083
- Joined: Tue Sep 29, 2009 6:09 am
Re: Help With ODBC Setup
I see, it is also referred by this KB article: http://www.wftpserver.com/bbs/viewtopic.php?f=5&t=272