Front Page
(1)
Windows 7
(1)
Database
(1)
ODBC
(1)
OLE
(1)
DSN
(1)

Link Form to Access Database thru DSN

Asked By George
20-Feb-10 03:45 PM
I am using Front Page 2000 running on Windows 7

What I am trying to figure out is how to create a .ASP page to connect to my
Access database I uploaded to my web server provider. At their web service I
used their "Manage DSN Records" feature to upload my database and create a
link. Then inside the Front Page program I am at the "Insert > Database >
Results Wizard trying to make the connection. I am guessing in here I need to
enter the Domain Name, DSN Name, Etc. I have tried every possible combination
and just get a error message when I click on verify the connection such as:

Server error: Unable to connect to a database from the web server using the
connection string 'Removed My Web Servers name'.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

Does anyone know what values go in these fields ?

Thanks

George
Post Question To EggHeadCafe