Deploy applcation VBNET and Sql

  • Thread starter Thread starter Carlos G via DotNetMonster.com
  • Start date Start date
C

Carlos G via 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
 
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.
__________________________________
 
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
 
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.
__________________________________
 
i chanched the conecctionString to

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

but not is possible tha connection yet
 
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.
__________________________________
 
Back
Top