Jump to content

Archived

This topic is now archived and is closed to further replies.

Orion

MySQL on a network

Recommended Posts

Is it possible to have MySQL and MyODBC running on a local machine and have it point to a database placed on a server that isn\'t running MySQL?

 

If so, what do you have to edit in the my.ini and MyODBC? I can\'t get my computer to connect to the database I\'ve placed on my server.

 

Any advice would be awesome.

Share this post


Link to post
Share on other sites
Is it possible to have MySQL and MyODBC running on a local machine and have it point to a database placed on a server that isn\'t running MySQL?

 

What do you mean by pointing to database that isnt running Mysql? Do you mean that there is another RDBMS package like orcale or MSSQL installed ?

 

Well Myodbc is an interface to connect to a remote database and also to create DSN to use with other applications.

 

You have to make me clear about what you are trying to do so that we can help you better.

 

If you are talking about synchonization then there are tools available for that and aslo you have to ensure that your RDBMS supports that.

Share this post


Link to post
Share on other sites

Sorry if I was kinda vague.

 

Here\'s the scenario I\'m wondering about.

 

I have MySQL 4.01 running on my Win2k machine and I have created a database and everything is working fine. I\'m trying to see if I can move that database to another drive on our network, and MySQL is not running on that server. I just want my machine to look at the database no matter where I put it.

 

I tried editing my.ini file and I also tried creating a symbolic link, but I don\'t seem to have the information I need to make these work.

 

Any advice?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.