Home All Groups Group Topic Archive Search About

Help connecting to northwind database

Author
28 May 2006 6:07 PM
machine-man
I am try this example on vb express 2005:
http://msdn2.microsoft.com/en-US/library/system.windows.forms.datagridviewcomboboxcolumn.aspx
but it keeps giving me an error about the data source to northwind database. I installed the SQL2000SampleDb.msi file, then ran this command at the prompt:
SQLCMD -E -S computerName\SqlExpress -i instnwnd.sql
with my computer name. Can anyone help a noob out here. Many thanks



*** Posted via a free Usenet account from http://www.teranews.com ***

Author
28 May 2006 9:31 PM
Ken Tucker [MVP]
Hi,

       The connection string was not pointed to the sqlexpress.  Try this
instead.

Private connectionString As String = _
            "Integrated Security=SSPI;Persist Security Info=False;" _
            & "Initial Catalog=Northwind;Data Source=.\sqlexpress"

Ken
--------------
Show quoteHide quote
"machine-man" wrote:

> I am try this example on vb express 2005:
> http://msdn2.microsoft.com/en-US/library/system.windows.forms.datagridviewcomboboxcolumn.aspx
>  but it keeps giving me an error about the data source to northwind database. I installed the SQL2000SampleDb.msi file, then ran this command at the prompt:
> SQLCMD -E -S computerName\SqlExpress -i instnwnd.sql
> with my computer name. Can anyone help a noob out here. Many thanks
>
>
>
> *** Posted via a free Usenet account from http://www.teranews.com ***
>