I have a program that runs on another sever that saves to a db. Is it possible to connect a Miva module to that servers db and pull information? I am currently doing an export and import once a day and looking for more update info.
Announcement
Collapse
No announcement yet.
Connect to database on another server
Collapse
X
-
Re: Connect to database on another server
Thanks David, before I started to try to figure out how to do it I wanted to make sure it was possible.Chris Dye
http://www.kseriesparts.com
Comment
-
Re: Connect to database on another server
The other quite common way of doing this (if the data isn't too sensitive) is to have a module or just mivascript script connecting to a simple script on the remote SQL Server site.Bruce Golub
Phosphor Media - "Your Success is our Business"
Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
phosphormedia.com
Comment
-
Re: Connect to database on another server
could be but i was thinking of straight data transfer...json would be the thing to use if this was displaying data in the user space at real time.Bruce Golub
Phosphor Media - "Your Success is our Business"
Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
phosphormedia.com
Comment
-
Re: Connect to database on another server
I will have to play with it to figure it out. not sure how much trouble it will be worth versus how I do it now. I could always increase the import and export if I really wanted as well.Chris Dye
http://www.kseriesparts.com
Comment
Comment