[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

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
0
rick_danger
Asked:
rick_danger
  • 3
  • 2
1 Solution
 
Dave BaldwinFixer 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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now