HP Web Jetadmin Software Manuale Utente Scaricare il pdf (Pagina 6)

CHECKING THE CONNECTION

Now you are ready

to test the

connection using

your remote

Microsoft Excel.

Simply use the Data

Connection Wizard

shown in Figure 5.

If the connection

succeeds, a new

Data Connection

Wizard dialogue

appears as shown

in Figure 5.

If this dialogue

appears, you have

established a

successful

connection to the

SQL database

instance and can

now proceed with

Excel or a similar

application.

USING AN ODBC CONNECTION

So far we have talked about how to set

up the SQL instance so that it can be

accessed remotely. In this section, we

talk about a Windows utility that is

sometimes needed to set up a data

source to a remote system where

HP Web Jetadmin is running. An

example of when this utility is needed is

in Microsoft Excel where using the

Microsoft Query tool to establish the

data get action requires that an

established ODBC connection. First, we

will look at establishing the connection

and then we will show the MS Query in

Excel.

Figure 6 shows a utility that is launched through Start, Control Panel, Administrative Tools, Data

Sources (ODBC).

Figure 5 – Data Connection w/ SQL catalogue and table details

Figure 6 – Data Sources (ODBC)

1 2 3 4 5 6 7 8

Commenti su questo manuale

Nessun commento

HP Web Jetadmin Software Manuale Utente Pagina 6

Commenti su questo manuale

Prodotti e manuali riguardandi no HP Web Jetadmin Software