Avatar of Rick Danger
Rick Danger
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Classic ASP - SQL Server connection problem

My hosting company has migrated my site to a new server. Since then the attached code does not work.

I get this error:
Microsoft OLE DB Provider for SQL Server error '80040e21'

The requested properties cannot be supported.

/database/login.asp, line 25

It is where it tried to open the connection that it happens.

So I have attached 2 files - one with the connection string, and the other with some sample code. The code is generated by Dreamweaver.

Any help will be much appreciated.
login_sample.txt
connWebSample.txt
ASPMicrosoft SQL Server

Avatar of undefined
Last Comment
Dave Baldwin

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dave Baldwin

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rick Danger

ASKER
Dave
Thanks for the quick response!

I'll check with them, although response may be slow on a Sunday. Any ideas what alternatives I could use? Maybe newer version as this is quite old code now.
Rick Danger

ASKER
Actually, just remove the ".1" and it worked!

Thanks Dave
Rick Danger

ASKER
Easy answer, but a quick response.

Much appreciated!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Dave Baldwin

You're welcome, glad to help.