ODBC Connection Recognition

garcost

New Member
Joined
Nov 16, 2005
Messages
2
Hi,

I work for a large corporation with offices across the U.S.A., and build
Excel files that are used to extract and format data coming from my SQL
server. Our offices are connected via high speed intranet and earlier this
year everyone received new HP computers. After the new PC's arrived I sent
out instructions on how to setup the ODBC connection needed to access the SQL
data and everything was working fine until recently.

The program that I have recently sent out to the field is experiencing
connection recognition problems where even thought the ODBC connection is
listed in the "USER DSN" menu, the program still wants the user to select the
connection by clicking on it, click OK, and then when the Login and Password
menu pop up click OK again before it will establish the connection.

When we first started experiencing problems we found that if we "Unchecked"
the use ANSI boxes the program worked fine again for about a week, but we are
now back to square one by getting the problem described above. This has me
baffled as I'm not sure if it's a problem with my PC when I'm building the
program, an ODBC problem, or server problem. Our IT department is constantly
pushing upgrades to our PC's and I'm wondering if it it's an update that has
caused the problem. Any time we check the configuration of the ODBC the test
comes back as successful.

Any help or suggestions would be appreciated.

Thanks.

GC
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,136,991
Messages
5,679,004
Members
419,797
Latest member
ikethegenius

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top