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

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

Much appreciated!
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
All Courses

From novice to tech pro — start learning today.