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
rick_dangerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
'sqloledb.1' may not be available.  See what driver they support on the new server.
0
 
rick_dangerAuthor Commented:
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.
0
 
rick_dangerAuthor Commented:
Actually, just remove the ".1" and it worked!

Thanks Dave
0
 
rick_dangerAuthor Commented:
Easy answer, but a quick response.

Much appreciated!
0
 
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.