> IdleBrain wrote:
> > It is kind of hard for someone to know what the problem is unless you
> > post some of your code. Specially..the code you use to connect your APP
> > to the Database.
>
>
>
>
>
> here is what i am trying for the connection string. It is supposed to
> run when the main form loads.
>
>
> Dim conn As New SqlConnection()
> conn.ConnectionString = "Data
> Source=MYSERVER\SQLEXPRESS;AttachDbFilename=|DataDirectory|\testdatabase.mdf;Integrated
> Security=True;User Instance=false"
>
> I get this error when I debug the application:
>
> Invalid value for key 'attachdbfilename'

> IdleBrain wrote:
> > It is kind of hard for someone to know what the problem is unless you
> > post some of your code. Specially..the code you use to connect your APP
> > to the Database.
>
>
>
>
>
> here is what i am trying for the connection string. It is supposed to
> run when the main form loads.
>
>
> Dim conn As New SqlConnection()
> conn.ConnectionString = "Data
> Source=MYSERVER\SQLEXPRESS;AttachDbFilename=|DataDirectory|\testdatabase.mdf;Integrated
> Security=True;User Instance=false"
>
> I get this error when I debug the application:
>
> Invalid value for key 'attachdbfilename'

> Why do you automatically expect answers from this forum? Many of us
> spend a great deal of time trying to help people that have genuinely
> exhausted all avenues of research  _BEFORE_ asking questions here.
>
> I suggest that you first search the web for information to do something
> as basic as this. Don't just come here asking questions and expecting
> answers like an arrogant c**t.
>
> Steve Ray Irwin
>
> j***@adnetss.com wrote:
>> IdleBrain wrote:
>>> It is kind of hard for someone to know what the problem is unless you
>>> post some of your code. Specially..the code you use to connect your APP
>>> to the Database.
>>
>>
>>
>>
>>
>> here is what i am trying for the connection string. It is supposed to
>> run when the main form loads.
>>
>>
>> Dim conn As New SqlConnection()
>> conn.ConnectionString = "Data
>> Source=MYSERVER\SQLEXPRESS;AttachDbFilename=|DataDirectory|\testdatabase.mdf;Integrated
>> Security=True;User Instance=false"
>>
>> I get this error when I debug the application:
>>
>> Invalid value for key 'attachdbfilename'

> Why do you automatically expect answers from this forum? Many of us
> spend a great deal of time trying to help people that have genuinely
> exhausted all avenues of research  _BEFORE_ asking questions here.
>
> I suggest that you first search the web for information to do something
> as basic as this. Don't just come here asking questions and expecting
> answers like an arrogant c**t.
>
> Steve Ray Irwin
>
>
> j***@adnetss.com wrote:
> > IdleBrain wrote:
> > > It is kind of hard for someone to know what the problem is unless you
> > > post some of your code. Specially..the code you use to connect your APP
> > > to the Database.
> >
> >
> >
> >
> >
> > here is what i am trying for the connection string. It is supposed to
> > run when the main form loads.
> >
> >
> > Dim conn As New SqlConnection()
> > conn.ConnectionString = "Data
> > Source=MYSERVER\SQLEXPRESS;AttachDbFilename=|DataDirectory|\testdatabase.mdf;Integrated
> > Security=True;User Instance=false"
> >
> > I get this error when I debug the application:
> >
> > Invalid value for key 'attachdbfilename'

> That isn't helpful.  If you believe the information is available online
> somewhere then provide the links to the online information and describe
> how you found it.  A person reading that information will learn their
> answer as well as how to better search for information.  You will be
> teaching someone, which is helpful, rather than discouraging them.
>
> Looky there! I just helped you, by politely telling you, how you can be
> a better mentor...
>
> Master Programmer wrote:
>> Why do you automatically expect answers from this forum? Many of us
>> spend a great deal of time trying to help people that have genuinely
>> exhausted all avenues of research  _BEFORE_ asking questions here.
>>
>> I suggest that you first search the web for information to do something
>> as basic as this. Don't just come here asking questions and expecting
>> answers like an arrogant c**t.
>>
>> Steve Ray Irwin
>>
>>
>> j***@adnetss.com wrote:
>>> IdleBrain wrote:
>>> > It is kind of hard for someone to know what the problem is unless you
>>> > post some of your code. Specially..the code you use to connect your APP
>>> > to the Database.
>>>
>>>
>>>
>>>
>>>
>>> here is what i am trying for the connection string. It is supposed to
>>> run when the main form loads.
>>>
>>>
>>> Dim conn As New SqlConnection()
>>> conn.ConnectionString = "Data
>>> Source=MYSERVER\SQLEXPRESS;AttachDbFilename=|DataDirectory|\testdatabase.mdf;Integrated
>>> Security=True;User Instance=false"
>>>
>>> I get this error when I debug the application:
>>>
>>> Invalid value for key 'attachdbfilename'

