DevOps, CI/CD and Automation

I am building some reports within Excel which connect to a 8.1.7.0.0 Oracle database, within a Windows 2000 environment through a DSN-less ODBC connection. I am using an Oracle ODBC driver (I have tested with various versions of 8.1.7.x) and when I try the refresh method on a query table it works fine on my computer but when the reports are tested on several of our client's networks they fail and return a general odbc error(1004). If I switch to a Microsoft odbc for oracle driver, the problem goes away. Both of our clients were using version 8.1.7.0 oracle odbc driver so I got one of them to download a more recent version but it did not help. Any suggestions?

Here is what the Oracle connection string looks like and I made sure that the name between the { } was exactly the same as the name listed in their ODBC data source administrator drivers tab,

ls_connection_string = "ODBC;DRIVER={Oracle ODBC Driver};SERVER=" & Logon.TextBox3.Value & _
";UID= " & Logon.TextBox1.Value & _
";PWD=" & Logon.TextBox2.Value & _
";DBQ=" & Logon.TextBox3.Value