Orion Posted September 11, 2003 Share Posted September 11, 2003 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. Quote Link to comment Share on other sites More sharing options...
shivabharat Posted September 12, 2003 Share Posted September 12, 2003 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. Quote Link to comment Share on other sites More sharing options...
Orion Posted September 15, 2003 Author Share Posted September 15, 2003 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.