about sqlconnection?

Hot Topic

msgbox problem
Problem withconnection string
MSF CMMI and Employee Performance Appraisals
How to get the logged in user is Admin / User
How to get DB Pro ?
Load Testing Production websites in different domains
Test plans
deploy already
Hyperlink to a button
Adding to listveiw on another form?

VS Team System

Screen is going off and on
Coloring syntax
Adding web part on Home page Team foundation sever
The Selected file cannot be opened as a solution or project
datagridview in visual baisc
Custom Test Type: How to Debug?
slideshow
about sqlconnection?
VSTS and Visual Sourcesafe
what's the solution for inserting reference data?

about sqlconnection?

hi gud day ppol.... i have a problem regarding sqlconnection for example
dim theConnectionString as new sqlclient.sqlconnection(" what's NEXT "no idea"") thx in advance... sorry for stupid question



Answer this question

about sqlconnection?

  • jon albinini

    Dim theConnectionString as New SqlClient.SqlConnection("Data Source=YOURServerAddress;Initial Catalog=YOURDataBase;User Id=YOURDATABASEUsername;Password=YOURDATABASEPassword")


  • Mo Majad

     

    You know... a really good place to look this up is www.connectionstrings.com

    Actually it's a little better to say....

    dim Conn as new sqlclient.sqlconnection("WhatIFoundatConnectionStringDotCom")



  • PeterVrenken

    OK then you would use oledb



  • rebecca M

    So u mean is i should input the corresponding connectionstrings depends on my database for example MSAccess OLE DB, OleDbConnection (.NET)
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;UserId=admin;Password=;"


  • Eugen_S

    currently i'm using ms access 2000....


  • John Lockhart

    thx for replies.... thx a lot

  • Sotham

    What kind of database are you using



  • steal

    yes...in the case of using OleDb for MS Access, you could write this one:

    Dim theConnectionString as New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;UserId=admin;Password=;")



  • about sqlconnection?
Answer this question