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