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.
  • 2373

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

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.