SQL Server 7.0 , ADO & VB 6.0
Have you tried to type the name of your server?
I can't see my server in the dropdownlist but everything works if I
type the servername myself. If you are running SQL Server on the same
computer try to type "local" as servername. After you type the
servername you should see list of databases on that server.
Hope this is for some help.
Kari S.
On Tue, 28 Sep 1999 09:45:09 +0200, Mario Acosta-Alarcon
Quote:
>I'm trying the simplest possible connection ADO - OLE DB
>I place the ADODC Data control on the form then, right click Properties,
>Use Connection String, Build, MS OLE DB Provider for SQL Server,
>Then I have the Data Link Properties window and I try "Use data source
>name"
>with the hope that I'll see SQLSERVER101 (my default ) and nothing
>happens.
>I tried many options from "Test Connection" to enter user name &
>password.
>My PC hangs and I have to cancel VB 6.0.
>I'm connected to the SQL Server 7.0 NT via a network and I'm running
>TCP/IP.
>I have the SQL Server Client running on my PC all fine.
>What is wrong? Is there something else I need to configure?. I just want
>to access the Northwind sample database.
>Any help will be appreciated.
