Deploy applcation VBNET and Sql

TheMSsForum.com: The Microsoft Software Forum

Hello friends
i have a question. Is about the deployment an application net over a pc.
I installed the netframework 1.1 and i copied the applicattion . The
problem es when the application tried to connect Sql. Dont do it

Thanks

--
Message posted via http://www.dotnetmonster.com
Top

Re: Deploy applcation VBNET and Sql by William

William
Wed Mar 09 13:45:26 CST 2005

What kind of database? How was it installed? How are you trying to connect?
(Let's see some code).
What language, version, platform.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Carlos G via DotNetMonster.com" <forum@DotNetMonster.com> wrote in message
news:3a1489cb83224c6aabde622bcdf9860a@DotNetMonster.com...
> Hello friends
> i have a question. Is about the deployment an application net over a pc.
> I installed the netframework 1.1 and i copied the applicattion . The
> problem es when the application tried to connect Sql. Dont do it
>
> Thanks
>
> --
> Message posted via http://www.dotnetmonster.com


Top

Re: Deploy applcation VBNET and Sql by Carlos

Carlos
Wed Mar 09 13:55:17 CST 2005

Sql Database (Northwind).
the code is

Dim cn As New SqlConnection("data source=(local);Initial
Catalog=Northwind;integrated Security=True;")
Try
cn.Open()
Catch ex As Exception
MessageBox.Show(ex.Source)
Return
End Try
MessageBox.Show("conexion abierta")

really the application is ther , but i tried to connect this example,

thanks

--
Message posted via http://www.dotnetmonster.com
Top

Re: Deploy applcation VBNET and Sql by Carlos

Carlos
Wed Mar 09 13:56:17 CST 2005

the pplataform is win2000
netframework 1.1

--
Message posted via http://www.dotnetmonster.com
Top

Re: Deploy applcation VBNET and Sql by William

William
Wed Mar 09 14:01:46 CST 2005

Ok, did you install SQL Server on the local system? Did you install the
database? Is the server started? Did you grant rights to the database to the
login account you created on the server? Is the user a valid user in the
database?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Carlos G via DotNetMonster.com" <forum@DotNetMonster.com> wrote in message
news:79babd6f4d9c46ae836c54b8e36ad043@DotNetMonster.com...
> Sql Database (Northwind).
> the code is
>
> Dim cn As New SqlConnection("data source=(local);Initial
> Catalog=Northwind;integrated Security=True;")
> Try
> cn.Open()
> Catch ex As Exception
> MessageBox.Show(ex.Source)
> Return
> End Try
> MessageBox.Show("conexion abierta")
>
> really the application is ther , but i tried to connect this example,
>
> thanks
>
> --
> Message posted via http://www.dotnetmonster.com


Top

Re: Deploy applcation VBNET and Sql by Carlos

Carlos
Wed Mar 09 14:35:41 CST 2005

yes...
is need installed MSDE??

--
Message posted via http://www.dotnetmonster.com
Top

Re: Deploy applcation VBNET and Sql by Carlos

Carlos
Wed Mar 09 14:39:02 CST 2005

i chanched the conecctionString to

"data source=(local);Initial Catalog=Northwind;User ID=sa;pwd=;"

but not is possible tha connection yet

--
Message posted via http://www.dotnetmonster.com
Top

Re: Deploy applcation VBNET and Sql by William

William
Wed Mar 09 15:27:37 CST 2005

Ah, I think you need to read a bit about SQL Server and MSDE. There are
plenty of places to get this information. Yes, you need to install MSDE on
the target system and install your database on that engine.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Carlos G via DotNetMonster.com" <forum@DotNetMonster.com> wrote in message
news:e4f98c5aff5d4448b7914f12706f4e80@DotNetMonster.com...
>i chanched the conecctionString to
>
> "data source=(local);Initial Catalog=Northwind;User ID=sa;pwd=;"
>
> but not is possible tha connection yet
>
> --
> Message posted via http://www.dotnetmonster.com


Top