This thread is for discussions of Creating a database connection.

It´s ok. works good

Sir,
I am presently engaged in doing networking project in VB.NET and MSAcces.
I would like to know the connection string
(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.......) for connecting to a database in another machine(given its machine name) in  a network while sitting in my own machine(also in the same network). I would be grateful if you help. Expecting your early reply,
Thank you
Renjini S
Please mail me at
srenjini@sify.com

I keep getting an error when I try and create a new data connection. This is the error I'm getting.

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.


I can connect to Access without any problems. Is there anyway around this?
I'm using VB .net Standard with SQL Server 2000.

Thanks for any help.

Plz reply me when i ma writing in c# using System.Data.Ado for the database connection with m.s acess then it is giving errror  the type name space ado does not  exist in in the class system.Data.ADO
what is reason
plz answer me

                                             string connStr;
           string qryStr;
           OleDbConnection dbConn;
           
                                                connStr = "Provider=Microsoft.Jet.OLEDB.4.0; " +
           "Data Source=G:\\Backup\\Kashif\\xyzDB.mdb";
           qryStr = "select content,websiteID  from content";
           dbConn = new OleDbConnection(connStr);
                       

Amir

Hi..
I'm trying to connect to an access database that is protected by password. but, it's always says "the database is being opened exclusively by another program" even I don't open other application. Please help me to solve this problem

Open connection to password protected Access database:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb; Jet OLEDB:Database Password=Your_Password"

hi i am trying to connect my vb. net prog tosql can yoi help me on how to do that..
here is my codes..please tell my the error and what else do i need to put..
Try

        Dim LintCount As Integer
        Dim resultValue As Boolean
        Dim myreader As SqlDataReader
        Dim conn As New SqlConnection("Datasource = TASDI;" + "userId = test;" + "password = test;")
        Dim myConnection As SqlConnection
        Dim myCommand As SqlCommand
        Dim strsql As String
       '     Call LSubfrmCnlenabled(True)


            myConnection = New SqlConnection("userId=Test;" + "password =Test;" + "datasource=TASDI;")
            establishing connection. you need to provide password for sql server
            myConnection.Open()
            opening the connection
            myCommand = New SqlCommand("Select * from M_EMPLOYEE", myConnection)
        executing the command and assigning it to connection

            myreader = myCommand.ExecuteReader()
            While myreader.Read()


            End While
            myreader.Close()
            myConnection.Close()
        Catch ex As Exception
        End Try



please reply