Community

Question

Gravatar
Locked

Is it possible to open a connection inside a windows service?

By jeffreyalejo ·
Good day TR community! I created a windows service (vb.net) which reads the content of a DBF file table and import it to a MySQL table. The problem occurs at the line where I'm trying to open the connection between DBF and vb.net. Here's the code I've been using:

Dim conn As OdbcConnection = Nothing
Dim comm As OdbcCommand = Nothing
Dim connectionString As String
Dim sql As String

connectionString = "DSN=dbfconn"
sql = SELECT * FROM TableName.DBF

conn = New OdbcConnection(connectionString)

conn.Open() --THIS IS WHERE THE PROBLEM OCCURS

comm = New OdbcCommand(sql, conn)
dr = comm.ExecuteReader()

InsertToMySQL --SUB ROUTINE FOR INSERTING dr TO MYSQL TABLE

conn.Close()
dr.Close()
comm.Dispose()
conn.Dispose()

These line of codes runs smoothly in a window based application (vb.net), but having problems when used in a windows service application (vb.net). I began to wonder if it's really possible to open a connection between DBF and VB.net inside a windows service.

Any help is highly appreciated. Thank you!

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

Back to Community Forum
1 total post (Page 1 of 1)  

Start or search

Related Forums