DSN behind the button click event

Hello,

I am trying to connect to Sybase using the odbcConnection and want to put the code in the vb file behind the button click event to retrieve the row of data and put it in the text boxes on the form. I am getting an error on line below. Do I have to use the console to display the data with the datareader or is there a better way. Thank you in advance if anyone can suggest. The actual error is below.

Dim con As New OdbcConnection()
        con = New OdbcConnection("DSN=;Uid=;Pwd=")

        Dim sql As String = "SELECT dbo.Pat.firstName, dbo.Pat.middleName, dbo.Pat.lastName, dbo.Pat.sexCd, dbo.Pat.SSN, dbo.Pat.birthDt, dbo.ExtPat.MRNum" & _
                     "FROM dbo.ExtPat, dbo.Pat WHERE dbo.ExtPat.PID = dbo.Pat.PID AND (dbo.ExtPat.MRNum = '001839995')"

        Dim myCommand As New OdbcCommand(sql, con)
        con.Open()
        Dim myReader As OdbcDataReader = myCommand.ExecuteReader()
        Do While myReader.Read()

        Loop

ERROR [42000] [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Incorrect syntax near '.'.

Re: DSN behind the button click event

sbuggle
ERROR [42000] [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Incorrect syntax near '.'.

Hello

This error means that your syntax is wrongand I strongly suggest you trying to put the sql string into the running timesomething like the SQL Managetment Studio in your Sydatabaseto check whether the sql is wrong or notSo the problem can be solved

Re: DSN behind the button click event

This is Sybase and it works so could it be with the odbc drivers?

Re: DSN behind the button click event

sbuggle

This is Sybase and it works so could it be with the odbc drivers?

Not very surebut I still suggest you downloading the .NET DataBase for ADO.NET providor for that specific databasehttp://www.datadirect.com/products/net/net-for-sybase/index.html