How to Prompt for Username Password in OLE DB
In this article I am going to explain about how to create connection string with prompt for username and password.
Introduction
Here I am explaining how to create connection string with prompt for username and password for OLE DB Provider.
Prompt for Username Password
To create connection string with prompt for username and password in SQL server native client 10.0 OLE DB provider we need to put provider, your server address and your database name.
Syntax
|
oConn.Properties("Prompt") = adPromptAlwaysoConn.Open "Provider=SQLNCLI10;Server=urServerAddress;DataBase=urDataBase;
|
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here