Unable to log into the database

From: Robert Bravery (me_at_u.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 09:41:10 +0200

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

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... The fact that the other databases exists phyiscally doesn´t mean that they ... can try to connect to SQL Server using OSL or a GUI. ... The Command OSQL ist for the commandline under DOS. ... > this MSDE either from the Setup or from the SQL2KDeskSP3 execute. ...
    (microsoft.public.sqlserver.msde)
  • Re: Seperate Databases and Business Logic.. SQL vs. .NET code?? Design Ideas/Differences
    ... Say a particular shop has a few critical SQL Databases that are not ... it's been stated that we will not server link. ... and reporting and online can accept day- ...
    (microsoft.public.dotnet.framework.aspnet)