Hello,

Could someone help me out on this - I have a VB app but I cannot connect to
sql server 2000 (it used to work ok off sql server 7). The connection code
is....

'Set hDb = OpenDatabase(Db, False, False, ";PWD=" & iniPW)
frmSplash.Label1(2).Caption = "Requesting Login...."
 hDb.ConnectionTimeout = 25
    hDb.Provider = "sqloledb"
    hDb.Properties("Network Address").value = "123.123.123.123"
    hDb.CommandTimeout = 10
    hDb.Properties("Network Library").value = "dbmssocn"
    hDb.Properties("Data Source").value = "abc"
    hDb.Properties("Initial Catalog").value = "MyDatabase2"
    hDb.CursorLocation = adUseServer
    hDb.Properties("User ID").value = "sysdba"
    hDb.Properties("Password").value = "password"
 hDb.Open

Why does this not work? As I said this worked fine before I changed my
database to SQL Server 2000.

Thanks
Niall


**************************************************************************
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
**************************************************************************