Connection to SQL from VB.Net Standard Edition

• Rakesh Kumar Gupta

  SSC Journeyman

  Points: 85

  More actions

  June 24, 2003 at 12:29 am

  #81921

  I have Visual Basic.Net Standard Edition. I am trying to connect to SQL Server. While establishing connection it is displaying the following error message

  "Unable to connect to database

  It is only possible to connect to SQL Server desktop Engine databases and Microsoft Access databases with this version of visual studio"

  But In Data Link Proerties page i am getting Test Connection Successed only when i am clicking on OK i am getting above message.

  What it means ? Please help how to connect to SQL Server. I have SQL Server 2000 Evalution Copy.

  Thanks

  Rakesh

  rakesh

  
  rakesh

• tymberwyld

  SSCertifiable

  Points: 7810

  More actions

  June 25, 2003 at 6:30 am

  #462996

  Hmm, odd. I'm using VS.NET 2003. I imagine you are trying to use the IDE to make your connections?

  Try doing straight code instead:

  Dim sqlCon As New sqlClient.SQLConnection("Data Source=(local);Initial Catalog=MyDB;Integrated Security=SSPI")

  sqlCon.Open

  sqlCon.Dispose: sqlCon = Nothing