login fails

[mt]

Hello everyone:

I am using vb.net 2002, msde2000 database, and windows 98,and i set up .net
framework 1.1 and MDAC 2.7 and msde2000
i have a problem,i want create database with vb.net on windows98,for my
sqlconnection string is "server=(local),database=,integrated security=sspi"
but when runtime sqlconnection exception "login fails" ,what ý must do?
Thanks

[Cor]

Hi Mt,

Here are 2 sites with connection strings, take a look for that first.
http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps a little bit?

Cor

I am using vb.net 2002, msde2000 database, and windows 98,and i set up ..net framework 1.1 and MDAC 2.7 and msde2000
i have a problem,i want create database with vb.net on windows98,for my
sqlconnection string is "server=(local),database=,integrated security=sspi" but when runtime sqlconnection exception "login fails" ,what ý must do?

[One Handed Man]

I suggest you put the connector onto the form and use the wizard to make
your string for you, its easier that way. Once you have the right connection
string you can remove the connector and code it yourself.
OHM

[Ken Tucker [MVP]]

Hi,

Try changing (local) to the machine name\msde name (the default
install with vs.net is MachineName\VSdotNet). Second you are using a ,
where there should be a ;. Not sure if SSPI works with win98 might have to
replace integrated security = sspi; with user id = sa; password = 'your
password'; (blank by default should change if is)

Dim strConn As String

strConn = "Server = " & Environment.MachineName

strConn += "\VSdotNET; Database = ; Integrated Security = SSPI;"

conn = New SqlConnection(strConn)

Ken

-----------------------

"mt" <ml*@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hello everyone:

I am using vb.net 2002, msde2000 database, and windows 98,and i set up ..net framework 1.1 and MDAC 2.7 and msde2000
i have a problem,i want create database with vb.net on windows98,for my
sqlconnection string is "server=(local),database=,integrated security=sspi" but when runtime sqlconnection exception "login fails" ,what ý must do?
Thanks

[Herfried K. Wagner [MVP]]

* "mt" <ml*@hotmail.com> scripsit:

I am using vb.net 2002, msde2000 database, and windows 98,and i set up .net
framework 1.1 and MDAC 2.7 and msde2000
i have a problem,i want create database with vb.net on windows98,for my
sqlconnection string is "server=(local),database=,integrated security=sspi"
but when runtime sqlconnection exception "login fails" ,what ý must do?

<http://www.connectionstrings.com>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Chris Dunaway]

On Fri, 7 Nov 2003 10:47:13 +0200, mt wrote:

I am using vb.net 2002, msde2000 database, and windows 98,and i set up .net
framework 1.1 and MDAC 2.7 and msde2000

In addition to what the others have posted, I would point out that VB.Net
2002 cannot use the .Net framework 1.1. So if you're trying to use any 1.1
features in your code, it wont work correctly.

--
Chris

To send me an E-mail, remove the underscores and lunchmeat from my E-Mail
address.

[Fergus Cooney]

Hi OHM,

Try this link and tell me what's wrong with what you see!
http://tinyurl.com/u5g4

Regards,
Fergus

[One Handed Man]

OK, fair enough, thanks for the pointer !

Regards OHM

Fergus Cooney wrote:

Hi OHM,

Try this link and tell me what's wrong with what you see!
http://tinyurl.com/u5g4

Regards,
Fergus

[Fergus Cooney]

Good morning OHM,

No worries. We can't have your pearls being misplaced by Google! ;-)

Regards,
Fergus