Linking to a database

[Chad]

Hello,

I will be picking up HTML as a new lang as was wondering
if there is a easy piece of code for connecting to an
Access or SQL server database. Will be using ie 5.0 with
Front Page 2003 + XP Pro o/s.

Could you provide an example for both???

Thanks
Chad

 

[Steve Easton]

Chad I'm not trying to be rude, but if you're
"picking up" html as a new "language" you
are quite a way away from learning Access and sql.

There's really not an easy answer to your
question the way it is posted.

 

[Mike Mueller]

: Hello,
:
: I will be picking up HTML as a new lang as was wondering
: if there is a easy piece of code for connecting to an
: Access or SQL server database. Will be using ie 5.0 with
: Front Page 2003 + XP Pro o/s.
:
: Could you provide an example for both???
:
: Thanks
: Chad

For the most part, you will not be using HTML for connecting
to DBs. You would be using ASP pages which basically will
use vbscript for the connections. The connection strings
will vary between an SQL and Access DB, but all of the
commands to work with the DB will be SQL statements

Here is a sample connection string for an Access DB:

Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open application ("Database1_ConnectionString")


HTH
Mike