Results 1 to 3 of 3

Thread: MySQL on-line not connecting to one user

  1. #1
    J Trahair is offline VB.NET Forum Genius
    .NET Framework
    .NET 3.0 (VS 2005/2008)
    Join Date
    May 2008
    Location
    Spain
    Posts
    174
    Reputation
    113

    MySQL on-line not connecting to one user

    I have a VB.Net application which runs on the local machine and connects to an on-line MySQL database. I have successfully used the connection string to access the on-line MySQL database on my development machine since May 2016, and other customers in the UK and Italy have successfully connected for several months on their computers. However, a new user has tried to connect and cannot, even though they use the same connection string as all the others. What reasons are there for this behaviour, has anyone had a similar experience? This user runs Windows 10 (along with some of the other users).

    Here is a snippet from the fail point. Please assume everything works up to this point on the rogue computer, and works past this point on all other users machines.

    Code:
            Dim objConnFST As MySqlConnection
    
            Try
    
                mstrSQLConnectionString = "server=1230.456.789.000;Port=3306;uid=customer99;pwd=hello;database=clientdatabase"
    
                objConnFST = New MySqlConnection(mstrSQLConnectionString)
    
                objConnFST.Open()        '<<<<<<<<<<fails here.
    
                mstrSQL = "SELECT * FROM ExpiryDate "
                mstrSQL = mstrSQL & "WHERE RecNo = 1"
                mstrSQL = AddFSTCustomerIDAndEncryptStringData(mstrSQL)
    
                Dim cmd As New MySqlCommand(mstrSQL, objConnFST)
    
                Dim dr As MySqlDataReader
    Thanks for you help.

  2. #2
    jmcilhinney's Avatar
    jmcilhinney is offline VB.NET Forum Moderator
    .NET Framework
    .NET 4.0
    Join Date
    Aug 2004
    Location
    Sydney, Australia
    Posts
    13,798
    Reputation
    1704

  3. #3
    J Trahair is offline VB.NET Forum Genius
    .NET Framework
    .NET 3.0 (VS 2005/2008)
    Join Date
    May 2008
    Location
    Spain
    Posts
    174
    Reputation
    113
    The error message says:
    Reading from the stream has failed
    There's more on the attachment.alessandro.PNG

    Thanks.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •