SQL db access

Results 1 to 3 of 3

Thread: SQL db access

  1. #1
    Corin Guest

    Default SQL db access

    I converted to a SQL database from ACCESS now I have the following problem when i try to run the page.<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e4d&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user &#039myUserName&#039. <BR><BR>/kleinSQL/dealers/dealerresults.asp, line 65 <BR><BR><BR>My code looks like this<BR><BR>Dconn.Open "DRIVER=SQL SERVER;UID=myUserName;PWD=myPassword;SERVER=BAMF;D ATABASE=testSQL"<BR><BR>I have added the user to the database and still get the error<BR>

  2. #2
    Bill Stride Guest

    Default RE: SQL db access

    If you use that id and password on the SQL console apps, do you get in?<BR><BR>Bill<BR>

  3. #3
    Corin Guest

    Default Still don't work

    Yes I can get in through the Enterprise manager. I have granted that user every possible permission in NT and SQL server I can think of and it still does not work

Posting Permissions

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