Dreamweaver CS3 connection to an Access database

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.
richard1966Asked:
Who is Participating?
 
RouchieConnect With a Mentor Commented:
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
 
RouchieCommented:
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
 
richard1966Author Commented:
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
RouchieCommented:
Well perhaps Microsoft should try fixing the 'miracle' of bad design that is Vista.

Try this... http://support.microsoft.com/kb/260558
0
 
richard1966Author Commented:
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
 
RouchieCommented:
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
 
richard1966Author Commented:
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
 
RouchieCommented:
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
 
richard1966Author Commented:
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
 
richard1966Author Commented:
Thanks for your help with this.
0
 
RouchieCommented:
Your're welcome.  And good luck with the rest of your project.
0
 
richard1966Author Commented:
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
 
RouchieCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.