Problems converting old web address book

To the Ipswitch web site

Ipswitch Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Problems converting old web address bookExpand / Collapse
Author
Message
Posted 9/19/2008 12:27:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/30/2008 5:26:13 AM
Posts: 1, Visits: 13
Hello,

today I tried to convert some old web address books from IMail 8.x to IMail 2006.21 with wgscvt.exe.
I'm using an external sql user database (MS-SQL 2000).
If the domain has no dash in it (xxx.de), all works fine. Addresses were imported. If it has one or more dashes in this happens when I use wgscvt /sql:

Processing domain mail.xxx-yyy.de...
Checking for external database...
External database found: DSN=xxx; UID=yyyl; PWD=zzz; DB=ddd, table 'mail_xxx-yyy_de'
Opening external database...
Retrieving domain users...
Path: d:\mail\sites\xxx-yyy\users
2 user(s) (folder(s)) found
Verifying users...
User root verified
Retrieving user id from external database...
Error: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '-'.
Processing domain mail.almatec.de...

Looks like if there is some problem with "_" in the sql database and a "-" in the query/connection string.

Any suggestions?

Best regards, ISDF
Post #47125
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Dave, Mark Singh, kevin r gillis, Jason Benton, Brandon Felger, Tripp Allen, Jason Henline, Will Sansbury, Jason Williams, Hush, FTPplanet.com, Hugh Garber, WUP-PM, Tom Lewis, mmulryan@ipswitch.com, mswimm, Brad Senter

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 7:06pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.078. 7 queries. Compression Enabled.