Help With ODBC Setup

Please post here if you have problems in using Wing FTP Server.

Help With ODBC Setup

Postby rboteler » Fri Feb 04, 2011 2:37 pm

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.
rboteler
 
posts 7
 
joined Thu Jan 27, 2011 10:12 am

Re: Help With ODBC Setup

Postby FTP » Fri Feb 04, 2011 4:12 pm

Which error code did you see in the logs?
FTP
Site Admin
 
posts 1236
 
joined Tue Sep 29, 2009 6:09 am

Re: Help With ODBC Setup

Postby rboteler » Mon Feb 07, 2011 10:43 am

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)
rboteler
 
posts 7
 
joined Thu Jan 27, 2011 10:12 am

Re: Help With ODBC Setup

Postby FTP » Mon Feb 07, 2011 12:54 pm

Do you mean you can connect to ODBC successfully when no user/pass given? So just leave the user/pass empty.
FTP
Site Admin
 
posts 1236
 
joined Tue Sep 29, 2009 6:09 am

Re: Help With ODBC Setup

Postby rboteler » Mon Feb 07, 2011 2:15 pm

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
rboteler
 
posts 7
 
joined Thu Jan 27, 2011 10:12 am

Re: Help With ODBC Setup

Postby FTP » Mon Feb 07, 2011 2:41 pm

I see, it is also referred by this KB article: viewtopic.php?f=5&t=272
FTP
Site Admin
 
posts 1236
 
joined Tue Sep 29, 2009 6:09 am


Return to Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron