Tilted Forum Project Discussion Community - View Single Post

05-20-2005, 04:35 AM

In the page, try something along the lines of:

Code:

set oconn=server.CreateObject("adodb.connection")
set recs=server.CreateObject("adodb.recordset")
oconn.ConnectionString="DSN=stp;"
oconn.open
recs.Open "select blah blah etc from blah", oconn

Notice the usage of a DSN which will be defined on the server. You can create a DSN (otherwise known as an ODBC link among other things) by adding a Data Source (accessable from Control Panel/Administrative Tools in Windows)

The DSN would deal with where the file is located etc, and acts as a window into the database. After it's set up correctly, you can forget the database, and just access the DSN.

One thing to note is that the script will obviously have to actually run server-side.

05-20-2005, 04:35 AM	#2 (permalink)
zen_tom Guest	In the page, try something along the lines of: Code: set oconn=server.CreateObject("adodb.connection") set recs=server.CreateObject("adodb.recordset") oconn.ConnectionString="DSN=stp;" oconn.open recs.Open "select blah blah etc from blah", oconn Notice the usage of a DSN which will be defined on the server. You can create a DSN (otherwise known as an ODBC link among other things) by adding a Data Source (accessable from Control Panel/Administrative Tools in Windows) The DSN would deal with where the file is located etc, and acts as a window into the database. After it's set up correctly, you can forget the database, and just access the DSN. One thing to note is that the script will obviously have to actually run server-side.