Solved

ODBC-DataSourceAdm...ASP and SQLserver7.0

Posted on 1998-12-01
6
174 Views
Last Modified: 2010-04-09
 Have installed MS SqlServer7.0 Beta 3
  Want to test how to access data in an Sql database with
  ASP-scripts.
  Have already made a testapplication using
  FrontPage (ASP), Access97 and VBScript...everything
  works fine within this appl.

  I want to do the following:
  - Create a database in MS Sql 7.0 similar to the
    previously created database in Access97.
    This is done.
  - Set up the nessesary settings in the ODBC Data Source
    Manager in Control panel so I can access the
    database.
    How do I do this??????
  - How do I access this database from within ASP ??????

   I use a stand alone PC, and windows95.
0
Comment
Question by:erot
  • 4
  • 2
6 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 200 total points
ID: 1840139
1. ODBC

This is based on Windows NT SQL 6.5

- Open ODBC Data Souce Administrator in Control Panel
- select System DSN
- click "Add"
- choose SQL server
- click finish

- give it a name, remember it ! (description is not needed)
- choose local server
- (next)
- choose SQL authentication, username/password what is needed

- use default options for the rest


2. ASP
Probably in the global.asa of your application, the DNS source is mentioned. Change that to the new database:

something like:

"DSN=Your_DSN;SERVER=local;UID=sa;PWD=;APP=;DATABASE=Master"


0
 

Author Comment

by:erot
ID: 1840140
To Sybe... what is global.asa and where do I find it.

pnt. one worked out well.

Erot/Norway
0
 
LVL 28

Expert Comment

by:sybe
ID: 1840141
most ASP applications have a file called "global.asa", which sets global variables. The file must be in the root of the application.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:erot
ID: 1840142
Could not find any info on "global.asa".

Tried to do the following which works fine when accessing an
 access database:

  set conn = Server.CreateObject("ADODB.Connection")
  conn.open "DSN=Tore", "", ""
  set rs = server.CreateObject("ADODB.recordset")
  strSql = "Select FirstName from Person"
  rs.open strSql, conn, 3, 3

  have also tried different versions  with the conn.open:
  conn.open "DSN=Tore", "UID=sa", ""
  conn.open "DSN=Tore", "UID=sa", "PWD="

  should it not be possible to do it this way????


 
0
 

Author Comment

by:erot
ID: 1840143
Forgot to tell you that the code above give no errors.

0
 

Author Comment

by:erot
ID: 1840144
Found out how it works....

  conn.open "DSN=NameOfDsn;UID=sa;PWD="   works well.

 Thank you..

 Erot/Norway

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
This article discusses four methods for overlaying images in a container on a web page
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

860 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