Database VB.Net problem

[humbleFunGuy]

Private Sub writeDatabase(ByVal filePath As String, ByVal action As
String)
Dim cnn As SqlConnection
Dim cmd As SqlCommand
Dim sqlStr As String
Dim connStr As String
connStr = "User ID=user;Password=user;Initial Catalog=file;" _
& "Data Source=(database.server.com)"
sqlStr = "insert into folderWatch values('filePath', 'action')"
cnn = New SqlConnection(connStr)
cnn.Open()
cmd = New SqlCommand(sqlStr, cnn)
cmd.ExecuteNonQuery()
cmd.Dispose()
cnn.Close()
End Sub
I am having problem with this code. I get unhandled execption when
cmd.executeNonQuery() is executed. I am not sure what I am doing
wrong.

Thanks,
irfan

[dfoster]

On 2005-08-28, humbleFunGuy <im**********@hotmail.com> wrote:

Private Sub writeDatabase(ByVal filePath As String, ByVal action As
String)
Dim cnn As SqlConnection
Dim cmd As SqlCommand
Dim sqlStr As String
Dim connStr As String
connStr = "User ID=user;Password=user;Initial Catalog=file;" _
& "Data Source=(database.server.com)"

That's just "Data Source=database.server.com".

"(local)" is a special keyword recognized by the sql server driver.
Except when connecting to a local db, you don't want parentheses around
the data source.

[Cor Ligthert [MVP]]

humple,

Try to see your exception, I changed your code a little bit, and deleted as
well a lot what was a little bit unneeded. I did it in this message so watch
typos.

\\\
Private Sub writeDatabase(ByVal filePath As String, ByVal action As
String)
Dim cnn As SqlConnection("User ID=user;Password=user;" & _
"Initial Catalog=file;" & _
"Data Source=(database.server.com))"
dim sqlStr as string = "insert into folderWatch values('filePath',
'action')"
dim cmd as New SqlCommand(sqlStr, cnn)
Try
cnn.Open()
Try
cmd.ExecuteNonQuery()
Catch ex as exception
messagebox.show("Query error: " & ex.tostring)
'this has to be a better procedure to handle by instance concurrency
End try
Catch ex as exception
messagebox.show("Connection error: " & ex.tostring)
Finally
cnn.Close()
End Try
End Sub
////

I hope this helps,

Cor

[humbleFunGuy]

Cor,
I tried to print the error message to console and it says "server does
not exist or access denied". I have verified the i have right user id
and password and server is accessible. I have web application
accessing same server and they are working. I am not sure what is the
problem with VB.Net application.

[Cor Ligthert [MVP]]

Humble,

That means that there is something with Server or the most likely your
connection string.

Try the most simple ones
http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

I hope this helps,

Cor

"humbleFunGuy" <im**********@hotmail.com> schreef in bericht
news:11**********************@g47g2000cwa.googlegr oups.com...

Cor,
I tried to print the error message to console and it says "server does
not exist or access denied". I have verified the i have right user id
and password and server is accessible. I have web application
accessing same server and they are working. I am not sure what is the
problem with VB.Net application.

[Chris]

humbleFunGuy wrote:

Cor,
I tried to print the error message to console and it says "server does
not exist or access denied". I have verified the i have right user id
and password and server is accessible. I have web application
accessing same server and they are working. I am not sure what is the
problem with VB.Net application.

Try putting the IP in for the Data Source. Also, I've never seen "(..)"
around the data source, but that doesn't mean it's not right... I just
never use it. There is something wrong in your connection string
though, so that's what you got to fix. Make sure you can ping the
server as well.

Chris

[dfoster]

On 2005-08-28, humbleFunGuy <im**********@hotmail.com> wrote:

Private Sub writeDatabase(ByVal filePath As String, ByVal action As
String)
Dim cnn As SqlConnection
Dim cmd As SqlCommand
Dim sqlStr As String
Dim connStr As String
connStr = "User ID=user;Password=user;Initial Catalog=file;" _
& "Data Source=(database.server.com)"

That's just "Data Source=database.server.com".

"(local)" is a special keyword recognized by the sql server driver.
Except when connecting to a local db, you don't want parentheses around
the data source.

[humbleFunGuy]

I used the exact same connection string and created C# project and it
worked fine. I am not sure why VB.Net did not work for me.

Thanks for helping.
Irfan