Re: Invalid Enum Value

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/21/05

  • Next message: Gilbert: "noise from Tmediaplayer" 
    Date: Sun, 20 Feb 2005 20:02:13 -0600

    > have a small Database application that worked fine but
    >I suddenly get this error message (Invalid Enum Value) when I click on my
    >ADOConnection.
    >I can't do anything at all any more? I can't even save my project.
    >
    >The Access2000 database (*.mdb) contains 3 tables.
    >1 ADOConnection, 3 ADOTables, 3 Datasources.
    >(Win2k, Delphi6 Pro)
    >
    >I must have set something that wasn't any good, but I cant find it!
    >What can be wrong?...

    I have seen this before in a connection string for JET when values for MODE are
    selected that are incompatible.
    If that isn't your problem post your connection string. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Gilbert: "noise from Tmediaplayer"

    Relevant Pages

    • Re: Connecting to a sql server database
      ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
      (microsoft.public.dotnet.general)
    • Re: Invalid SQL statement; expected DELETE, INSERT, PROCEDURE
      ... > When you get it installed, you'll want to change the connection string to ... > use the native Jet OLEDB provider. ... why is this error message ... > quicker response by posting to the newsgroup. ...
      (microsoft.public.inetserver.asp.db)
    • Re: Connecting to a sql server database
      ... > line numbered code where the connection string is shown). ... > sql server, hence integrated security fails. ... >> causing the error message and what the correction for this. ...
      (microsoft.public.dotnet.general)
    • RE: Wondering why the following ADO connection to Access isnt working
      ... When does it fail and what error message are you getting? ... Set MYdb as New ADODB.Connection)? ... Some general troubleshooting guidelines I use with ADO: ... - Make sure you have the connection string correct. ...
      (microsoft.public.excel.programming)
    • Re: Error Type: ADODB.Command (0x800A0BB9)???
      ... The humnid air has my mind frazzled, the connection string was messed up.... ... > What is the TEXT of the error message? ... > Why are you doing ASP work inside an .HTM page? ...
      (microsoft.public.inetserver.asp.db)