Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Server not opened error and the RDC

Status
Not open for further replies.

joero4

Programmer
Dec 21, 2001
8
US
I have developed a small Visual Basic application and integrated a report using the RDC component for Visual Basic. I have install the application on another computer and wish to run the app by any user using the computer.
When the user has Admin rights and I directly connect to a MS SQL server I have no problems, yet regular users get the Server has not yet been opened error. When I use ODBC to connect to the SQL Server everyone gets the error. Please help.
 
Are you using .LogonServer or .SetLogonInfo to connect to SQL Server?

Or are you passing an ADO recordset to the report?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top