PDA

View Full Version : Problem connecting to Access database


Sky
05-20-2005, 04:35 AM
Hi

I've only just started using Dreamweaver to create ASP.NET applications and having a problem connecting to am Access database. I'm using Windows XP Professional, IIS 5.1 and Dreamweaver MX 2004

I've tried adding the database as a System DSN in ODBC under Administrative Tools in XP and created the following Connection String in Dreamweaver:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\DataGridSamples\Northwin d.mdb;
Persist Security Info=False;

The Northwind.mdb file was copied into the "C:\Inetpub\wwwroot\DataGridSamples\" directory.
The site details in Dreamweaver were set as follows:

Site name: DataGridSamples
Local root folder: C:\inetpub\wwwroot\DataGridSamples\
Server Model: ASP.NET C#
Access: Local/Network
Testing server folder: C:\Inetpub\wwwroot\DataGridSamples\
URL prefix: http://localhost/datagridsamples/ ('http://localhost/datagridsamples/')

When I run "Test Connection" it says the connection was successful and the database appears in the "Databases" window but when I navigate to "Tables" it says "None" instead of displaying the tables.

Yet when I go to "Server Behaviours" and click "DataSet" it allows me to select the Northwind database and access the tables.

Is there a known problem with Dreamweaver displaying Access databases or should I have done something differently? Any help will be greatly appreciated.