?
Solved

ODBC-DataSourceAdm...ASP and SQLserver7.0

Posted on 1998-12-01
6
Medium Priority
?
200 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 800 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This article describes how to create custom column layout styles for Bootstrap. The article uses 5 columns to illustrate the concept, but the principle can be extended to any number of columns.
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
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…
Suggested Courses

850 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