Web.Config and Handheld Connections For eoMobile 2009

From Wiki-eostar.com
Jump to: navigation, search

These steps are used to create and modify connection settings for all mobile devices in order to connect them to the system. These instructions are for both Windows XP and Vista operating systems.

With the recent changes to the handheld connections, the web.config must be configured to ensure a steady stream of information from the database to the mobile devices. These steps only need to be performed once and fix the settings for all the mobile devices.

On IIS 6

  • Start, right click on My computer click "Manage".

Handheld connections 2.gif

  • Locate DefaultWebSite and right click and select properties.

Handheld connections 3.gif

  • Select the tab ASP.NET. Click the command button “Edit Global Configuration”.

Handheld connections 4.gif

  • Under Connection String Manager, click “add”.

Handheld connections 5.gif

  • Type in the database name and the connection parameters. The connection string should not contain any spaces.
    • The server = the SQL server the database is located on.
      • NOTE: If your eoStar database resides in a Named SQL Instance it must be specified here as well. (ie. "Server=ServerName\InstanceName")
    • Database = the name of the database.
    • User ID= the SQL user with read write permission to the database.
    • Password = the password for the user.

EXAMPLE:

Server=eostar.ruthsx.com;Database=eostarlive;User ID=hh;Password=●●●

(hint: Follow capitalization and spacing exactly)

Handheld connections 6.1.gif

On Windows Vista (IIS 7)

  • Right click on “Computer” from the “Start Menu”, and then select “Manage”.

Handheld connections 2.1.gif

  • Under Connections, locate the IIS manager under Services and Applications.

Handheld connections 2.13.gif

  • Select the Default Web Site and double-click Connection Strings.

Handheld connections 2.18.gif

  • Right-click and select "Add" to create a new connection.

Handheld connections 2.3.gif

  • Edit the connection strings.
    • Name - what you wish to call the database.
    • Server - the SQL server name.
      • NOTE: If your eoStar database resides in a Named SQL Instance it must be specified here as well. (ie. "Server=ServerName\InstanceName")
    • Database - Database Name.
    • Use the radio buttons to choose either integrated security or specific credentials. Click "Set" to setup the SQL user name and password for the specific credentials.

Handheld connections 2.4.gif

  • The connections will be in eoNetService's connection strings as well because it will be "Inherited". Because it is in the Default Web Site, subsequent un-installing of the eoNetService will not destroy the connection strings.

Handheld connections 2.5.gif

Server 2008

Server 2008.gif

Default Web Site vs. eoNetService

The following is an example of why the connection strings should be setup in the Default Web Site rather than eoNetService. The "inherited" connection strings were setup in the Default Web Site. The "Local" connection string was setup in eoNetService.

Handheld connections 7.1.gif

So when the program eoNetService is uninstalled...

Handheld connections 7.2.gif

... note that the "local" test connection was deleted with the un-installation of eoNetService; however, the "Inherited" connections remain.

Handheld connections 7.3.gif

Mobile Devices

For more information, see Handheld Connection or EoTablet Setup Connection.

  • The mobile web site is = this is the previously known IIS server (Internet Interfacing Server). The IIS server needs to be an IP address that is both public and static.
  • The mobile user is the = name of the connection string with a period and the handheld number. For example demo.8, dragon.2, or sampledb.12.
  • The access password is the assigned employee's handheld password.

Handheld connections 1.gif Tablet setup connection 09.gif

Connection Test

The following steps are a quick way to test the database connection using the new connection string.

1. Open Internet Explorer and browse to http://iisserver/eonetservice/h3.asmx (IISserver should be the name of the server with the new web service). The Page should look like this:

Webservice connection test 1.gif

2: Click Ping
3. Fill in the Login and Password fields
  • Login (the name of the connection string you setup, dot, handheld number. Ie “test.12”)
  • Password (the access password, for the Employee assigned to the handheld you’re testing, Ie “access”, if your employee has no access password leave this field blank)

Webservice connection test 2.gif

4. Click Invoke.
If everything is setup properly you should be greeted with a message like the following:

Webservice connection test 3.gif

Possible Errors

If you’re using the wrong access password for this user’s handheld you’ll receive an error like:

Webservice connection test 4.gif

If your connection string has a bad user name or password for SQL, you’ll receive an error like:

Webservice connection test 5.gif

If your SQL username and password is correct but the database is not found on the server, you’ll receive an error like:

Webservice connection test 6.gif

If your SQL server can’t be found by the web service, you’ll receive an error like:

Webservice connection test 7.gif

If you’re attempting to use a handheld number that has no employee assigned you’ll receive an error like:

Webservice connection test 8.gif

If you’re attempting to use an erased handheld record you’ll receive an error like:

Webservice connection test 9.gif

If you’re attempting to use a handheld record that doesn’t exist, you’ll receive an error like:

Webservice connection test 10.gif

If you’re Login isn’t formatted properly, you’ll receive an error like:

Webservice connection test 11.gif

Connection Test 2 (Old)

The following steps are a quick way to test the database connection.

  • Go to Microsoft Excel and from the Data tab select Connections.

Handheld connections 3.1.gif

  • Add a new connection by clicking "Add".

Handheld connections 3.2.gif

  • Select "Browse for More".

Handheld connections 3.3.gif

  • Select "New Source".

Handheld connections 3.4.gif

  • Using the Data Connection Wizard, follow the instructions on the data connection wizard.

Handheld connections 3.5.gif

Handheld connections 3.6.gif

  • Select the database.

Handheld connections 3.7.gif

  • Click "Finish".

Handheld connections 3.8.gif

  • If it connects, the connection is good.