Hi, How can I define a MySql "Remote Server" on Linux ? Can I define some proxy table to INSERT data on MySql server ? Thanks.

asked 10 Mar '10, 08:18

NCister's gravatar image

NCister
16191016
accept rate: 0%

edited 10 Mar '10, 08:40

Volker%20Barth's gravatar image

Volker Barth
30.6k306456662

Welcome NCister, by the way:) - I just retagged the question as "proxy tables" seems to be the more common term:)

(10 Mar '10, 08:43) Volker Barth

Just as a quick start (I don't use MySQL, so I can't give an example):

What SA version are you using?

Starting with SA 11.0.0, MySQL is supported as a remote server (class "mysqlodbc"), so that should work. In older SA versions, you could use the generic remote server class "odbc".

You might have a look at the online docs. I don't know if there are particular Linux issues here (you might need to define an ODBC data source), but otherwise, proxy tables are quite easy to use.

Basically you have to do three steps:

  1. Define a remote server in SA (say, "SRV_MySql")
  2. Define an externlogin for that remote server (supplying the MySQL login credentials)
  3. Create proxy tables for the tables/views you are wanting to access through SA

Insert/update/delete through SA should be possible as long as you do not define the remote server as readonly and as the connected user has according table permissions.

permanent link

answered 10 Mar '10, 08:39

Volker%20Barth's gravatar image

Volker Barth
30.6k306456662
accept rate: 32%

Comment Text Removed
Comment Text Removed

Hi Volker and thank You for replay ... My main problem is the Remote Server definition (I've already used proxy tables with ASA remote server...). I've tried with SA11 using Sybase Central wizard and the question is: What's the right (DSN less !) "connection information" for a standard MySql connection (on Linux, of course...) ? Consider that an example of my ASA Remote Server definition is:

Driver=/opt/sqlanywhere11/lib64/libdbodbc11.so; eng=xxxx; dbn=xxxx; uid=xxxxn; pwd=xxxx;

Thanks

permanent link

answered 12 Mar '10, 10:04

NCister's gravatar image

NCister
16191016
accept rate: 0%

Comment Text Removed

I think this is primarily a MySQL question. I would ask (or search) on a MySQL forum or StackOverflow. (But as stated, I'm no MySQL user, so it's just a guess.)

(12 Mar '10, 15:24) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×63
×15

question asked: 10 Mar '10, 08:18

question was seen: 1,255 times

last updated: 12 Mar '10, 10:04