Could not make connection - When connecting to an External Database

Could not make connection - When connecting to an External Database

by Craig Preston -
Number of replies: 0

I think I have everything set up correctly but I can not seem to get a handle on why it will not connect to my external database. Below are some screen shots, could someone take a look and give me a hint.

Thanks,

From Moodle,

External Database Server Settings

enrol_dbtype

access

Database type

enrol_dbhost

63.151.45.78

Server IP name or number

enrol_dbuser

training

Server user

enrol_dbpass

xxxxxxxxxx

Server password

enrol_dbname

childcaredata

Database name

enrol_dbtable

Students_Assigned

Database table

From my hosting provider:

General Web Settings

Description:

CHILDCAREHUB.COM

Web Root Directory:

e:\web\childcarehub.com

FTP Root Directory:

e:\web\childcarehub.com

IP:

63.151.45.78

Port:

80

SSL Port :

443

Datasource Name

Type

Database

Sql Server

Options

CHILDCAREDATA

MS Access

e:\web\childcarehub.com\db\childcaredata.mdb

Average of ratings: -