...the SQL Query Tool that was designed with you in mind
Get Productive Today!
Home | Product Features | Screenshots | Videos | Download\Purchase | Support Forum | About

Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
ODBC & SQL Anywhere Issues
Options View
Previous Topic Next Topic
Wizard Offline
#1 Posted : Wednesday, July 28, 2010 10:45:05 PM
Rank: Newbie

Medals:

Groups: Member
Joined: 11/7/2009
Posts: 4
Location: Melbourne, AUS

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
Brad

I have found two issues with regard to the ODBC connection as well as a connection to Sybase SQL Anywhere

1. Connection to SQL Anywhere DB V11 on Network not possible
Datasource keeps assuming the DB is on the local box. The same happens when I try to connect using ODBC.

2. ODBC connection to an older version of SQL SQL Anywhere DB on local box worked OK, however
a. the table names were truncated
b. Table names contained Chinese characters
c. Column names contained chinese characters.

Any suggestions?

Regards

Stan
Back to top
Report?
Sponsor  
 
Werysoft's QweryBuilder
Back to top  
bradwery Offline
#2 Posted : Thursday, July 29, 2010 10:08:46 AM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
Issue 1)

QB is using a pre-defined ODBC data source to make the connection to the SQL Anywhere database. Can you test the connection using the ODBC Administrator?

Issue 2)

The SQL Anywhere data sources use ODBC to connect so using the ODBC option isn't needed. If you connect to the SQL Anywhere database as an SQL Anywhere datasource, do you still see issues?
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
1 user thanked bradwery for this useful post.
Wizard on 7/29/2010
Wizard Offline
#3 Posted : Thursday, July 29, 2010 6:57:02 PM
Rank: Newbie

Medals:

Groups: Member
Joined: 11/7/2009
Posts: 4
Location: Melbourne, AUS

Thanks: 1 times
Was thanked: 0 time(s) in 0 post(s)
Brad,

Both suggestions worked.

This is now a great tool. Thank you very much.

Stan
Back to top
Report?
bradwery Offline
#4 Posted : Friday, July 30, 2010 6:59:39 AM
Rank: Administration

Medals:

Groups: Administration
Joined: 2/5/2009
Posts: 84
Location: Manitoba, Canada

Thanks: 0 times
Was thanked: 3 time(s) in 3 post(s)
Excellent. Let me know if there are any other questions or concerns.

Regards,
Brad Wery
Lead Architect
Back to top
WWW BLOG
Report?
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.4 RC1 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.530 seconds.
Copyright © 2008-2010 Werysoft Inc. All rights reserved.
SQL Query Tool | SQL Editor | Database Development Tool | SQL References | Testimonials