answersLogoWhite

0

use OLEDB connection string OleDbConnection con=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data Source=[your database name.mdb]");

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

What is a connection string used for in computers?

A connection string in computing is a string that specifies how to connect to a data source and information about the data source. It is commonly used in database files.


What is an SQL server connecton string?

An SQL server connection string contains information that providers need to know in order to establish a connection to a database. There are many ways to write a connection string because each provider has multiple ways to make a connection.


How do you count words in a paragraph using string?

use Microsoft word


How does Microsoft communicate with their employees?

two cups with a piece of string attached to them both.


Which keyword is used in connection string for attaching to a file?

AttachDBFilename


How to you store image in ms access database from vb.net?

using System.Data.OleDb; OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0 using System.IO; IO is used to create the memory stream variable that can store the binary format of the image content. C# Code to Upload Image to MS Access Database: int imageSize; string imageType; Stream imageStream; // Gets the Size of the Image imageSize = fileImgUpload.PostedFile.ContentLength; // Gets the Image Type imageType = fileImgUpload.PostedFile.ContentType; // Reads the Image stream imageStream = fileImgUpload.PostedFile.InputStream; byte[] imageContent = new byte[imageSize]; int intStatus; intStatus = imageStream.Read(imageContent, 0, imageSize); Connection string to connect the ASP.Net 2.0 web application with MS Access Database: // Access Database oledb connection string // Using Provider Microsoft.Jet.OLEDB.4.0 String connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("App_Data/db1.mdb");


Where can one go to obtain SQL connection string samples?

ConnectionStrings is a website that offers SQL connection string samples. One just needs to visit the ConnectionStrings website to obtain these samples.


What message is conveyed by the string on the wall?

The string on the wall symbolizes connection and unity, reminding us that we are all interconnected in some way.


What are the functions Microsoft Excel?

Functions allow you to perform some mathematical or string procedures to other cells.


How do you search from database using ASP?

There are thee basic steps: Obtain the connection string and open the connection to the database Prepare your query and execute it, retrieving the result into a dataset Close the connection


How do I create a database login screen on c sharp?

Basically in order to login to a database you need a couple of inputs from user: - Server Name DB Name UserName/password All of these would be used to frame a connection string that can be used to initialise a SQLConnection object and open the DB connection. A standard connection string would be: - string strSQLconnection = "Data Source=dbServer;Initial Catalog=DBNAME;Integrated Security=True;uname=username;password=pwd"; -> In this case string strSQLconnection = "Data Source=" + textbox1.text + ";Initial Catalog=" + textbox2.text + "........... //initialize sqlconnection from the connection string. SqlConnection sqlConnection = new SqlConnection(strSQLconnection); //initialize the query to be fired. SqlCommand sqlCommand = new SqlCommand("select * from table1", sqlConnection); //open sql connection sqlConnection.Open();


Are 5 string basses shorter than 4 string basses?

Actually, lengths of a bass does not depend on the number of strings. Basses can be of different length but this has no connection with the number of strings.