Can someone see the error here?

[gmagerr]

hi guys, i'm in the middle of doing a program from The ASP Bible (chapter 12) Here's the code i'm having trouble with

Function MakeConnection()
Dim objConn

Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.Open "DSN=NWTraders"

Set MakeConnection = objConn
End Function


Here's the error i'm getting


ASP Code
Error Number -2146827286
Source code that caused the error Function MakeConnection()
Category Microsoft VBScript compilation
Error Occurred /Magerr Media/ASP Practice/~MagerrMediaSite/Category Viewer/EditProduct.asp
Line Number 212
Column Number 0
Description Syntax error
Extended Description


Anyone have any ideas? thanks in advance

 

[v0520]

Look at line 212 first.
Do you have ado installed on the web server you are using?
Do you have a system dsn called NWTraders?

It worked ok on my machine.
Make sure this is server-side vbscript (runat=server).
Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov