Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Problem connecting to MSSQL

Posted on 2000-03-22
5
Medium Priority
?
154 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
[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
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

688 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