Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DataEnvironment Connection to a remote SQL Server database

  
   Database Help (Home) -> Visual Basic -> ADO RSS
Next:  Cannot Delete Pocket Access File  
Author Message
John Blair

External


Since: Feb 17, 2005
Posts: 3



(Msg. 1) Posted: Thu Feb 17, 2005 3:40 pm
Post subject: DataEnvironment Connection to a remote SQL Server database
Archived from groups: microsoft>public>vb>database>ado (more info?)
Hi,

I am trying to connect one PC (win98) to SQL Server located on another PC
(winxp1) but am failing with an error message:

Test connection failed because of an error in initializing provider.
[DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access
denied.

I am able to connect locally to SQL Server on winxp1 so i know the database
is ok. This is the first time i have tried to connect remotely. On the
connection
options i have tried to use Windows NT integrated security and
tried using a specific user name and password.
The database i am trying to connect to is the microsoft pubs sample
database.
I am thinking i need to configure this database to allow remote connections
but not sure what?...any help appreciated. Thanks.

 >> Stay informed about: DataEnvironment Connection to a remote SQL Server database 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
ADO Connection Access Database VB - I have been accessing a database on a local drive thru an ADO connection. The following is the code that I have been using. cnCejco.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Y:\Cejco.mdb;Persist Security Info=False" The problem is n...

Create Database - Hi, Looking for some ideas ? ADO / RDO ? I need to develope a visual basic application that when a user launches the application it checks to see if the datase for the user is created if the user does not have a DATABASE it creates one then creates a...

SQL server image field - I have a problem related to a field in a SQL table whcih is an "image" datatype. The powers that be here claim it is a bmp. I think it is not, or that it is encrypted in some way. I would like to test my theory by reading the data in the fie...

Accessing data on a web server - I have written a VB6 app for a user that uses ADO to connect to a MySQL database (through the MyODBC driver). Not being much of a internet programmer, the user asked me if it is possible to move the the database to a web server and have the client progra...

runtime error 3021 and user permissions - I have a VB6 application that uses ADO 2.7 to access an Access2000 database. I have found on Windows XP and 2000, that if the user is not part of the administrators group, they receive: "runtime error 3021. Either BOF or EOF is true, or the current ...
   Database Help (Home) -> Visual Basic -> ADO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]