but now, It will not work with Vista 64bit, I know it is to do with being a 64bit operating system , but my question is, what should I change in the above code to get the thing working? Any ideas anybody?
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and we will look into it again. Thanks!
Sincerely,
Kevin Yu
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Mark as Not Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Marked as answer by Kevin Yu - MSFT on Feb 14, 2007 02:19 AM
This was half the battle. Once the application was running in 32-bit mode, there was another step that was needed for ODBC to function correctly. These were outlined at
In addition to running the two commands in the support article, I had to manually add write permissions to the ..\networkservice\AppData\Local\Temp folder for the USER account on my local machine- I assumed the two commands would do this but they didn't.
The IUSR account had write access but the ODBC driver wouldnt function until the USER account had been added- must be some inheritance issue.
Even though this is not a solution for your problem.......it is a similar problem with Linked Tables in a Microsoft Access 2003 database running on Microsoft Vista SP1 6bit.
I thought it would at the very least help someone coming to this thread
-----------orginal messages which was posted
I am having various problems getting my ACCESS 2003 database running on a 64
bit vista SP1(native) installation. This database uses linked tables to a
SQL Server
database hosted on a 64 bit windows 2003 R2 / SQL 2005 64 bit.
Yes, the same MDB/MDE file works on the following systems
Windows XP (32 bit)
WINDOWS XP SP1 (32 bit)
WINDOWS XP SP2 (32 bit)
Windows VISTA (32 bit)
Windows VISTA (32 bit) w/ SP1 installed
Windows VISTA SP1(native) 32 bit
Yes it works on the office versions on the above Operating Systems.
OFFICE XP SP1-SP4
OFFICE 2003 sp1-sp3
OFFICE 2007 SP1
Something is a matter with the ACCESS 2007 application using the ODBC
(linked Table) connections on the ACCESS MDB /MDE file while running on a 64
bit vista platform. (note: it is compiled to work in ACCESS 2003)
What is strange: I can create the system DSN and test the connectivity and
it all works great; until I try running the application.
ERRORS I RECIEVE:
1> Error: ODBC Error: Unknown ODBC Database source ...
2> ODBC - connection to 'DNSNAME' failed
When going to the dataview/table view of the database(not the database
forms). I tried to click on one of the sql linked tables and get the error
"Can't open the table on DataSheet View"
Other strange errors(probably vista related).
1>A potential security concern has been identified - this file might contain
unsafe content that could harm your computer. Warning it is not possible to
determine that this content cam from a trustworthy source.
2>You are logged on with non-administrative privledges. System DSNs could
not be created or modified.
Other strange thing: I created a native ACCESS 2007 application and tried to
created a linked table to the same SQL Database and the system DSNs would not
show up. Only machine DSNs (which I think are system DSNs) and USER DSNs.
But it gave me a security warning anyhow when I tried to create a system dsn
and set I could not do it.
What is up with this???
Thanks,
Doug Lubey of Louisiana
www.douglubey.com
SEARCH ENGINE REFERENCE:
VISTA Microsoft Access Error Unknown ODBC DataSource
http://www.vistaheads.com/forums/microsoft-public-windows-vista-installation-setup/65236-odbc-missing-access-64-bit-vista-ultimate.html
Microsoft Data Access Components Vista 64 bit
Microsoft Access 2007 "Error Unknown ODBC DataSource" VISTA
VISTA Error: ODBC Error: Unknown ODBC Database source
VISTA ODBC You are logged on with non-administrative privledges. System
DSNs could not be created or modified
VISTA ODBC You are logged on with non-administrative privileges. System DSNs
could not be created or modified
VISTA ODBC You are logged on with non-administrative privileges
SYSTEM DSNs could not be created
You are logged on with non-Administrative privledges
You are logged on with non-Administrative privileges
System DSNs non-Administative privileges
System DSNs non-Administrative privileges
Access 2007 System DSNs non-Administrative privileges
ODBC System DSNs VISTA
MICROSOFT VISTA ODBC System DSNs
MICROSOFT VISTA data access components 64 bit
download microsoft data access components 64 bit
mICROSOFT VISTA ACCESS 2007 ODBC 64 BIT
dubsdj
Member
63 Points
221 Posts
Access ODBC and Vista 64bit
Feb 12, 2007 07:28 PM|LINK
Hi, I know this is not a .net question as such but I'm having trouble with my classic asp pages since I upgraded to 64bit ultimate vista.
before, when using 32bit XP I was using code like this:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.mode = 3 ' adModeReadWrite
Conn.ConnectionTimeout = 5
Conn.CommandTimeout = 10
Set Rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("events.mdb")
but now, It will not work with Vista 64bit, I know it is to do with being a 64bit operating system , but my question is, what should I change in the above code to get the thing working? Any ideas anybody?
Kevin Yu - M...
All-Star
19021 Points
1467 Posts
Re: Access ODBC and Vista 64bit
Feb 14, 2007 02:18 AM|LINK
Hi,
This code doesn't work because the Microsoft Access Driver doesn't exist in the the 64bit registry of Windows.
In 64bit Windows, there are 2 branch in the registry, one stored the information used by 32bit components, and the other is for 64bit components.
In this case, you will need to force your application run in 32bit mode (WOW64). Please check the following link for how to do this:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/0aafb9a0-1b1c-4a39-ac9a-994adc902485.mspx?mfr=true
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and we will look into it again. Thanks!
Kevin Yu
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Mark as Not Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
gr0x0rd
Member
4 Points
2 Posts
Re: Access ODBC and Vista 64bit
Feb 23, 2007 10:21 PM|LINK
Hi Kevin,
Thanks for the response- I am having the exact same problem trying to run my classic ASP apps on Vista/IIS6.
When I run the command on the technet page in a command prompt as administrator, I get the following error message:
Type mismatch
ErrNumber: 13 (0xD)
Error Trying to SET the Property: Enable32BitAppOnWin64
Any ideas on how I might resolve this?
Cheers,
~g
anbrad
Member
2 Points
1 Post
Re: Access ODBC and Vista 64bit
Feb 28, 2007 04:30 AM|LINK
You (now?) have to remove the quotes from the arguement True.
cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 True
I still can't create an adodb.connection object though.....
gr0x0rd
Member
4 Points
2 Posts
Re: Access ODBC and Vista 64bit
Mar 13, 2007 01:22 AM|LINK
Hi All,
I was able to find a solution and thought I would post it here in case it helps someone else.
anbrad was correct in his instruction to remove the quotes around "true" in the cscript command outlined at
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/0aafb9a0-1b1c-4a39-ac9a-994adc902485.mspx?mfr=true
This was half the battle. Once the application was running in 32-bit mode, there was another step that was needed for ODBC to function correctly. These were outlined at
http://support.microsoft.com/kb/926939
and brought to light by the following resource
http://mikeplate.wordpress.com/2006/11/24/running-legacy-asp-scripts-on-vista-and-iis-70/
In addition to running the two commands in the support article, I had to manually add write permissions to the ..\networkservice\AppData\Local\Temp folder for the USER account on my local machine- I assumed the two commands would do this but they didn't. The IUSR account had write access but the ODBC driver wouldnt function until the USER account had been added- must be some inheritance issue.
Hope this helps!
~g
lacidian
Member
50 Points
13 Posts
Re: Access MDB ODBC and Vista 64bit can not use the ODBC driver native to Vista 64 bit(you must u...
Aug 13, 2008 02:13 AM|LINK
Even though this is not a solution for your problem.......it is a similar problem with Linked Tables in a Microsoft Access 2003 database running on Microsoft Vista SP1 6bit.
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=VISTA+64+BIT&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access&p=1&tid=ba254694-d9c8-4d07-9675-36003d86db66&mid=ba254694-d9c8-4d07-9675-36003d86db66
I thought it would at the very least help someone coming to this thread
-----------orginal messages which was posted
I am having various problems getting my ACCESS 2003 database running on a 64
bit vista SP1(native) installation. This database uses linked tables to a
SQL Server
database hosted on a 64 bit windows 2003 R2 / SQL 2005 64 bit.
Yes, the same MDB/MDE file works on the following systems
Windows XP (32 bit)
WINDOWS XP SP1 (32 bit)
WINDOWS XP SP2 (32 bit)
Windows VISTA (32 bit)
Windows VISTA (32 bit) w/ SP1 installed
Windows VISTA SP1(native) 32 bit
Yes it works on the office versions on the above Operating Systems.
OFFICE XP SP1-SP4
OFFICE 2003 sp1-sp3
OFFICE 2007 SP1
Something is a matter with the ACCESS 2007 application using the ODBC
(linked Table) connections on the ACCESS MDB /MDE file while running on a 64
bit vista platform. (note: it is compiled to work in ACCESS 2003)
What is strange: I can create the system DSN and test the connectivity and
it all works great; until I try running the application.
ERRORS I RECIEVE:
1> Error: ODBC Error: Unknown ODBC Database source ...
2> ODBC - connection to 'DNSNAME' failed
When going to the dataview/table view of the database(not the database
forms). I tried to click on one of the sql linked tables and get the error
"Can't open the table on DataSheet View"
Other strange errors(probably vista related).
1>A potential security concern has been identified - this file might contain
unsafe content that could harm your computer. Warning it is not possible to
determine that this content cam from a trustworthy source.
2>You are logged on with non-administrative privledges. System DSNs could
not be created or modified.
Other strange thing: I created a native ACCESS 2007 application and tried to
created a linked table to the same SQL Database and the system DSNs would not
show up. Only machine DSNs (which I think are system DSNs) and USER DSNs.
But it gave me a security warning anyhow when I tried to create a system dsn
and set I could not do it.
What is up with this???
Thanks,
Doug Lubey of Louisiana
www.douglubey.com
SEARCH ENGINE REFERENCE:
VISTA Microsoft Access Error Unknown ODBC DataSource http://www.vistaheads.com/forums/microsoft-public-windows-vista-installation-setup/65236-odbc-missing-access-64-bit-vista-ultimate.html
Microsoft Data Access Components Vista 64 bit
Microsoft Access 2007 "Error Unknown ODBC DataSource" VISTA
VISTA Error: ODBC Error: Unknown ODBC Database source
VISTA ODBC You are logged on with non-administrative privledges. System
DSNs could not be created or modified
VISTA ODBC You are logged on with non-administrative privileges. System DSNs
could not be created or modified
VISTA ODBC You are logged on with non-administrative privileges
SYSTEM DSNs could not be created
You are logged on with non-Administrative privledges
You are logged on with non-Administrative privileges
System DSNs non-Administative privileges
System DSNs non-Administrative privileges
Access 2007 System DSNs non-Administrative privileges
ODBC System DSNs VISTA
MICROSOFT VISTA ODBC System DSNs
MICROSOFT VISTA data access components 64 bit
download microsoft data access components 64 bit
mICROSOFT VISTA ACCESS 2007 ODBC 64 BIT