Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Dreamweaver CS3 connection to an Access database

Posted on 2009-02-23
13
Medium Priority
?
1,373 Views
Last Modified: 2013-11-12
Firstly I must point out that Im using Vista 64 and Dreamwaever CS3 - I've seen similar issues to this apply to XP and those fixes dont work for me.

I'm trying to create dynamic .net pages. When I define a connection to the access database I selct Microsoft Jet 4.0 locate the database - test the connection succesfully and then after clicking ok I drill down to my tables in the application panel. The tables show as 'None'. Thus I cant create datasets etc.

The website folder resided on the C: drive and I believe I have the appropriate permissions defined.

Adobe seem at a loss so hopefully someone can point me in the right direction.

Any ideas how to resolve this.
0
Comment
Question by:richard1966
  • 7
  • 6
13 Comments
 
LVL 25

Expert Comment

by:Rouchie
ID: 23719470
Dreamweaver is appallingly bad at making .NET sites.

Try creating a System DSN for the database (not sure where this is in Vista but in XP its under Programs > Admin Tools > Data Sources (ODBC).

You should then be able to use this in Dreamweaver.

Although DW doesn't recognise it in any way, ASP.NET provides support for Access straight out of the box.   The thing is only Microsoft's Visual Studio Web Developer (free version) gives any decent ability to drag and drop database data into ASP.NET pages.  More info http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/
0
 

Author Comment

by:richard1966
ID: 23719645
Thanks but tried that to no avail. In fact when I try to add a sytem DSN I get the following error.

Microsoft ODBC Administrator

The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to system code 126.

Then it says : Errors found:  Could not load the setup or translator library.

I've tried again this morming creating a new site, a new database just in case there may have been anonmalies but the same error again. Any ideas. I think it is material to state again its Windows Vista 64 Ultimate, Office 2007 and Dreamweaver CS3.

I think this may need a minot miracle if there are any such workers out there.
0
 
LVL 25

Expert Comment

by:Rouchie
ID: 23719723
Well perhaps Microsoft should try fixing the 'miracle' of bad design that is Vista.

Try this... http://support.microsoft.com/kb/260558
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:richard1966
ID: 23720012
Thanks for the KB and indeed the dll was not in the system32 folder as referenced in the registry. I have put it there now and made the corrections but to no avail. It still doesn't work.

I get a slightly different error message from the ODBC setup - 'the setup routines for the microsoft access driver .mdb odbc driver could not be loaded due to system error code 193'.

Not sure if this is one step closer or one further away.
0
 
LVL 25

Expert Comment

by:Rouchie
ID: 23720085
Hmm it turns out that all these database drivers are 32-bit drivers, and rarely work on x64.  Doesn't that just make you love Microsoft.  Other people are having the same issue too...
http://www.vistax64.com/drivers/168477-installing-32-bit-odbc-drivers-vista-x64.html

It may be that using Visual Web Developer is the only option now because that uses the built-in ASP.NET drivers for database communication, whereas DW is relying on Windows to do the communication.
0
 

Author Comment

by:richard1966
ID: 23720309
Surely there must be a fix for this with the mighty Adobe and Microsoft behind this or am I just being cynical to hope.
0
 
LVL 25

Expert Comment

by:Rouchie
ID: 23720378
Don't expect anything from Adobe.  They have now abandoned ASP.NET in favour of HTML and PHP.  The code you are suffering with is the last remaining logic from Macromedia before their buy-out.

In the last link I posted the person executed the 64 bit driver EXE and that solved their problem.  Sadly they have to do this each day because x64 by default will first load the 32bit driver, then the 64 bit driver which doesn't work with 32 bit database.

It might have been nice for Microsoft to think people might still have 32bit databases...
0
 

Author Comment

by:richard1966
ID: 23721330
I tried the 64 bit exe and was able to create a system dsn but this is by no means a solution. I think your right in saying Adobe focus has changed and may have to look at using MYSQL and PHP for my web development if I want to continue to use Vista 64. I don't fancy going back to XP32 as other than this the OS is as stable as a windows OS has ever been. The other altenative is to embrace the MAC framework. I figure Microsoft will sort this out but when. Happy days, just when you thought all was going well...
0
 
LVL 25

Accepted Solution

by:
Rouchie earned 2000 total points
ID: 23721422
I suppose you could put a shortcut to the EXE file in your STARTUP folder...

I've got to be honest, I thoroughly recommend scrapping DW for ASP.NET development anyway.  I've used a variety of server-side choices over the years and .NET is by far the most powerful tool I've come across.  Its object oriented model means that you no longer have to write zillions of IF ELSE statements to inject functionality into your page and create logic paths, which applies to ASP and PHP.
In ASP.NET you have a clean seperation between logic and presentation, and just inject the database into your presentation.  It sounds quite complex but really its very easy.

I don't really know what to say about Microsoft's 32-bit drivers.  I am very surprised it hasn't been dealt with.  Perhaps not enough people have adopted x64 to justify their time.  I would have thought eventually 64-bit operating systems will become standard anyway?
0
 

Author Closing Comment

by:richard1966
ID: 31550230
Thanks for your help with this.
0
 
LVL 25

Expert Comment

by:Rouchie
ID: 23732371
Your're welcome.  And good luck with the rest of your project.
0
 

Author Comment

by:richard1966
ID: 23732405
In the grand schem of things I think it prudent for me to concentrate on the MYSQL and PHP side of things. It seems a better supported platform without the paraphenalia that is attached to Microsoft's offerings. Ironic that something so fundematal as a database connector is not available in a 64 bit OS that is promoted by the software giant as the future. Perhaps I expect to much ;)
0
 
LVL 25

Expert Comment

by:Rouchie
ID: 23732514
I'm not sure about PHP I've never used it.  The concept though is very similar to ASP so I advise you ask about the database drivers first!
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question