Installing Outlet Selection
 
Return to Online Manuals
 
Requirements
= Operating System: Windows 2000 or XP
= Access: Version 10 (Office XP)
= Broadband Internet Access
= Internet Explorer: Version 5 or above
 
Install mySQL ODBC drivers
A mySQL ODBC Driver acts as a translator between Outlet Selection and the data you see in StoreManager Online.
The mySQL ODBC driver needs to be installed on all the machines Outlet Selection will be used on.
The relevant files are on the CD you were given. Either MyODBC-3.51.11-2-win.exe or MyODBC-3.51.11-2-win.msi should work, but if one does not try the other.
The mySQL ODBC Driver does not yet work in a 64 bit operating system. So if the operating system on your machine is 64 bit, it is important for the system adminstrator to use the 32 bit ODBC administrator as opposed to the default 64 bit one to set up the DSNs.
You can see if it has already been installed if your ODBC Administrator shows MySQL ODBC 3.51 Driver on its list of drivers, when you click the Add button. For descriptions of how to find this Add button look under Create MySQL ODBC 3.51 Driver System DSN.
To install the mySQL ODBC Driver double click one of MyODBC-3.51.11-2-win.exe or MyODBC-3.51.11-2-win.msi and then follow the installation wizards instructions.
  NB If you need any guidance on creating folders or copying files go to Using Windows Explorer
 
Create MySQL ODBC 3.51 Driver System DSN
A DSN (Data Source Name) remembers where the data is and which driver should be used to talk to it.
If you are using standard 32 bit Windows, you open the ODBC Aministrator by clicking Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC). Then go to the System DSN Tab, and it should look like this.
SystemDSN.jpg
Click Add
You will get this.
CreateNewDataSource.jpg
Select “MySQL ODBC 3.51 Driver”, it is often right at the bottom, and click Finish
You will get a screen like this
BlankConnectorODBC.jpg
Enter these values
Data Source Name SelectOutlet
Description (Optional - put in notes for yourself)
Server 212.100.249.5
User SelectOutlet
Password Telephone 08707 430043 or 01753 648800 during office hours
Database Web
Click Test and you should get a message like this.
ConnectionWasMade.jpg
Click this OK, and then the OK on Connector/ODBC Add Date Source Name and you will return to the ODBC Data Source Administrator Form showing the System DSN Tab, which you should also OK out of.
You will need to create these DSNs on any machine you install OutletSelection.mdb on to.
 
Final Touches
Create these folders: C:\StoreManager\OutletSelection\ on your C Drive
Copy outletSelection.dmb from the CD you were given in to the new folder C:\StoreManager\OutletSelection\
  NB You may keep a copy on a server to make it easier to install on new machines, but you cannot open the application there.
  NB If you need any guidance on creating folders or copying files go to Using Windows Explorer
 
Optional Final Touches
To make your life easier you may want to create a shortcut on your desktop.
First copy Blue Shop.ico from the CD to C:\StoreManager\OutletSelection\
  NB If you need any guidance on creating folders or copying files go to Using Windows Explorer
Then to create the shortcut:
Right click on your desktop in the area you want your shortcut to be created,
Select New, and then Shortcut in the menus which appear.
ShortcutMenu.jpg
You will then be offered this
CreateShortCut1.jpg
Click Browse ... and navigate to C:\StoreManager\OutletSelection\, and select OutletSelection.mdb.
CreateShortCut2.jpg
Click OK
and you will see this.
CreateShortCut3.jpg
Click Next > and you will see something like this.
The text shown here is the name of the shortcut and will be what is shown on your desktop, so it may be worthwhile to check it is to your liking.
CreateShortCut4.jpg
Click Finish and your new desktop shortcut will appear, with the default access image.
Shortcut1.jpg
If you want to customize the image of the shortcut, right click the shortcut you have just created and in the menu which appears, select Properties.
ShortcutMenu2.jpg
You should get this, making sure the Shortcut tab is on the top.
Properties.jpg
Click Change Icon
and you will get this
ChangeIcon.jpg
Click Browse ... and navigate to C:\StoreManager\OutletSelection\ and select Blue Shop.ico.
You will see the Change Icon form change to this.
ChangeIcon2.jpg
Click OK on Change Icon
and you should return to this
Properties.jpg
Click Apply which should change Outlet Selection Properties to this.
Properties2.jpg
Click OK
The shortcut on the desktop should now look like this.
Shortcut2.jpg
 
Return to Online Manuals
 
©Storecheck Marketing Ltd, 2007
No part of this document may be reproduced without express permission in writing from the Managing Director of Storecheck Marketing Ltd