Classic ASP adodb connection error on Vista

0
votes

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?

2
asp-classicado
Is this line part of asp page? If so, this is not how it should be. – shahkalpesh
well, the actual line is: <% Dim cnn As ADODB.Connection %> – Csharp
enable classic asp errors to get a more details geekswithblogs.net/lance/archive/2007/02/14/106330.aspx – Shay Erlichmen

2 Answers

1
votes

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

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

0
votes

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.