can not get odbc connection to work

Ljhopkins

I have created an machine odbc connection called MITRON, I am trying to write queries and updates, but I cant get the connections to work.

Dim conn As String = "DRIVER=(MySQL ODBC Driver);SERVER=svrhou04=mitron;UID=pqm;PWD=pqm;OPTION=16427;"

Dim sqlconn As New Odbc.OdbcConnection(conn)

Dim sql As String = "Select * from area"

Dim sqlcommand As New OdbcCommand(sql, sqlconn)

sqlcommand.CommandTimeout = 0

Dim myadapter As New OdbcDataAdapter(sqlcommand)

Dim ds As New DataSet

myadapter.Fill(ds)

Dim rowcnt As Integer

rowcnt = ds.Tables(0).Rows.Count.ToString()

vtortola

Are you sure that this is the correct connection string

http://www.connectionstrings.com/ carrier=mysql

Regards.

nobugz

The server name doesn't look good.

PMcGowan

I see you are using PQM, do you still use this

We use this as well and are trying to upgrade to Server 2003 and Oracle 9i.

We are having problems.

Do you know much about PQM Since there is no support I was hoping to find other users that may be able to help.