<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I made Add In that create data base connection
but trying to retrive the data using diffrent scripts / add in does not work
do i need to creata data base connection on every add in?
this is my connection add in script
New Window("USER ID and pass", <userID = variablebox1 <pass = variablebox2 <
abc = Create Database Connection("DSN=DB;UID="||userID||";PWD="||pass||";MODE=SHARE;DBALIAS=DB;");
but whenever i try to use the abc connection from diffrent add in / script it doest find it
Name Unresolved: dbc in access or evaluation of 'dbc' , dbc
dt = Execute SQL(
dbc/*###*/, ...
Sounds like a scoping problem. Make the connection variable a global variable by prefacing it with "::".
::abc = Create Database Connection( "DSN=DB;UID=" || userID || ";PWD=" || pass || ";MODE=SHARE;DBALIAS=DB;" );
