+ Reply to Thread
Results 1 to 3 of 3

General Networking Question

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    191

    General Networking Question

    My pull sheet is two excel workbooks. I use Office 365. My machine is a windows 10 machine. I use a VPN to connect to a replicated sql database. I need my assistant to be able to do this as well. I personally put both files on her hard drive. IT installed the VPN software. I believe she is using the same versions of excel and windows but canít verify that until tomorrow.

    I have no issues logging onto the vpn and connecting to the sql database or our network drives.
    She can log onto the VPN and access our network drives but will not connect to the sql database.

    The connection is a VBA script. Since I literally pasted my workbooks to her hard drive sheís using my script.

    Other than confirming software versions what else should I look at to troubleshoot the issue? Obviously I am not a network genius. But, I already know that IT is going to just say that itís an excel problem.

    Any insights would be greatly appreciated. Thank you for looking.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,219

    Re: General Networking Question

    What authentication is the database using?
    Rory

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    191

    Re: General Networking Question

    Quote Originally Posted by rorya View Post
    What authentication is the database using?
    Hi, thanks for looking. I'm sorry it took this long for me to circle back. I don't know what authentication is used. Networking isn't my thing and the connection script was provided by the company that runs the inventory managment web application. We replicate the database nightly so that we can run sql queries and get datasets not available using the controls on the web (real time) application. All I do know is that it works for me. It works for others in the company. But it doesn't seem to work with my assistant. Here is the connection VBA.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. General Question
    By ramonfm in forum Excel General
    Replies: 3
    Last Post: 02-12-2019, 12:33 PM
  2. different:General Question
    By mtaystl11 in forum Excel General
    Replies: 5
    Last Post: 06-24-2006, 10:55 AM
  3. General Question
    By Me in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 09:00 AM
  4. General Question
    By Ragdyer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1