Odbc Excel Driver Login Failed

Posted on by

The login also contains the exact properties of the same login in my old server. When I hit next after entering the username and password I get: Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myUser'. A 64-bit application (e.g. IBM SPSS Statistics 64-bit) cannot use a 32-bit ODBC driver (e.g. Microsoft Office 32-bit Access or Excel ODBC driver). 2) If using the MS-Excel 2.0 ODBC driver, make sure that the driver is setup to read Excel 4.0 worksheet files. Also, make sure that the Excel file is saved as an Excel 4.0 worksheet file. Problem: Customer has configured an Excel ODBC driver to read an Excel 4.0 Worksheet file.

  1. Odbc Excel Driver Login Failed Is Not A Valid Path
  2. Odbc Excel Driver Login Failed Failure Creating File

I guess i'm just using the built in driver. I ran the 2010 access redistributable (not the x64 one) but has made no difference. I have 64 bit pc with 32 bit office. ODBC Microsoft Access Driver Login Failed - Not a Valid Password. Technote (troubleshooting) Problem(Abstract) ODBC Microsoft Access Driver Login Failed - Not a Valid Password. Error: ODBC Microsoft Access Driver Login Failed - Not a Valid Password.

Odbc Excel Driver Login Failed Is Not A Valid Path

Driver
Hi there
I am trying to import external data into Excel from an Access database
(a query), but even though I have full admin/user access/permissions I
keep getting the same error message when trying to connect to the data
source, even after entering the required Login Name and password:
ODBC Microsoft Access Driver Login Failed
You do not have the necessary permissions to use the 'xxxxxxxxxxxx
ABCD.mdb' object. Have your system administrator or the person who
created the object establish the appropriate permissions for you.
The database has a security-enabled workgroup attached to it, and I'm
wondering if this is part of the problem as I don't have this problem
with databases that don't have workgroups attached to them.
We have changed the database's permissions to Owner's via Tools >
Options > Tables/Queries > Run Permissions (have also adjusted the
RunPermissions for the Query to Owner's), but that doesn't seem to
help either.
Does anyone else have any idea why I can't connect? or suggestions as
to how I can get around this problem? It is driving me nuts!
Thanks in advance
Sue

Odbc Excel Driver Login Failed Failure Creating File

Programmers,
Here is the situation: The company I work for has several Excel spreadsheets that are linked to our SQL Server 2000 database via an Access file. All has worked for years until now. When I try to Refresh the spreadsheet for Company3, I get an ODBC Connection Failed Error. Basically, the configuration is as follows:
SQL Server: Database has 3 tables for each company which we will call respectively - Company1, Company2, Company3.
AccessFile.mdb contains linked tables to those tables.
Excel Spreadsheets have a Microsoft Query defined using a Microsoft Access ODBC driver. From there, the linked table
Company3 and its appropriate columns are selected. (it is interesting to note the connection seems to work as it will show the column names when I click (+) to expand the table.) However, as soon I try to run the query, it fails with a ODBC Connection Error.
+++ Note +++ If I select a SQL Server ODBC driver instead of a Microsoft Access ODBC driver in the Microsoft Query Wizard, it will work fine. Data gets refreshed with no problem.
Here is what I have tried and observed:
1. Tested the OBDC connection through the ODBC Datasource Adminstrator. Works fine.
2. In Microsoft Query, selected SQL Server 2000 ODBC Driver.
Refreshed the Excel Spreadsheet. Works as mentioned above.
(The current configuration worked previously using an Access ODBC Driver to the linked SQL table.)
3. Created a new Access database with a link to Company3, thinking maybe the mdb file is corrupt. Still didn't work.
4. I created a new Excel spreadsheet and Microsoft Query to
to the linked table. Same results.
5. Compared the datatypes for Company3 against Company1 and Company2. Looked ok.
6. Copied Company3 into a test table. Tried Refreshing the Excel spreadsheet with Access ODBC Driver and the test table (all records). ODBC Connection failed. I even tried deleting all but one record in the table, but I obtained the same results.
7. Tried SQL Profiler to see if could give any useful information why the conncection failed. All I could find that it was testing the connection, but I could find any information why it failed.
9. Turned on ODBC tracing. Here is a snapshot of the log file:
msqry32 580-eb0 ENTER SQLDriverConnectW
HDBC 00892BD0
HWND 00000000
WCHAR * 0x74329A38 [ -3] '****** 0'
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
msqry32 580-eb0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 00892BD0
HWND 00000000
WCHAR * 0x74329A38 [ -3] '****** 0'
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
DIAG [IM00 [Microsoft][ODBC SQL Server Driver]Dialog failed (0)
msqry32 580-eb0 ENTER SQLErrorW
HENV 00892B58
HDBC 00892BD0
HSTMT 00000000
WCHAR * 0x0012D488 (NYI)
SDWORD * 0x0012D4D4
WCHAR * 0x02417260
SWORD 4095
SWORD * 0x0012D4C0
msqry32 580-eb0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00892B58
HDBC 00892BD0
HSTMT 00000000
WCHAR * 0x0012D488 (NYI)
SDWORD * 0x0012D4D4 (0)
WCHAR * 0x02417260 [ 66] '[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed'
SWORD 4095
SWORD * 0x0012D4C0 (66)
msqry32 580-eb0 ENTER SQLErrorW
HENV 00892B58
HDBC 00892BD0
HSTMT 00000000
WCHAR * 0x0012D488 (NYI)
SDWORD * 0x0012D4D4
WCHAR * 0x024172F6
SWORD 4020
SWORD * 0x0012D4C0
msqry32 580-eb0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00892B58
HDBC 00892BD0
HSTMT 00000000
WCHAR * 0x0012D488 (NYI)
SDWORD * 0x0012D4D4 (0)
WCHAR * 0x024172F6 [ 4 '[Microsoft][ODBC SQL Server Driver]Dialog failed'
SWORD 4020
SWORD * 0x0012D4C0 (4
msqry32 580-eb0 ENTER SQLErrorW
HENV 00892B58
HDBC 00892BD0
HSTMT 00000000
WCHAR * 0x0012D488 (NYI)
SDWORD * 0x0012D4D4
WCHAR * 0x02417368
SWORD 3963
SWORD * 0x0012D4C0
msqry32 580-eb0 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 00892B58
HDBC 00892BD0
HSTMT 00000000
WCHAR * 0x0012D488 (NYI)
SDWORD * 0x0012D4D4
WCHAR * 0x02417368
SWORD 3963
SWORD * 0x0012D4C0
msqry32 580-eb0 ENTER SQLFreeConnect
HDBC 00892BD0
msqry32 580-eb0 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 00892BD0
msqry32 580-eb0 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 00891B18
DIAG [S1000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'CompanyDatabase' failed. (-2001)
Not sure what is causing this error. I am leaning that it has to so some thing with the table (Company3) itself. Permissions? Any assistance on issue would be greatly appreciated.
By the way, does anyone know why sometimes you get a login dialog when you open a datasource and sometimes not?

Testing center utd. Gallatin Driver Services Center Office Address To make an appointment for a non-commercial road skills test, please click Online Driver Services or call 866-849-3548.