Dreamweaver MX aspx DB Connection

[coinkydink]

Hi,

This is doing my head in. I'm trying to connect to a MS SQL Express 2005 DB via Dreamweaver MX and can't seethe tables that I set up using the Management Studio.

I've run the patch/extension, I've tried the workaround of deleting the scripts subdirectory, all without success.

The SP2DBFIX extension all seems to run ok, whenever I click test in the connection setup it puts the files, but then comes up with error 405 method not allowed.

Any clues anyone?

Cheers

[Aristotle]

What does your connection string look like?

Aristotle

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[coinkydink]

Hi Aristotle,

After tearing my hair out for a while I've decided to go back to what I know better (MySQL) for development, once I get cashed up I'llmigrate to MS SQL.

HOWEVER! Now I'm having trouble setting up a dsn less connection in Dreamweaver. This SHOULD work (I think).....

DRIVER={MySQL};SERVER=mysql01.discountasp.net;DATA BASE=MYSQLDB_*****;USER=****;PASSWORD=****;

But all I get is "Unidentified error ocurred". Any advice gratefully accepted.

Cheers

[01asper]

Open a page in DW, goto application, then databases, then add custom connection string.





Give your connection a name (no spaces or funny characters allowed)


Then add the line below:


"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" ...


check "Use driver on testing server" and then try and test.


If DW comes back OK your done, if not then use the error to work out whats going wrong.


good luck.

latest softwares (http://www.softsea.com)