sql connection

  1. K

    Visual Studio Community Edition sql connect string

    I am trying to connect to sql express which is integrated with Visual Studio Community Edition (2013). this is my code and connect string. Dim mycn As New Odbc.OdbcConnection Dim strcn As String = "Data Source=(localdb)\v11.0;AttachDBFilename=|DataDirectory|\sqlserver.mdf;Integrated...
  2. T

    Remote SQL connection problem, though works fine with SSMS

    I can successfully make a connection to a database on a remote server using SQL Server Management Studio, but when I try to connect to the same database using the add connection wizard in Server Explorer in VB.NET 2008 (Standard version), I get the following error message: The File...
  3. Th4x3

    Question Data TableAdapter

    He im creating a user login form where my users put in a nickname and the TableAdapter searches for the matching password and returns it to my program, I made a little code to convert the tabulardata to an single string but when i use it i get a blank msgbox where the password should be...
  4. Th4x3

    Question Sql Table Adapter

    He im creating a user login form where my users put in a nickname and the TableAdapter searches for the matching password and returns it to my program, I made a little code to convert the tabulardata to an single string but when i use it i get a blank msgbox where the password should be...
  5. hpbhathiya

    Question SQL nonQuery execution error

    Dim cmd2 As New SqlCommand("INSERT INTO Passengers (FlightNo, TravelDate, FName, LName, Age, Gender, Class, SeatPref, MealPref, SSR, Status) VALUES ('" & flightNo & "','" & dateStr & "','" & fnametxt.Text & "','" & lnametxt.Text & "','" & agetxt.Text & "','" & genderdropdown.Text & "','" &...
  6. F

    Connection Pooling Issues

    Hello everyone, I have a data driven application in VB which works with an SQL Server 05 Database. Since this app makes use of many queries and commands, occasionally i'me getting a timeout error as the connection pool is full. So i figured that at a specifc point in time within the app, i'll...
  7. C

    Question SQL connection problem for Report Viewers

    I have created a windows forms application with a SQL server backend. I am populating textboxes, listboxes, treeviews using Sql queries. I attached my database to SQL Server on the ‘client’ machine and the above all populate fine both in the development environment and when deployed. I am also...
Top Bottom