So whatever did happen to this one? I've got the same problem - cannot install any ODBC drivers on Vista 64 with IIS7. All I have is the SQL Server driver and not even installing the AccessDatabaseEngine or the MDACTYP (2.8) will change things.
I need to get a website up that is using an Access 2003.mdb file and I can't get the JET 4.0 engine installed. Tried importing the old.mdb into a new.accdb Acces 2007 file, changed my connection string, still no dice. What am I missing?
VISOCO dbExpress driver for Sybase ASE is a dbExpress driver for Borland Delphi, Kylix, C++ Builder. VISOCO dbExpress driver for Sybase ASE is a dbExpress driver for Borland Delphi, Kylix, C++ Builder. Microsoft ODBC Driver 11 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, SQL Server 2012, SQL Server 2014 and Windows Azure SQL Database.
Please, anyone? I'm having the exact same problem (no MS Access Driver showing up, despite me installing Office 2000 on the machine) and yet when I run Windows SysWOW64 odbcad32.exe I get the same result, which is that I'm told the Access driver hasn't been installed. I'm on Vista (this all worked on my previous machine, which was running Windows XP). I'm at the point where I'm thinking of switching to using MySQL instead of Access, just so that I don't have to figure out what's changed in the O/S on every new machine I get, as that's beginning to get very old, very quickly. Add me to the list. Unable to use ODBC driver on Vista 64. This is ridiculous that this was changed so drastically.
I have tried using the 'other' tool mentioned to configure but it does not work either. If I create a DSN and do a simple test connection it works.
However if I go into VS.net 2008, create a new basic project, add a connection to an access database, it fails with the standard:. Exception Text. System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. At System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal.ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup. That was one of the errors.
However I finally read another post that I did not see before. If anyone is still having problems with this issue, and the 'other' tool does not resolve it for you, then do what I did because it worked. Basically as another post says, change the compiler advanced options from AnyCPU to x86 and then compile! For me that took care of the problem all around so far.
I created a Delphi application which utilizes an ODBC data source to access text files in csv format. The driver is the 'Microsoft Access Text Driver'. But when I deploy my application on a Windows 7 computer it does not work because this driver is not available (there are only two available in odbcad32: sql native client and sql server) How can I install this driver? I have tried to install MDAC, but it doesn't do anything.
No errors or anythinig, but it just shows a quick scroll bar and that is it. And I have heard that MDAC has been replaced by WDAC on Windows 7. EDIT: I should add this is Windows 7 Home, not Professional.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |