CODEWITHSUNDEEP
asp-classicado
Csharp
Csharp

Reputation: 2982

Classic ASP adodb connection error on Vista

When my classic asp page gets to this line of code

Dim cnn As ADODB.Connection

it throws an error http 500. I suppose ado is not correctly installed

Any ideas?

Upvotes: 0

Views: 1412

Answers (2)

Bryan Waters
Bryan Waters

Reputation: 636

VBScript doesn't let you specify the type - everything is a variant so your code should read

Set cnn = Server.CreateObject("ADODB.Connection")

Upvotes: 1

AngryHacker
AngryHacker

Reputation: 61616

I doubt that ADO is not installed correctly. Try connecting via the Universal Data Link. You can follow the directions here. http://www.vbrad.com/article.aspx?id=81

You should be able to see whether you can connect or not. If not, you'll get a much more detailed message than you got from ASP.

Upvotes: 0

Related Questions