Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Classic ASP server 2012 SQL + Server 2012 connection string

Posted on 2013-12-26
5
841 Views
Last Modified: 2014-01-12
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
Comment
Question by:splanton
  • 2
  • 2
5 Comments
 
LVL 33

Assisted Solution

by:Big Monty
Big Monty earned 200 total points
ID: 39740499
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
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39740729
I use

Provider=SQLOLEDB; datasource=localhost; Database=db_name; Uid=user_name; Pwd=pass_word
0
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39740732
This will help too http://www.connectionstrings.com/sql-server/

Did you turn on classic asp?
0
 
LVL 2

Accepted Solution

by:
splanton earned 0 total points
ID: 39761848
Downloaded and installed the new SQLNCLI11 driver and used the following in my string:
'Provider=SQLNCLI11'
0
 
LVL 2

Author Closing Comment

by:splanton
ID: 39774442
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question