|
|
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>EasiReporter.Topics.Connection</title>
<link rel="stylesheet" type="text/css" href="EasiReports.css">
</head>
<body>
<h1>Database Connection</h1>
<p>The first thing you must do when you create a report is to set the database
connection string.</p>
<p>You can set the database connection string in the
<a href="EasiReporter.Dialogs.Connection.htm">Database Connection Dialog</a>.</p>
<p>The database connection string provides the link from EasiReports to your
database.</p>
<p>It tells EasiReports what kind of database you are using, where to find it,
and other information such as your login name and password.</p>
<p>The easiest way to set your connection, is with the
<a href="EasiReporter.Dialogs.DataLink.htm">Data Link Dialog.</a></p>
<p>
<b>NOTE:</b> Use the "Microsoft Jet 4.0 OLE DB Provider" provider for Access
databases.</p>
<p>You can set the connection string manually if you know the settings.</p>
<p>This is an example connection string for an <b>Access</b> database :</p>
<pre class="Code">
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Data\Northwind.mdb;
</pre>
<p>And this is an example for a <b>SQL Server</b> database :</p>
<pre class="Code">
Provider=SQLOLEDB.1;
Initial Catalog=Northwind;
Data Source=<ServerName>;
Integrated Security=SSPI;
</pre>
<p> </p>
</body>
</html>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I discovered C# and .NET 1.0 Beta 1 in late 2000 and loved them immediately.
I have been writing software professionally in C# ever since
In real life, I have spent 3 years travelling abroad,
I have held a UK Private Pilots Licence for 20 years,
and I am a PADI Divemaster.
I now live near idyllic Bournemouth in England.
I can work 'virtually' anywhere!
Submit an article or tip