ASP Server.CreateObject Error

[Guest_imported]

I am having a real problem instantiating a Database Connection Object.
Even if I comment out all my code and just leave the following I am getting an error:

Code:

Dim cnnDB
Set cnnDB = Server.CreateObject(

 

[wduty]

The above code as it appears is syntactically incomplete.

try

[red]dim cnnDB
set cnnDB = server.createObject("ADODB.Connection&quot
cnnDB.open "theDatasourceName"[/red]

or

[red]dim cnnDB
set cnnDB = server.createObject("ADODB.Connection&quot
cnnDB.open "DSN=theDatasourceName;uid=userid;pwd=password"[/red]

Hope this helps. [sig]<p>--Will Duty<br><a href=mailto:wduty@radicalfringe.com>wduty@radicalfringe.com</a><br><a href= > </a><br> [/sig]