469,927 Members | 1,803 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

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

Nov 20 '05 #1
8 1070
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?

Nov 20 '05 #2
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
Nov 20 '05 #3
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

Nov 20 '05 #4
* "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>
Nov 20 '05 #5
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.
Nov 20 '05 #6
Hi OHM,

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

Regards,
Fergus
Nov 20 '05 #7
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

Nov 20 '05 #8
Good morning OHM,

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

Regards,
Fergus
Nov 20 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Shor Erez | last post: by
reply views Thread by kevincw01 | last post: by
1 post views Thread by Mythran | last post: by
10 posts views Thread by Pete | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.