Re: Unable to log into the database

From: Ken Tucker [MVP] (vb2ae_at_bellsouth.net)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 08:06:22 -0400

Hi,

        There is a class on the mysql site for connection to a mysql with
.net. Try that.
http://dev.mysql.com/downloads/connector/net/1.0.html

Ken
-------------------------
"Robert Bravery" <me@u.com> wrote in message
news:%23CtRkl4pEHA.3324@TK2MSFTNGP15.phx.gbl...
Hi all,

I am using VS.net 2003, and VB. I am new to VB programming.
I am trying to connect to a database on a server on our network. There are
two databases one is Interbase, and the other is MYSQL. Both are being
accessed via odbc. I can open the connections in the server explorer connect
to the databases and view the tables. I can even view and retrieve data in
theserver explorer.
But when I try and connect to the databases in my application, I get an
error message "Unable to log into database", this is with Interbase, and
with mysql i get this errormessage "There were errors configuring the data
adapter."
Whether I try and drag the tables from the server explorer to the form, or
drag a dataadapter and dataconnection, and try and manual configure them, I
get theses error.
Now here is the strange thing. If I set up the databases locally, the
connections work perfectly in my app.
THis leads me to believe that it is a security iss. But I do not know where
to look, or what to look for. THe connection strings, userid, passwords are
exactly the same for both server and local machines. I am unaware of any
other security issue that need changing when designing a app and connecting
to a database.

THanks
Robert

Relevant Pages

  • closing connections
    ... I have a VB .NET program that uses ADO SqlClient dataadapters and MS SQLS. ... It uses the Master db to return the names of attached databases, ... The problem I am having is closing my connections. ... Dim cnn As SqlConnection = New SqlConnection ...
    (microsoft.public.data.ado)
  • Re: Number of concurrent users
    ... limited to 10 connections. ... local copy of the frontend (forms, queries, reports, code) that is stored on ... My applications link to 10 backend databases to generate the reports. ...
    (microsoft.public.access.formscoding)
  • Re: Unable to log into the database
    ... two databases one is Interbase, ... I can open the connections in the server explorer connect ... THis leads me to believe that it is a security iss. ...
    (microsoft.public.vb.database.ado)
  • Unable to log into the database
    ... I am trying to connect to a database on a server on our network. ... two databases one is Interbase, ... I can open the connections in the server explorer connect ...
    (microsoft.public.vb.database)
  • Unable to log into the database
    ... I am trying to connect to a database on a server on our network. ... two databases one is Interbase, ... I can open the connections in the server explorer connect ...
    (microsoft.public.vb.database.ado)