Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

Dreamweaver and ADO

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
sivakugan
Asked:
sivakugan
  • 2
  • 2
1 Solution
 
mdefalcoCommented:
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
 
sivakuganAuthor Commented:
Hi mdefalco,

Is that ADO and ODBC are same?
if not, can u mention the difference between ADO,ODBC and OLEDB
0
 
mdefalcoCommented:
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
 
sivakuganAuthor Commented:
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
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now