Solved

Dreamweaver and ADO

Posted on 2007-12-02
4
392 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:mdefalco
ID: 20392944
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
ID: 20393003
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
ID: 20393550
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
ID: 20393638
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

Industry Leaders: 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!

Question has a verified solution.

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

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

752 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