Jump to content


Photo

MySQL on a network


  • Please log in to reply
2 replies to this topic

#1 Orion

Orion
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 11 September 2003 - 02:55 PM

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.

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 12 September 2003 - 05:59 AM

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.
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 Orion

Orion
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 15 September 2003 - 03:33 PM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users