SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:26 PM
| ||||
| ||||
 Re: .NET / SQL Server 2000 Problem "J Pruitt" <jpruitt@verizon.net> wrote in message news:<W0EZa.7472$EJ1.2103@nwrddc03.gnilink.net>... > I have MS Visual Basic (.Net ) and SQL Server 2000 installed on XP > Professional (No remote database, strictly local machine). Can Anyone tell > me what I need to do to get VB .Net to recognize the SQL Server. > > I believe I need to get Enterprise Manager to establish a user somehow. But > that's not working !!! > > If not, a good source of installation info SQL Server !!! > > Thanks You need to set up your machine in the SQL Server Group in SQL Server Enterprise Manager. In your vb.net application you can use Microsoft's connection wizards (to quickly determine a connection - in this case ADO/ODBC).      |
|
02-28-2008, 05:26 PM
| |||
| |||
| Re: .NET / SQL Server 2000 Problem Roy I think I have that setup. Under Enterprise Manager I see LOCAL (Windows NT). I also see the following folders on the right side: Database, Data Transformation, Replication, etc.. Do I need to add users, permissions or anything else to VB .NET to use SQL Server. I have an example program from the Microsoft Press books on SQL Server 2000 with VB .NET. This app is trying to communicate with SQL server and it fails. Hopefully this makes more sense. Thanks "Roy" <roycox@hotmail.com> wrote in message news:207d6e07.0308110514.1088f820@posting.google.c om... > "J Pruitt" <jpruitt@verizon.net> wrote in message news:<W0EZa.7472$EJ1.2103@nwrddc03.gnilink.net>... > > I have MS Visual Basic (.Net ) and SQL Server 2000 installed on XP > > Professional (No remote database, strictly local machine). Can Anyone tell > > me what I need to do to get VB .Net to recognize the SQL Server. > > > > I believe I need to get Enterprise Manager to establish a user somehow. But > > that's not working !!! > > > > If not, a good source of installation info SQL Server !!! > > > > Thanks > > You need to set up your machine in the SQL Server Group in SQL Server > Enterprise Manager. In your vb.net application you can use > Microsoft's connection wizards (to quickly determine a connection - in > this case ADO/ODBC). |
|
02-28-2008, 05:27 PM
| ||||
| ||||
| Re: .NET / SQL Server 2000 Problem On Mon, 11 Aug 2003 19:49:19 GMT, "J Pruitt" <jpruitt@verizon.net> wrote: >Roy > >I think I have that setup. Under Enterprise Manager I see LOCAL (Windows >NT). I also see the following folders on the right side: Database, Data >Transformation, Replication, etc.. Do I need to add users, permissions or >anything else to VB .NET to use SQL Server. I have an example program from >the Microsoft Press books on SQL Server 2000 with VB .NET. This app is >trying to communicate with SQL server and it fails. Hopefully this makes >more sense. > >Thanks What is in your connect string? You would need to specify db, user and password. Are the user and password valid? What rights does the user have. Does it work using the sa account? in which case it's the rights of the user id. Indeed per you above, if you're not connecting using the sa account you will definitely have to grant some rights to the userid in question. Can you confirm these things, and also that failure occurs when you try to open the connection, and not at a later stage. (If the connection is opened but say a SELECT fails then it's probably user rights. |
Linear Mode
