Solved

Classic ASP server 2012 SQL + Server 2012 connection string

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dreamweaver server behavior gone 6 138
Update table value with join syntax 2 69
Error viewing ASP page 12 164
If condition on Html with Asp 11 17
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

777 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