SQL SERVER connection string for classic Asp

Asked

Viewed 5,609 times

0

How do I create a connection string for CLASSIC ASP to connect to the Microsoft SQL Server database

sql-server asp connection

1 answer

7


Taking source, whenever I needed I used these strings Connections, depending on your SQL SERVER and the providers installed on the application machine, Voce can make use of any Native Client to connect to a version of SQL SERVER that is superior to or equal to the version of your Native client.

Native Client: The Native client is a specific library to optimize the connection to SQL SERVER and allows working with persistence and data capture with all the Features that SQL SERVER (version of Native) allows (Ex: New data types and queries etc...).

Source: http://www.connectionstrings.com/sql-server/

Set oBanco = Server.CreateObject("ADODB.Connection")

SQL SERVER 2012:

oBanco.Open "Provider=SQLNCLI11;Server=IPSERVIDOR;Database=BASEDEDADOS;Uid=USUARIO;Pwd=SENHA;"

SQL SERVER 2008:

oBanco.Open "Provider=SQLNCLI10;Server=IPSERVIDOR;Database=BASEDEDADOS;Uid=USUARIO;Pwd=SENHA;"

SQL SERVER 2005

oBanco.Open "Provider=SQLNCLI;Server=IPSERVIDOR;Database=BASEDEDADOS;Uid=USUARIO;Pwd=SENHA;"

SQL SERVER (All with non-native access)

oBanco.Open "Provider=sqloledb;Data Source=IPSERVIDOR;Initial Catalog=BASEDEDADOS;User ID=USUARIO;Password=SENHA;"

  • Perfect Roger. We used the SQL server 2012 connection string using the Provider=SQLNCLI11; and it worked perfectly with Sql server 2017. Thank you very much!

Browser other questions tagged sql-server asp connection

You are not signed in. Login or sign up in order to post.