Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC-DataSourceAdm...ASP and SQLserver7.0

Posted on 1998-12-01
6
Medium Priority
?
192 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
[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
  • 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
Independent Software Vendors: 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!

 

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This article discusses how to create an extensible mechanism for linked drop downs.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

636 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