Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problem connecting to MSSQL

Posted on 2000-03-22
5
Medium Priority
?
155 Views
Last Modified: 2010-04-04
I am trying to connect to a MSSQL database. I can access to tables using MS tools but I cannot set up an alias in the BDE administrator. The error I get is server not availible. What am I doing wrong? What parameters are important when setting up a MSSQL alias and where do they come from?
0
Comment
Question by:CalvinDay
  • 4
5 Comments
 
LVL 12

Accepted Solution

by:
Faruk Onder Yerli earned 200 total points
ID: 2645763
Please Write on the bDE

Database Name : master
USERNAME      : sa
SQLQUERYMODE  : Server
SERVERNAME    : yourservername or
                         IP adress

You must copy Ntwdblib.dll files in windows\system directory.

it is enough ...
0
 
LVL 2

Author Comment

by:CalvinDay
ID: 2646230
equalizer

I have two users. One is dbo. Do you know its password.
0
 
LVL 2

Author Comment

by:CalvinDay
ID: 2646245
equalizer

I have two users. One is dbo. Do you know its password.
0
 
LVL 2

Author Comment

by:CalvinDay
ID: 2646250
Or, do you know the password for sa in the master database?
0
 
LVL 2

Author Comment

by:CalvinDay
ID: 2646360
Never mind, there is no password.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

885 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