Solved

Dreamweaver and ADO

Posted on 2007-12-02
4
363 Views
Last Modified: 2013-11-30
Hi Experts,

I'm using Dreamweaver and My hosting account got DSN file which automatically createed for me, works with ASP and uses ADO to access a database. Is that Dreamweaver supports for ADO?
0
Comment
Question by:sivakugan
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:mdefalco
Comment Utility
That should work in Dreamweaver. You have to create a site, and then go to the applications tab on the right. Click the plus sign to open the connection wizard
0
 

Author Comment

by:sivakugan
Comment Utility
Hi mdefalco,

Is that ADO and ODBC are same?
if not, can u mention the difference between ADO,ODBC and OLEDB
0
 
LVL 4

Accepted Solution

by:
mdefalco earned 500 total points
Comment Utility
A DSN is just a file that has a connection string in to, then in your code you reference the DSN file.

ODBC uses DSN files as well, this is setup on your machine though (Administrator Tools, ODBC Sources)

OLEDB is the connection string you use for connecting to the database, such as SQL. This can be in the DSN, or in the Global.Asa file, or any file that you include into your asp page.

ADO is the code you will use while connecting to the database, to create recordsets.

Does that help, or would you like to see a copy of some code I have for an asp page that connects to a  SQL database and checks for email addresses?
0
 

Author Comment

by:sivakugan
Comment Utility
Thats more than enough but I want to clarify one thing.

In my shared hosting account , the hosting company creates DSN for me. which supports ADO.
Now my problem is, How can I use that DSN to connect to the database using Dreamweaver.
It's because they don't allow to connect remotely and select the DSN (using Dreamweaver) they have created for me?...

Any idea.

Thanks in Advance
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
reposition hamburger icon to top of screen 5 45
Network Connection 5 31
Set cookies HttpOnly and Secure 4 50
Menu Inconsistent 3 19
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now