Hi Bruce:
Sql Server is a Microsoft Product while MySql is not a Microsoft product and
you can not substitute one server for the other within an application that uses
either one of them.
I dont think it matters how much you tweek the statements one server's
applications (Databases) will not run on the other server since they both have
underlying code bases independent of each other.
This is just a heads up in case you try and use MySql as the data repository
for the PcAmerica POS software which uses the Microsoft Sql Server, think the
Express version, Database engine.
If you get it to work let me know since my understanding is that you cant swap
database engines for a given version of a Database.
Rick USA
----- Original Message -----
From: BT
To: [email protected]
Sent: Thursday, March 01, 2012 11:14 AM
Subject: Re: Remote Session Scripting Question
HI Rick,
Yes, I know, and have not yet done anything remote. I am doing this to
learn such a routine. SQL is SQL with maybe a few different spellings of
things. Doing this to learn remote processes.
Any help would be appreciated.
Bruce
Sent: Thursday, March 01, 2012 4:27 AM
Subject: Re: Remote Session Scripting Question
Hi Bruce: Just a quick question about the WAMP Server:
I thought WAMP was a PHP MySql Apache platform.
Are you able to use Sql Server rather than MySql as the DataStore?
Sql Server and MySql are 2 totally diferent platforms.
Rick USA
----- Original Message -----
From: BT
To: [email protected]
Sent: Wednesday, February 29, 2012 3:27 PM
Subject: Re: Remote Session Scripting Question
Hi Rick,
Yes, that is the one I was talking about. I had not approached it
yet. I have done SQL server on my own machine, just using the WAMP server. I
would like to look into it and see what is needed. I downloaded the app for my
machine and also took a look at there demo on there web site. Just have not set
up any windows stuff yet since I was working on my Uninstall program and got
sidetracked on silly issues.
Let me know for I would definitely like to look at it.
Bruce
Sent: Wednesday, February 29, 2012 11:15 AM
Subject: Re: Remote Session Scripting Question
Thanks Guys:
I will have to do some reading on RDP Connections to get familiar with
that technology to see if it may be the way to go.
Ihave a failed UnInstall of Sql Server on this development machine
requiring a ReInstall of the XP OS to repair properly. This precludes me from
installing the POS Software on it for scripting, I dont want to go through that
hassle again and I cant afford a new machine right now.
Bruce, I am not sure what the Victory App is but this app would be for
Victory Associates INC. who needs a Point Of Sale package scripted.
I think the package is put out by a company called PCAmerica and uses
Sql Server Express and relies on a user defined VPN for communications between
locations.
If you are working on this already let me know and I will be glad to
help out if I can.
I am in communications with the business owner and am trying to keep
him informed as to any progress, or lack there of, in my analysis of the
possibility of building a script for him.
If I cant do it perhaps someone else can and, if you are already on the
project let me know and I will help out if I can.
Rick USA
----- Original Message -----
From: BT
To: [email protected]
Sent: Wednesday, February 29, 2012 8:17 AM
Subject: Re: Remote Session Scripting Question
Hi Rick,
Is this the Victory Market app? I was going to work on that next
since I have most of the Uninstall program done. But will let you know when I
look at it.
Bruce
Sent: Wednesday, February 29, 2012 4:45 AM
Subject: Remote Session Scripting Question
Hi:
Someone has asked me about scripting a Point Of Sales software
package and I am not sure about how best to proceed.
The main Database Server and the main Forms to be scripted live on
his local machine or machines.
I am wondering if a Remote Session of some sort could be used to do
some programming, WE scripting, on his local machine network from a remote
computer in another state.
In other words:
I want to log on to his computer network and, on his machine,
Access all the features of the POS system as if I were there, Use the Scripting
Tools from GW Micro and others to analyze each form and create analysis reports
as if I were working directly on his machine, write, test and debug scripts to
make the POS software package loaded on his local store network accessible.
Is this something that has been done by you guys at GW Micro or any
of you sophisticated App Programmers?
Thanks:
Rick USA
