The server and workstations are within the same building. What is the normal/best method of maintaining the server databases? Is the installation of Query Analyzer on a workstation fairly straight forward?
I am very new to SQL. We have a SBS 2003 with SQL installed. I currently use Remote Desktop from my workstation to query and maintain the server databases. Can I install the Client Tools (Query Analyzer and Enterprise Manager) onto my workstation and attach to the server? Preferably without...
Thanks for your quick response.
I am very new to VB and SQL programming. At this point I have only tried to establish the connection through the solution explorer. I can see the server but cannot make a data connection.
I have been able to create Crystal Reports with the server data using VB...
I am using VS 2005 and cannot get a connection to our SQL databases in 'Solution Explorer'. I can see the server name listed but I cannot connect to any database. I have set all of the permissions I can find in Enterprise Manager.
You might also want to take a look at www.LearnVisualStudio.Net, it has several good videos on a variety of subjects for both VB and C#. And it is pretty reasonable in price.
Nevermind, I may have figured it out. For anyone in the future with the same problem. I first followed exactly the steps in the "Microsoft SQL Server: Programming FAQ" "using NT Authentication to login into SQL". I am not sure if that helped as I am fairly confident I had the proper...
I have a VB 2005 project with a DataGridView linked to a SQL2000 Server (SBS2003). When I debug the application without saving the project, it runs perfectly. After I save the project, I get the following error.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission...
I have a VB 2005 project with a DataGridView linked to a SQL2000 Server (SBS2003). When I debug the application without saving the project, it runs perfectly. After I save the project, I get the following error.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission...
We receive electronic invoices from several customers into a specific directory. The file structure is consistent, but the file naming conventions are not. Inlcuded within the file, is the customer number. We currently have a clipper program listing the directory files to the screen and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.