Trying to query ODBC source without linked table

#1 (**permalink**) 28-Jul-2006, 08:34 AM

>From what I've seen in other posts, it looks like I should be able to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13114-trying-query-odbc-source-without-linked.html
run a query through Jet SQL that does something like

select MyField from MyTable in "ODBC;DSN=MyDSN;UID=;PWD="

When I do this, it tells me that it can't find the file
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114
"c:\ODBC;DSN=MyDSN;UID=;PWD=". Is there a way to directly query
another database via ODBC just used Jet SQL?

Thanks.

*

#2 (**permalink**) 28-Jul-2006, 08:34 AM

Simply create a linked table then use it like any other table.

Alternatively, create a pass-through query.

Change your SQL to Select MyField From MyTable (i.e.: what you have already,
without the in "ODBC;..." part) Instead, select SQL Specific from the Query
menu, and choose the Pass-Through option. In the Query properties window,
you should see a property labelled "ODBC Connect Str". Pasted what you had
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114
before in your "ODBC;..." string into that property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

wrote in message
news:1152732402.940715.248960@m73g2000cwd.googlegr oups.com...
> >From what I've seen in other posts, it looks like I should be able to
> run a query through Jet SQL that does something like
>
> select MyField from MyTable in "ODBC;DSN=MyDSN;UID=;PWD="
>
> When I do this, it tells me that it can't find the file
> "c:\ODBC;DSN=MyDSN;UID=;PWD=". Is there a way to directly query
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114
> another database via ODBC just used Jet SQL?
>
> Thanks.
>

#3 (**permalink**) 28-Jul-2006, 08:34 AM

If the name and location of the database file are C:\MyMDB.mdb then the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114
following should work:

select MyField from MyTable in "C:\MyMDB.mdb" ...

Of course, writing something like C:\ODBC mean absolutely nothing; unless
you have a database file with the name ODBC. If you want to use a DSN, then
something like should work:

select MyField from MyTable in "ODBC;DSN=MyDSN;UID=;PWD=". " ...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114

However, this is very old stuff and I'm not sure if these will work.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

wrote in message
news:1152732402.940715.248960@m73g2000cwd.googlegr oups.com...
> >From what I've seen in other posts, it looks like I should be able to
> run a query through Jet SQL that does something like
>
> select MyField from MyTable in "ODBC;DSN=MyDSN;UID=;PWD="
>
> When I do this, it tells me that it can't find the file
> "c:\ODBC;DSN=MyDSN;UID=;PWD=". Is there a way to directly query
> another database via ODBC just used Jet SQL?
>
> Thanks.
>