Home >Backend Development >PHP Tutorial >Access sql server without dsn_PHP tutorial
Access sql server without dsn_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:01:19893browse
Just add the server and database driver to the connection string
Example:
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "driver= {SQL Server};"server=yourserver;uid=sa;pwd=pwd;database=pubs"
conn.open
Set cmd= Server.CreateObject("ADODB.Command")
Set cmd. ActiveConnection = conn
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Correctly configure and use SQL mail_PHP tutorialNext article：Correctly configure and use SQL mail_PHP tutorial