When attempting to configure an OleDbDataAdapter I get the
following error message:
[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not
exist or access denied.
Here is the detail
I am evaluating Visual Studio.Net and I am new to the
environment. In the process of evaluating VS.Net, I am
working through several of the "walk through" sample
programs. The sample that I am currently working on
is "Walkthrough: Simple Data Access in a Windows Form"
The sample states:
In order to complete this walkthrough, you will need
Access to a server with the Pubs SQL Server sample
database.
When I search the directory of my hard drive, I can find
the "Pubs" data base in the followng location
c:
Program Files
Microsoft SQL Server
MSSQL$NETSDK
DATA
Pubs.mdf
Additionally, when querry with "net start" at the command
prompt, I find that MSSQL$NETSDK is running.
So, as far as I can tell, I do have access to a server
(local) and the "Pubs" data base.
After I drop the OleDbDataAdapter onto the windows form,
the "Data Adapeter Configuration Wizard" starts.
On page 2 of this wizard, the "Which Data Connection
Should the Adapter Use" combo box is blank. I am unable
to type anything into the combo box, nor does the drop
down arrow drop anyitem down. Next to the combo box is
a "new connection" button, which when clicked brings up
a "Data Link Properties Dialog."
This dialog box has 3 steps. In the first step I
type "local" or "localhost" (I've tried both) into
the "Server Name." In the second step, I've selected
the "Use Windows NT integrated security" radio button. In
the third step which is the "Select the Database on the
server" radio button and combo box, I click on the drop
down arrow and I get the error message:
[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not
exist or access denied.
