No, it isnt set to Windows autentication only. What is the new security
context for 2000?

-----Original Message-----
From: Stuart Naylor [mailto:indtec@e...]
Sent: 16 August 2002 17:20
To: professional vb
Subject: [pro_vb] Re: sql server 2000 connection


The default security context of SQL changed from 7.0 to 2000.

Is the server set to Windows autentication only?
----- Original Message -----
From: "Niall Hannon (ext. 772)" <Niall.Hannon@f...>
To: "professional vb" <pro_vb@p...>
Sent: Friday, August 16, 2002 11:59 AM
Subject: [pro_vb] sql server 2000 connection


> Hi,
>
> Bit of a bother here - 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 = "xxx.xxx.xxx.xxx"
>     hDb.CommandTimeout = 10
>     hDb.Properties("Network Library").value = "dbmssocn"
>     hDb.Properties("Data Source").value = "xxxx"
>     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
> **************************************************************************
>
>
>
> ---
> 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
>
>



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