I am trying to connect to a database i created in access. I am using Dreamweaver CS3 FTP to connect to discountasp . I have named the: DNS healthyeate_connect Path \_database\customerDetails.mdb When in dreamwaever and I am trying to make a connection using the DSN connecting box i input the DNS - healthyeate_connect, then i click on the DNS button to select the ODBC but the list is blank. What am i doing wrong or what am i meant to do? I have uploading the database to the correct folder and my document type is ASP VB script.
Hi, I used Macromedia Studio for years for Access, SQL Server and ASP, loved it.</o> Haven't used the newer CS3 but I'm guessing the methods are the same.</o> </o> Let me ask a few questions...</o> </o> Are you on IIS6 or IIS7 here?</o> </o> Does this need to be with a DSN? Will aDSN-less connectionwork for you? I always found them much easier to work with.</o> </o> btw, did you create the DSN in your Control Panel and on your local machine?</o> If so, do you have any files that Dreamweaver created? typically they are named such as conn.*</o> </o> I'll do my best to get you up and running. Salute, Mark</o>
Am on ASP.NET 3.5 hosting Sorry for lack of info, am a real noob when it comes to database connection but i do know about it and have SQL knowledge. I hope i don?t become a nuisance here lol. *Right, i believe am on the IIS7. (but no option for me in control panel regarding IIS) * The connection does not have to be in DNS as long as i can connect and interact with the database. There is option on the CS3 for DNS less connection so am sure it works for me. *I did create the DNS in the control panel on discount ASP.net DNS healthyeate_connect Path \_database\customerDetails.mdb</o> But not on the local host machine. (why on local host)</o> *i have connecting to the root of my site and all other folders (remote file) on the hosting site.</o>
Hi, In your Control Panel it will show, under the Info section, if you are on Windows Server 2003 or 2008. If it shows 2008 you are under IIS7. The reason I asked is apparently some of the Access DB methods are not available on IIS7. I haven't had time to test Access on IIS7 yet but this DNS-less method should work: http://kb.discountasp.net/article.aspx?id=10476 btw, The reason I asked if you had created a local DSN is the way Dreamweaver allows testing. It has a very nice feature where you can have your data servers, local and remote connecitons, etc. Can alsowritehundreds of lines of code for you once you create those connfiles. Salute, Mark
I never had any problems running ASP and Access code on the 2003 servers here. You should be all set once you learn more about the IDE you are using. Actually I really miss the site sync features in Dreamweaver. It's my active wish that Visual Studio someday will have similar features. Salute, Mark
here can can i to learn a step to step on how to connect . or can u talk me through it if u have time. Michael
I'll install my Macromedia Studio 2004 MX on the system I use for my kids. Will be later today if they, my three kids, give me some time. Then I'll be able to give you step-by-steps. Macromedia used to have good instructions on thier site. Since the Adobe buyout I didn't access their site anymore but you may want to take a look. There should be some good stuff there for your product and Access connections. Salute, Mark
man ur really help full, thanks alot for taking the time out. I am also looking at http://www.expertrating.com/courseware/DreamweaverCourse/Dreamweaver-Tutorial.asp for help. ill be on there till 1am then carry on tomorrow. hopfully will get this database up and running. ---------------------------------------------------------------- Michael Michael
They have some annoying popups on that site but this page is a good one for you: http://www.expertrating.com/courseware/DreamweaverCourse/Dreamweaver-Database-7-2.asp
UPDATE... What I decided to do is create an example site for you using Dreamweaver and an Access DB named the same as yours. I've also used the same folder location for it, "_database" . In Dreamweaver the best thing for your account here will be to have two connection strings. One for local testing and development, the other for the live site. From the Dynamic section of the toolbar you can connect to any connection strings you place in the /connections/ folder. For the example site attached I've created one for your local testing and one for the remote site. (Listed below) The conn string for local testing uses a physical location for the database. (Local drive) Forthe live,remote, site I'm using the Server.MapPath method. (Very handy) Local: (/Connections/conn.asp)
thanks alot wisemx i will have a look at this and a go at it monday. am on my way to work in a few hours. fingers crossed. have a good day. Michael
Thanks to this tread I am now connected to DSP VIA Dreamweaver remote. Custom connection string I used: "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/_database/educoncert.mdb") I feel my headache going away.
Good job Technical Evangelist for DiscountASP.NET http://www.iis7test.com/webcasts/ http://weblogs.asp.net/markwisecarver/ http://blogs.windowsclient.net/wisecarver/default.aspx (Microsoft IT Usability http://msitusability.multiply.com/)