Check the MS SQL database connection string

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Check the MS SQL database connection string
Document ID : 000-000966 Created: 3/15/2005 Last changed on: 3/15/2005

The MS SQL database connection string contains the information required to connect to the database server.

OLE DB Connection string (all one line):
"Provider=SQLOLEDB.1;Password=mydbpassword; Persist Security Info=True; User ID=dbuser; Initial Catalog=NetKeeper;Data Source=name_or_IP_of_dbserver"

or

"Provider=SQLOLEDB; Data Source=name_or_IP_of_dbserver; Initial Catalog=netkeeper; User ID=dbuser; Password=mydbpassword; Network Library=dbnmpntw"

ODBC Connection string (all one line):
"Provider=MSDASQL; DSN=nkup"

Descriptions:
provider - defines what to connect to access the data
password - the password for the database user account
user ID - the name of the database user account (user name or login)
initial catalog - the database name
data source - IP or name of the database server
DSN - ODBC data source
network library - optional connection method
TCP/IP : dbmssocn
Named Pipes : dbnmpntw
Multiprotocol (RPC) : dbmsrpcn

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.