Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-31 : 08:16:03
|
| Charles writes "I have installed msde and I have an icon for sql server in my task tray with a green arrow. I have programmed vb6 for about a year and now I am using vb.net (visual studio 2003). I don't know how to get the wizard in the vs.net ide to make a connection string to the sql server so I can connect it to a database.I know I have sql installed at Program Files\MSSql. I just want to know what to do now." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-03 : 23:26:38
|
| In the VS.Net IDE there should be a Database control panel (or whatever they call them) that lets you browse known databases. VS should be able to find your MSDE server, and I think MSDE installs the same sample databases that come with SQL Server (Northwind, etc.)--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-01-04 : 00:14:08
|
| I'd rather not depend on one of those GUI tools to generate the connection code, they generate way too much code!!! It's really quite simple, a standard connection string will look something like this:Dim strConnectionString as String = "Server=localhost;Integrated Security=SSPI;Database=Northwind"alternatively try (using SQL Server authentication):Dim strConnectionString as String = "Server=localhost;User ID=yourUserID;Password=yourPassword;Database=Northwind"Now just how difficult is that?OS |
|
|
|
|
|
|
how to make sql work with vb.net