• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1086
  • Last Modified:

Classic ASP server 2012 SQL + Server 2012 connection string

Hi,
Just upgraded my server to 2012 (fresh install) and installed an upgraded version of SQL Server 2012.

I have a classic ASP application. Does anyone know what is the accepted connection string to get my APP 'talking' to the database (plus and driver downloads required)?

I can find plenty of stuff regarding .NET but not good old ADO.

Thanks in advance
0
splanton
Asked:
splanton
  • 2
  • 2
2 Solutions
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
this is what I use for my sql server 2012 web apps:

const connectionString = "Provider=SQLNCLI10;Server=serverName;Database=dbName;Uid=userName;Pwd=password;"

Open in new window


*edit - took out my server name :)
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
I use

Provider=SQLOLEDB; datasource=localhost; Database=db_name; Uid=user_name; Pwd=pass_word
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
This will help too http://www.connectionstrings.com/sql-server/

Did you turn on classic asp?
0
 
splantonAuthor Commented:
Downloaded and installed the new SQLNCLI11 driver and used the following in my string:
'Provider=SQLNCLI11'
0
 
splantonAuthor Commented:
I was looking for confirmation of the requirements for getting a web application to 'talk' to a new SQL Server 2012 instance.

Big Monty gave me a clue and I used that information to track down the latest supported driver, install it from the Microsoft web site and construct a new, working connection string.

Up until this point I was not aware of the supported drivers for a SQL Server 2012 instance that can be used by classic ASP.
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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