1
vote
2answers
603 views

make microsoft access use TCP/IP instead of Named Pipes

I got a Microsoft Access database which is constantly trying to contact the corresponding Microsoft SQL Server using named pipes, even though only TCP/IP is available and the ODBC is configured to use ...
0
votes
1answer
226 views

Confused with creating an ODBC connection, apparently I have two separate odbcad32.exe files?

Alright, this is my first time working with this so forgive me if I'm a little confusing or vague. I have a server with Windows Server 2008 Standard without Hyper-v (6.0, Build 6002). I'm running a ...
0
votes
0answers
718 views

[Microsoft][ODBC Driver Manager] Invalid string or buffer length (HRESULT: 80131500)

I am having an intermittent problem with a Spotfire Server accessing information models which connect to Microsoft Access databases via ODBC. The server is a Windows Server 2008 R2 64bit, we have ...
0
votes
1answer
301 views

Create ODBC Connection from Access to SQL Server

I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
0
votes
1answer
3k views

The 32-bit ODBC client for MS-access does not work and installing the 64-bit client is not allowed, what to do?

I have a 64-bit Windows 7 laptop that I use for development. I have office 2003 installed, because I have a client that works with Office 2003. Microsoft Access is not installed, because it's my ...
0
votes
1answer
982 views

Can I create an oracle ODBC driver without installing the Oracle Client?

recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't ...
1
vote
3answers
983 views

Is Access connecting to a remote Postgresql database via ODBC usable?

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking ...