Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 4th, 2007, 09:51 AM
Registered User
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default connection string in excel

I've just taken over a project that was recently moved to production, with errors. One of them, is that the xls spreadsheet on click of a button (has macros) brings up a connection window, with the address being that of the test server. The quick fix is that users enter the correct ip address. .. but on the test server they never had to do this, as it was build into the connection string.

For the life of me, I cannot find the connection string, no matter where I seem to look in the vb editor. . .please please please, can someone point me in the right direction?
 
Old May 5th, 2007, 09:25 AM
Registered User
 
Join Date: Nov 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

  I've never really done anything like this in Excel, but have you tried looking at the onclick event and see if it's referencing a cell? There could be a hidden spreadsheet with the values on it, in this case you'd click Window >> Unhide. Also they could have it hidden in a macro that's password protected and you just can't get to it without a 3rd party software to get password.

Hope this was some help.
 
Old May 7th, 2007, 01:13 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

If you know the excel sheet name, you should be searching for it in your code, that should help you locating the connection string.
Hope that helps.

cheer.

_________________________
- Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection String with Excel file mateenmohd Classic ASP Databases 8 January 25th, 2013 02:49 AM
Connection string bex BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 August 3rd, 2008 02:16 PM
connection string kooky SQL Server ASP 1 February 14th, 2008 09:59 AM
Connection String aadz5 JSP Basics 1 January 24th, 2005 04:36 AM
Connection String phungleon Dreamweaver (all versions) 1 February 11th, 2004 05:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.