Re: About Access 2003 ODBC and Jet 3.51

Michael Gramelspacher wrote:

I have Access 2003 SP2 and Jet Core Components list Jet 4.0 and ODBC as both Not
Available. I can link to an ODBC source through Get External Data/Link Tables,
select ODBC Databases(). I get a window for Select Data Source having two tabs,
File Data Source and Machine Data Source. I suppose that everything I have
described is just the way it is supposed to work.

Thanks for providing one more link in my search for why ODBC wasn't working. Found out is was NAV2006 that caused the problem.


On Fri, 02 Nov 2007 14:57:31 -0700, Salad <oil@xxxxxxxxxxx> wrote:


I'm not so concerned about the Jet 3.5 as the summary said I had Jet 4.0. Right now tho, if I attempt to select an ODBC source (File/GetExternalData/Link Tables) and select "ODBC Databases ()" the window simply closes and I have no opportunity to select a data source. Is it normal to have the ODBC item in the Jet Core Components list not available? I'd feel more comfortable if I could access the ODBC list whether or not I need it.
.

Relevant Pages

  • Re: If then else containing value not at the end or in the beginni
    ... ODBC, and you have the necessary bits of the Jet database engine on ... b.open your mail merge main document and disconnect from the data source. ... Now you either need some VBA, or you need a DATABASE field. ... Sub MyConnect() ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge with external data source
    ... > Microsoft Query via ODBC, if you could ever figure out the syntax. ... We had that conversation back in 2006 about Word 2004 ODBC connectivity. ... I think by that time several people had probably tried quite hard to get an ODBC connection to work - the only response from MSFT was that the "\c ODBC switch was not supported in the DATABASE field in Word 2004" I think he meant ODBC connectivity wasn't supported, and I would guess it still isn't. ... A data source for a mail merge operation can be an Excel sheet, ...
    (microsoft.public.mac.office.word)
  • Re: Open Database Connectivity Error
    ... databases. ... "Peter Jamieson" wrote: ... > for an ODBC data source name which does not exist. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Does connection string need anything on system?
    ... Open DataBase Connectivity (ODBC) is a Microsoft standard (albeit an old ... This DSN needed to be configured to know which database ... driver was going to be needed and which actual data source was being used. ... connection string? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Does connection string need anything on system?
    ... This DSN needed to be configured to know which database driver was going to be needed and which actual data source was being used. ... This is what the ODBC Manager tool in Control Panel> Admin Tools is for...setting up a DSN. ... With OLEDB, you code directly against the provider and, as long as the provider is present on the target machine, the code can talk to it. ...
    (microsoft.public.dotnet.framework.aspnet)