Can't get connection String

I need to create some .asp pages to publish data from our manufacturing lines...but I can't figure out how to establish the connection string and print the data. I've been stuck on this all day and about to start pulling my hair out!!!

As an example, can someone create the most basic code necessary to build a web page that does the following:

a) connect to a SQL version of the Northwind db (assume I have a functioning ODBC connection called 'Northwind_ODBC' on a server called 'ProductionServer')

b) Loop through the records in the [Shippers] table and paste the values in a HTML table (using SELECT * FROM SHIPPERS)

I know it sounds simple but I'm looking through some books and can't find a solution that works on my server.

NOTE: I'm running Server 2003 (with IIS), SQL Server 2000, and I have proven ASP does work on this machine...unfortunately, just not with the code I'm trying to build!!!

Thanks a lot for the help

Alex

http://www.1planhost.com/support/s_databaseconn.asp has a bunch of different ways you can make a connection string to an sql server 2k database.
http://www.shocknet.org.uk/defpage.asp?pageID=16 tells how to make a recordset and display the contents (which is how to show the records in your table)
Check these resources out. If you still have trouble, post code and tell what error you're getting.
HTH

What neck of the woods are we in? Connection strings and ODBC are two completely different things. Don't assume you have an ODBC, open the server, go to admin tools, data connectors, and go to system, see if you have the odbc there. If not, create it.

if we're talking connection strings, this is my favorite method. http://forums.devshed.com/showthrea...&threadid=75505