cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Anywhere 9

Former Member
0 Kudos
3,465

Good evening,

I do not have much knowledge NO0 Sybase DBMS and need help to manage and gives readings permissions to another DBMS Oracle. I need you to help me with the following questions:

  1. Creating a user read-only in SQL Anywhere 9 tool;
  2. What is the way to connect to this bank? Let's use an Oracle dblink for Sybase and must pass the access address.
  3. For Oracle connects to my Sybase database, you must (ODBC) driver? Can anyone tell me where to download and what to download?

Accepted Solutions (0)

Answers (2)

Answers (2)

Vlad
Product and Topic Expert
Product and Topic Expert
0 Kudos

The second answer I found in SA 10 Docs, called "Remote Data Access". It is probably what you need: Introduction to remote data access

The third one is probably described here (how to connect SA to remote servers: Working with remote servers). I haven't tried the next link with SA, but I guess this is what you need: Oracle ODBC Drivers.

I do not have much knowledge NO0 Sybase DBM

I think you can start with this book. There you can find examples how to create proxy tables. By the way I am curious when Breck writes the new book, because this is for SA 9 only 🙂

This is everything I can tell you.

reimer_pods
Participant
0 Kudos

"I am curious when Breck writes the new book": I doubt that he will ever do this, because I remembering him writing about that topic (too much time invested compared with the earnings).

VolkerBarth
Contributor
0 Kudos

FWIW, I guess he has even semi-retired (*) from writing articles on his great blog, and see - The Blog is the Book.

(*) @Breck: Just my own wild guesses, apparently:)

Vlad
Product and Topic Expert
Product and Topic Expert
0 Kudos

Oh, I didn't know this page. I am more curious (of course this is not a relevant comment to this topic), but isn't it worth writing books for money rather than write blogs for free?
I would write something 🙂 but I guess that everything I know seems obvious to me or to Google.

VolkerBarth
Contributor
0 Kudos

@Vlad: Just out of curiosity: You haven't known that particular blog article - or Breck's whole blog?

Breck_Carter
Participant

I confess to "lazy" but not "retired" 🙂

Also, SAP's extreme lack of enthusiasm for SQL Anywhere is infectious.

Once Foxhound 4 ships there may be a flurry of articles on the blog.

Breck_Carter
Participant
0 Kudos

"writing books for money" - that was never really true (think fifty cents an hour), but nowadays there is no such thing as a tech book.

VolkerBarth
Contributor
0 Kudos

"lazy" but not "retired" 🙂

That's good to know:)

Besides that, your blog is still way more active than the SQL Anywhere blogs within SCN - which seems to second your second statement... - I'm wild guessing, again.

Vlad
Product and Topic Expert
Product and Topic Expert
0 Kudos

The article. I know the blog, because Google always suggested me Breck's blog when I wanted to know about the HTTP server.
But I haven't read other articles through. And by the way, both this forum and the blog are in my RSS Reader.

Vlad
Product and Topic Expert
Product and Topic Expert
0 Kudos

50 cents an hour.

No-o-o. This cannot be... or at least I cannot believe. I expected that it might be close to this: http://www.payscale.com/research/US/Job=Writer/Salary

MCMartin
Participant
0 Kudos

To create a user use the tool Sybase central with the wizard