I apologize in advance to forum readers noticing this somewhat
redundant post. I fear that my Subject Heading was ill-chosen in
earlier post I made on this topic. Am hoping that a clearer Subject
heading will attract the knowledgeable forum contributors I'm
seeking. Thank-you...
I'm being academically challenged trying to build a pass-through
query inside of Access 2.0 to "reach out 'n touch" a remote data
file running on a Linux box in Kansas. I was able to achieve this
goal from within Access 97 (thanks be to the higher powers) but
am suffering somewhat with Access 2.0. I'm certain that it can be
done, but I'm just not the right man for the job without some
assistance.
What I've tried in Access 2.0 is to open a query in design view
and select the "Query" item from the menubar. Then choose
"SQL Specific" and "Pass-Through". Then, in the properties
box for the query object, I invoke the builder button for the
"ODBC Connect String" property. I'm then prompted to
specify an SQL Data Source. That's where I lose it. I
can't seem to input the parms (see prev post) needed.
Error: ODBC call failed... [MicroSoft] [ODBC DLL] Datasource not
found and no default ODBC driver specified.
I've tried stuff like the following for the ODBCConnectStr Property...
ODBC;DSN=ABCD;SERVER=123.456.789.10;UID=UserName;P WD=MyPass
where ABCD is the dBase name on the remote server.
Somehow, my syntax just isn't getting through. Should I be passing
something else for the DNS and SERVER assignments? Where do
I go from here?