> I'm pretty new to both sql 2005 and VB but please bear with me. I have
> installed SQL 2005 express on a Windows 2003 Standard server. I have
> also installed VB 2005 Express edition on the server. SQL seems to be
> running fine (I can create databases, tables, modify them, etc.) I have
>
> created a very basic app in VB express that just lets me view and
> modify the current tables. It works just fine on the server. However, I
>
> am trying to make this app connect from an XP pro machine on the
> network and I really don't know where to start. I tried running the app
>
> that works locally over the network and I get "error 26" can't connect
> to database server. I've read about using strings and ADO but I'm not
> familiar enough with VB to make it work. Also, both machines are on the
>
> same network and I can connect to the server from the XP pro machine
> with SQL server management studio express.
>
> Any help is greatly appreciated.
> Thanks,
> Josh

> Josh,
>
> In case you haven't found the solution.   You need to use the surface
> area configruation utility.
>
> I did a google search for:
>
> how to configure sql server express for remote connections
>
> and found the msdn article:
>
> http://support.microsoft.com/kb/914277
>
> I went through this during my first installation about 6 months ago,
> there are just a few steps to follow, which are clearly stated in this
> article.
>
>
> j***@adnetss.com wrote:
> > I'm pretty new to both sql 2005 and VB but please bear with me. I have
> > installed SQL 2005 express on a Windows 2003 Standard server. I have
> > also installed VB 2005 Express edition on the server. SQL seems to be
> > running fine (I can create databases, tables, modify them, etc.) I have
> >
> > created a very basic app in VB express that just lets me view and
> > modify the current tables. It works just fine on the server. However, I
> >
> > am trying to make this app connect from an XP pro machine on the
> > network and I really don't know where to start. I tried running the app
> >
> > that works locally over the network and I get "error 26" can't connect
> > to database server. I've read about using strings and ADO but I'm not
> > familiar enough with VB to make it work. Also, both machines are on the
> >
> > same network and I can connect to the server from the XP pro machine
> > with SQL server management studio express.
> >
> > Any help is greatly appreciated.
> > Thanks,
> > Josh

> Sorry, I tried to reply earlier but I think my connection timed out or
> something. Thanks again for the help though.
>
> I went through the surface area configuration tool and enabled TCP/IP
> and named pipes. I also started the browser service and there isn't any
> kind of firewall running. I restarted the SQL server service after this
> of course. Later on I was toying around with an ASP page that was able
> to connect to the server and perform a query. So, now it seems that
> remote connections are enabled and working and my problem lies on the
> VB side of things.
>
> Also, I changed the connection string to
> "server=MYSERVER\SQLEXPRESS;initial catalog=testdatabase;integrated
> security=True"  as Robinson suggested.
>
> I then use this code in hopes of performing a query:
>
> Dim testquery As New SqlCommand
>         testquery.CommandType = CommandType.Text
>         testquery.CommandText = "SELECT * FROM table1"
>         testquery.Connection = conn
>
>
> I don't get the error when I debug it anymore, but the query doesn't
> seem to be working correctly.
>
> Thanks,
> Josh
>
>
>
> FishingScout wrote:
> > Josh,
> >
> > In case you haven't found the solution.   You need to use the surface
> > area configruation utility.
> >
> > I did a google search for:
> >
> > how to configure sql server express for remote connections
> >
> > and found the msdn article:
> >
> > http://support.microsoft.com/kb/914277
> >
> > I went through this during my first installation about 6 months ago,
> > there are just a few steps to follow, which are clearly stated in this
> > article.
> >
> >
> > j***@adnetss.com wrote:
> > > I'm pretty new to both sql 2005 and VB but please bear with me. I have
> > > installed SQL 2005 express on a Windows 2003 Standard server. I have
> > > also installed VB 2005 Express edition on the server. SQL seems to be
> > > running fine (I can create databases, tables, modify them, etc.) I have
> > >
> > > created a very basic app in VB express that just lets me view and
> > > modify the current tables. It works just fine on the server. However, I
> > >
> > > am trying to make this app connect from an XP pro machine on the
> > > network and I really don't know where to start. I tried running the app
> > >
> > > that works locally over the network and I get "error 26" can't connect
> > > to database server. I've read about using strings and ADO but I'm not
> > > familiar enough with VB to make it work. Also, both machines are on the
> > >
> > > same network and I can connect to the server from the XP pro machine
> > > with SQL server management studio express.
> > >
> > > Any help is greatly appreciated.
> > > Thanks,
> > > Josh

