|
i want to Synchronize my local database with remote database but i have to face problem in login
i m writing my connection string here, it opens the database but when i want to retrieve database, it gives me error login failed computername/guest
while my login name is not guest.....i have no account with the name guest.
/*************************************************************************/
Private Sub btnButton2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnButton2.Click
'Dim flag As Boolean = Me.ChkValidIP(Me.txtTextBox2.Text)
'If flag = True Then
Dim CS As String = "Network Library=DBMSSOCN;" & _
"Data Source=10.0.0.15,1433;" & _
"Initial Catalog=REIMSCDB;" & _
"User ID=sa;" & _
"Password= ;" & _
"Trusted_Connection=yes;"
Dim con As SqlConnection = New SqlConnection(CS)
Try
If con.State.Open Then
Dim sqlDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM LoginAccount", con)
Dim ds As DataSet = New DataSet
sqlDA.Fill(ds)
If Not ds Is Nothing Then
Dim dr As DataRow = ds.Tables(0).Rows(0)
MessageBox.Show(Convert.ToString(dr("LoginID")))
End If
MessageBox.Show("Done")
con.Close()
Else
MessageBox.Show("false")
End If
Catch oexp As System.Data.SqlClient.SqlException
MessageBox.Show(oexp.Message)
Finally
con.Close()
End Try
'End If
/*************************************************************************/
please try this code and send me solution if you know about this.
RAK
|
|
|
|
|
Try switching the Trusted_Connection=yes to Trusted_Connection=no. And please, please use a login id other than sa.
my blog
|
|
|
|
|
i tried all posibilities of login but it don't work send me another solution of it
|
|
|
|
|
i need a combo box just like use in
OutLook express--->
Contacts--->
New Contact ---->
Email : Combo box Diaplay
Please open the outlook express and see the new contacts if you know help me
RAK
|
|
|
|
|
I think it's a menu, not a combobox
|
|
|
|
|
That's a menu, not a ComboBox...
All it is is a menuitem with a little down arrow icon next to it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How can I create an XML document as a result of Visual Basic code compilation?
|
|
|
|
|
What do you mean? The VB.NET Compiler doesn't output any XML documentation if that's what your talking about. At least not until VB.NET 2005 or Visual Studio .NET 2005...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you 
|
|
|
|
|
what do you mean?
"cheese"
|
|
|
|
|
i have created a dataset which is bound to the database noe i want to bind the DATAGRID on the form but the problem is that i don`t want all the columns of the table i only want 3 COLOUMNS and i don`t want even to create a query on dataset i.e i want whole of the table in the datset now how should i bound datagrid coustomisely, is there any method???
sm
|
|
|
|
|
Can I do my own dll with VB?
Pablo.Ar
|
|
|
|
|
Yes, Select ActiveX dll as the new project type. When you select 'make exe' from the file menu when you are finished it will compile the project as a dll.
Jon
|
|
|
|
|
yeah, I had already tried that (I should´a mention it), but when I compiled and tried to 'use' the .dll (like an api) from another one of my proj´s, there was an error that read 'There is no insertion point for my_1st_dll.dll', or sth of the like.
Well, 10x for the interest j15, any other ideas?
Pablo.Ar
|
|
|
|
|
Have you tested the dll by adding the project to a project group with just a test form? I would test like this first, then if all seems ok i would re-compile the dll and dont forget to regsvr32 it (should not need this as i think the process of compiling does this but it wont hurt)
Jon
|
|
|
|
|
oooooh, thanks for reminding me of regsvr32!!! I think that´s what it´s been all about. Well, I´ll try that (...and testing the dll from a vbg) and tell you about it later. Thanks a million.
Pablo.Ar
|
|
|
|
|
Hi all,
Is there any way to find out if a word is a reserved keyword of SQL Server with .NET? Or how can I retrieve all the reserved keywords of SQL Server?
Thanks.
Frank
|
|
|
|
|
There is no way to get SQL Server to return all the reserved words. You'll have to put a table together and type them in from the documentation.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi coders
I'm very new to coding and desperately need some help
I am writing a small Internet cafe type program that controls internet access. It works fine by stopping the process "iexplorer". however users can still access internet via other applications and windows-explorer (explorer.exe). I can close any programs started after my application, but i cannot work out how to control / close explorer without forcing shut down. On my machine I can check if explorer has a mainwindowtitle and then process.closemainwindow. This works fine on my machine but on some other machines closing explorer (even if it has a visible open window) forces a shut-down.
any advice on:
a. ways to hide or restrict explorer
c. why my explorer launches a new visble process and others dont (i have set folder options "launch in seperate process" )
b. ways to deny access to Internet via any method
please help
|
|
|
|
|
check out this link it may help
http://www.winguides.com/registry/display.php/1288/
"Small Men Standing on Giants Is Better Than Giants Standing on Small Men"
|
|
|
|
|
I am working in Whidbey (VStudio 2005) using Visual Basic. I am trying to create a picture box that is simply a light transparent yellow (kind of like a highlighter) where I can see the controls, images, etc... that are underneath.
I was able to do this in VB6, but can't seem to figure it out in Whidbey. Anyone know how to do this?
Thanks!
|
|
|
|
|
I have the following code where I want to delete a directory that might have multiple levels of sub-directories and multiple files and additional folders within each directory.
Try
Dim strToDir As String = "c:\test"
If Directory.Exists(strToDir) Then
Directory.Delete(strToDir, True)
End If
Catch ex As Exception
MsgBox("Error: " & ex.Message)
End Try
When one of the files anywhere within the directory that I am deleting is read-only, I receive the following error:
Error: Access to the path "IamReadOnlyHaHa.txt" is denied.
Is there any way around this error?
Thanks in advance for any input you might have... 
Lost in the vast sea of .NET
|
|
|
|
|
Access Denied would indicate that you don't have the rights to delete that file, not that it is ReadOnly. There is no way around that kind of a problem because of security other than getting the account that your app is running under the proper rights.
It is possible to delete a ReadOnly file if it's attribute in the directory are ReadOnly. The Delete method will still delete the file without any problems if this is the case.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If I change the read-only attribute on the file to no longer be read-only and I rerun the process it works fine. I've had this application running for a couple of months and the only time it errors out is when a read-only file is put in the directory the app is trying to delete.
Like I said the app has no problem deleting normal attribute files, but read-only files it errors out. Maybe the security is causing an issue on read-only files being deleted. I'll test the app locally and see if I receive the same results.
Thanks 
Lost in the vast sea of .NET
|
|
|
|
|
It wasn't security related at all. Below is a link to the suggested code I received on another message board. This code worked great and solved the problem entirely.
http://www.gotdotnet.com/Community/MessageBoard/Thread.aspx?id=259421&Page=1#259432
Thanks for the reply! Every bit of input helps...
Lost in the vast sea of .NET
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
