Hi,
Does anyone know how to connect to a Micros 3700 database remotely through .Net? I can connect locally with either an OleDB or ODBC connection, but can't seem to get the connection string right to get into the other systems on our network.
I have a couple of exports that are required on demand. The queries are already working and I have a program that will run the query, do the post processing and transfer the results back to me, but it still requires me to dial into each of our 22 sites and run it. I'd like to be able to run it from my test server and connect to each of the stores. It seems like it should just be a matter of getting the right connection string but I just can't get it to work.
Our Micros systems are all between Res 4.6 and 4.9, and I have 4.9 loaded on my test system so the drivers are all there.
Thanks
Does anyone know how to connect to a Micros 3700 database remotely through .Net? I can connect locally with either an OleDB or ODBC connection, but can't seem to get the connection string right to get into the other systems on our network.
I have a couple of exports that are required on demand. The queries are already working and I have a program that will run the query, do the post processing and transfer the results back to me, but it still requires me to dial into each of our 22 sites and run it. I'd like to be able to run it from my test server and connect to each of the stores. It seems like it should just be a matter of getting the right connection string but I just can't get it to work.
Our Micros systems are all between Res 4.6 and 4.9, and I have 4.9 loaded on my test system so the drivers are all there.
Thanks