> Try something like this:
>
>             Dim dbCommand As New SqlCommand("select * from table1")
>             dbCommand.Connection = conn
>             dbCommand.CommandType = CommandType.Text
>
>             Dim MyDataReader As SqlDataReader = dbCommand.ExecuteReader
>
>             Dim FirstColValues As ArrayList = New ArrayList
>
>             Do While MyDataReader.Read()
>
>                 Dim FirstColValue As Integer = MyDataReader.GetValue(0)
>                 FirstColValues.Add(FirstColValue)
>
>             Loop
>
>             MyDataReader.Close()
>
>
> j***@adnetss.com wrote:
> > Sorry, I tried to reply earlier but I think my connection timed out or
> > something. Thanks again for the help though.
> >
> > I went through the surface area configuration tool and enabled TCP/IP
> > and named pipes. I also started the browser service and there isn't any
> > kind of firewall running. I restarted the SQL server service after this
> > of course. Later on I was toying around with an ASP page that was able
> > to connect to the server and perform a query. So, now it seems that
> > remote connections are enabled and working and my problem lies on the
> > VB side of things.
> >
> > Also, I changed the connection string to
> > "server=MYSERVER\SQLEXPRESS;initial catalog=testdatabase;integrated
> > security=True"  as Robinson suggested.
> >
> > I then use this code in hopes of performing a query:
> >
> > Dim testquery As New SqlCommand
> >         testquery.CommandType = CommandType.Text
> >         testquery.CommandText = "SELECT * FROM table1"
> >         testquery.Connection = conn
> >
> >
> > I don't get the error when I debug it anymore, but the query doesn't
> > seem to be working correctly.
> >
> > Thanks,
> > Josh
> >
> >
> >
> > FishingScout wrote:
> > > Josh,
> > >
> > > In case you haven't found the solution.   You need to use the surface
> > > area configruation utility.
> > >
> > > I did a google search for:
> > >
> > > how to configure sql server express for remote connections
> > >
> > > and found the msdn article:
> > >
> > > http://support.microsoft.com/kb/914277
> > >
> > > I went through this during my first installation about 6 months ago,
> > > there are just a few steps to follow, which are clearly stated in this
> > > article.
> > >
> > >
> > > j***@adnetss.com wrote:
> > > > I'm pretty new to both sql 2005 and VB but please bear with me. I have
> > > > installed SQL 2005 express on a Windows 2003 Standard server. I have
> > > > also installed VB 2005 Express edition on the server. SQL seems to be
> > > > running fine (I can create databases, tables, modify them, etc.) I have
> > > >
> > > > created a very basic app in VB express that just lets me view and
> > > > modify the current tables. It works just fine on the server. However, I
> > > >
> > > > am trying to make this app connect from an XP pro machine on the
> > > > network and I really don't know where to start. I tried running the app
> > > >
> > > > that works locally over the network and I get "error 26" can't connect
> > > > to database server. I've read about using strings and ADO but I'm not
> > > > familiar enough with VB to make it work. Also, both machines are on the
> > > >
> > > > same network and I can connect to the server from the XP pro machine
> > > > with SQL server management studio express.
> > > >
> > > > Any help is greatly appreciated.
> > > > Thanks,
> > > > Josh