ADODB VB Code: con.Properties("Prompt") -Anything similar in ADO.N

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

Can some please tell me if there is a way to invoke the SQL user challenge
dialog from ADO.Net ? I mean what would be the equivalent (if any) code in
ASP.Net/C# or VB.Net for the following VB code using ADODB:

oConnection.Properties("Prompt") = adPromptAlways
oConnection.Open "Driver={SQL Server};Server=" & _
m_Server & ";Database=" & m_DB & ";"
Set DBConnection = oConnection

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C# - ADODB - Failure to connect on deployment 4
data is not getting populated 2
Error when opening Access DB connected to MSDE back-end 3
Building a single EXE file in VB 2005? 7
DAO/VB6 Outperforms ADO.NET in VB 2005 7
VB Express/SQL Server/ADO.net Project Design Question? 3
Problems and confusion with ClickOnce, VB, and SQL Server jobs 2
Create a connection object (sql/oledb/odbc) based on connection method/string. 2

Back
Top