Link to home
Create AccountLog in
Avatar of Rick Danger
Rick DangerFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of 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.
Actually, just remove the ".1" and it worked!

Thanks Dave
Easy answer, but a quick response.

Much appreciated!
You're welcome, glad to help.