Solved

Classic ASP server 2012 SQL + Server 2012 connection string

Posted on 2013-12-26
5
808 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 32

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Table header not displaying on Firefox and Chrome 7 139
UTC (timezone) without using an API 16 41
Time/Date Query 11 38
How to get statistic's from a competitors website?! 1 87
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

861 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now