Getting data from SQL

[snook]

Hi,

I am trying to build a workbook with data from SQL. I need to prompt
the user for the SQL server, login and pwd (its in mixed mode)
everytime the workbook is opened.

I am new to this and I have explored the following options:

Building a login form and ADO recordsets

Using SQL.Request()

Our users are on various versions of Excel (all 2000+) so I want to
make sure it works for everyone.

thanks

 

[Guest]

Try this:

1. Create your ADO connection object.
2. Set its Properties.Prompt.Value = 1 ' adPromptAlways
3. Open your Connection object

An appropriate form will open up asking for the relevant/missing information.

Sub aa()
Set adoc = CreateObject("ADODB.Connection")
adoc.Properties("Prompt").Value = 1
adoc.Open
End Sub