RE: ODBC--Connection to 'Database' failed



Have you defined on your ODBC connection the database you working with?
Check the odbc in your administrative tool in windows for your odbc
connection, when you define it, define it to work with authentication, that
way it wont ask for password.

I work with SQL server, I hope you need the same setting.


"smcash" wrote:

> My co-worker and I both use the same computer, depending on who needs it. He
> logs into the computer under his own username, accesses the network, opens
> this .mdb file, and runs a query, and it works for him. At a certain point it
> asks him for his password, and he enters the password which he uses for
> "Banner", which is an application we use to manage the very same database
> information that this .mdb file contains. I believe the tables are actually
> part of a different database (Oracle, I think), and are only linked to by the
> .mdb. Anyway, it works fine for him. When I log in under my username and open
> the same file and try to run the same query, I get this error:
>
> ODBC--Connection to 'Database' failed
>
> It never even asks me for my password. What am I doing wrong?
.



Relevant Pages

  • Re: Nameless CREATE
    ... The starting point is either an existing database or one that is ... "Describe" involves issuing an SQLDescribeCol function to ODBC ... essentially much the same as character data type apart from all 8 bits ... ALTER TABLE tablename ADD COLUMN BinaryColumn BINARY ...
    (comp.lang.forth)
  • Re: fields queries and utter disaster
    ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... of course supports ODBC connections but Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • RE: Unable connect to sybase database
    ... Turn it off if you are on a corporate network. ... Recreate the odbc connection and see if it works. ... Or else you can go for OLE DB Providers to connect to the database. ... OLE DB is an advanced protocol and much better than ODBC. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: How to create a new Ms Access file
    ... then you should consider using the Jet extensions for ADO - aka ... table to a newly created database, and in that table there is one autonumber ... I want to create new .mdb file on harddisk and then ... > connect to it by ODBC. ...
    (microsoft.public.vc.language)

Loading