[AccessD] Windows 7 64 bit

Gustav Brock gustav at cactus.dk
Fri Jan 22 16:22:11 CST 2010


Hi Drew

You mean ON? Or did I get this mixed up? Eh?

/gustav


>>> DWUTKA at marlow.com 22-01-2010 18:04 >>>
They have the split tunneling policy of the .pcf turned off.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, January 22, 2010 10:53 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Windows 7 64 bit

Hi Drew

Strange. My colleague runs a Cisco VPN client to gain access to a
client's network. But doing so doesn't block anything else for her.

/gustav


>>> DWUTKA at marlow.com 21-01-2010 23:28 >>>
Yes.  That's called split tunneling.  Split tunneling is where a VPN
connection allows one networks traffic to travel through the VPN tunnel,
and the rest through the user's gateway.  Companies (like mine) will
usually setup a NO split tunneling policy, because split tunneling is a
security hole (though a pretty rough one to get through).

The Shrew VPN client does let you get around the split tunneling policy,
at least it did for our network.  To do this, you have to go to the last
tab in the properties of the connection you import from the .pcf file.
That last tab is 'Policy'.  There is an option saying something about
network topology and tunneling.  It will be checked.  Uncheck it.

Now the fun part.  Once unchecked, you now have to tell the VPN client
what traffic needs to go through the VPN tunnel.  There is an add
option.  So let's say the network you are going to is 192.168.0.0
through 192.168.0.255 (a small network).  You would click add, it should
default the item to Include (which means it will include that traffic in
what goes through the tunnel), then you would put in 192.168.0.0 for the
IP address and 255.255.255.0 for the subnet mask.  And that would do it.

A larger network requires a larger subnet mask.  So you need to know
what the IP addresses are for the network you are connecting too, and
their range.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Wednesday, January 20, 2010 3:57 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Windows 7 64 bit

Hi Drew,

Thanks for the info about the VPN call Shrew.  I also use Cisco VPN with one
client, and would like to upgrade to W7 64.

When I use Cisco, it completely blocks all my internet access (unlike two
other VPN clients I have).  Does Shrew allow internet access while it's connected?

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, January 20, 2010 3:42 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Windows 7 64 bit

There's been some talk about Windows 7 on here, and since it going to be
hitting your user base, I figured I would share some 64 bit info.

I've been running 64 bit on my work desktop for about 2 years now.
(Vista until October when 7 was actually released).  I've now been
running 64 bit on my laptop for the last 3 months.

>From our user's standpoint, there were two issues that we had with 64
bit.  Oracle ODBC connections, and our Cisco VPN.  Everything else we
install on a typical machine works just fine on a 64 bit box.  There are
some 'admin' things that don't work in 64 bit, but I don't care much
about that, cause I use Virtual PC like it's my right arm, so I just
have that stuff in a VPC environment.

The Oracle thing was a show stopper though.  Our production database
(Glovia) is running in an Oracle database.  It used to be a Unix box,
but is now on a Window's based rack server.  The application for our
production database works just fine in a 64 bit environment, and doesn't
use an ODBC connection.  However, long before I got here, they were
using Access as a 'report engine' for Glovia.  So there are a handful of
these databases that need to connect to Oracle through an ODBC
connection, for all these reports to work.  

Problem #1.  Oracle doesn't make a 64 bit ODBC driver.  They do however
have ODAC101040.exe  which is an ODBC driver for Oracle 10g.  When
trying to install this several 'unknown' errors come up, and the install
fails. However, you can right click on it and select Troubleshoot
Compatibility, this then goes and let's you run the install without a
hitch.  Once that is done, the next trick is that the ODBC manager in
the control panel is a 64 bit manager.  To use the 32bit manager, you
have to go to C:\Windows\SysWOW64\odbcad32.exe .  Looks the same, but
this will then let you setup your ODBC connection.  Now, I got this part
done months ago, but ran into the next problem.

Problem #2.  I could 'test' the connection from the 32 bit ODBC
connection manager, successfully, but whenever I tried to use the ODBC
connection from Access, I would get 'ODBC Error'.  Sigh.  Well a few
weeks ago, an order was placed for a laptop for one of our accounting
people that I wanted to setup with a very decent laptop.  It came in
last week, but I was hesitant to put Windows 7 64 bit on it, because she
uses these ODBC tables all day long, and I didn't want to force her to
use a Remote Desktop session to a machine that had everything
working...so I dug into some more research, and guess what....the
problem was in WHERE Access was installed too.  On a 64 bit machine, 32
bit programs get installed (by default) to C:\Program Files (x86)\  and
those parenthesis' were tripping a bug in Oracle, cause apparently
whatever app tries to connect to the ODBC connection is sending along
it's full application path.  On my own desktop, by just moving
msaccess.exe to the root of one of my drives, the ODBC stuff started
working right away! Go figure!

The other 64 bit issue was the Cisco VPN client.  Apparently Cisco
refuses to make it's standard VPN client compatible with 64 bit
technology (which is weird, because Cisco is supposed to be so 'cutting
edge'...LOL).  So I found http://www.shrew.net/home a FREE 3rd party app
that let's you use Cisco .pcf files for configurations, and it connects
like a charm!  Woohoo.

Drew





More information about the AccessD mailing list