Hi,

I reinstalled SQL 2000 and the below code works fine. I had done this before
with VB, ADO 2.5 and SQL 7 but it didnt work with SQL 2000 for some reason -
mst have some option I shouldnt have selected when installing SQL 2000
initially.

Thanks for the reply
Niall

hDb.ConnectionTimeout = 10
    hDb.Provider = "sqloledb"
    hDb.Properties("Network Address").value = "192.192.192.192" 
    hDb.CommandTimeout = 8
    hDb.Properties("Network Library").value = "dbmssocn"
    hDb.Properties("Data Source").value = "pc899"
    hDb.Properties("Initial Catalog").value = "BillDB"
    hDb.CursorLocation = adUseServer 
    hDb.Properties("User ID").value = "usrname"
    hDb.Properties("Password").value = "pswword"
    hDb.Open

-----Original Message-----
From: Alex Read [mailto:aread@b...]
Sent: 19 August 2002 15:51
To: professional vb
Subject: [pro_vb] Re: SQL Server 2000 and VB


I'm sure I've done this before, yes - what's your code & what error are 
you getting?

---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills 
from Visual Basic 6 to C#, the language of choice 
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059



**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************