Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL scripts and ODBC
I have written some VBA code that executes multiple queries in sequence.
On my PC, I only have to enter my password for the ODBC DSN once and the program somehow uses my password entry on each query there after. My problem is that on some users PC's they are forced to enter in their password each time an SQL is initiated. How can I change this from happening without entering my password into the SQL script. I am not comfortable with this. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete scripts | Excel Worksheet Functions | |||
Forumlas or scripts? | Excel Discussion (Misc queries) | |||
SQL Scripts in Excel | Excel Discussion (Misc queries) | |||
Macintosh and VB Scripts | Excel Programming | |||
two identical scripts, one with problem, the other with NO?! | Excel Programming |