Re: problems with DSN for MS Acess database

<kdv09@xxxxxxxxxx> wrote in message
news:1135054932.284450.211830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
....
> After that by silly mistake User DSN for MS Access Database was created
> on the development PC (the one with existing and working MS Access).
> This upset performance of database access very badly - it takes very
> long time to read and move through the records

You could check the Advanced parameters in the ODBC setup.

Or you could extract the registry entries and compare them between the two
computers. To do this, open RegEdit and look at the keys for:

[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\YourOdbcDsN]

if it is a User DSN,

or

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\YourOdbcDsN]

if it is a System DSN.

You can use RegEdit File Export to save text files for these keys and
compare the results.

If you have both User and System DSN, the User DSN wins, when you connect in
C++ using ODBC.

One parameter to check is buffer size, located at:

[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\YourOdbcDsN\Engines\Jet]
"MaxBufferSize"=dword:00008000 ; or whatever size you want

- Steve


.

Relevant Pages

  • Re: [IM006] [Microsoft][ODBC Driver Manager] Drivers SQLSetConnectAttr failed
    ... It was a User DSN but after making it a System DSN there was no change in ... > Hello cipher, ... > Check if your DSN is a system dsn ... >> I'm creating a webservice that needs to query an Access database ...
    (microsoft.public.dotnet.framework.webservices)
  • Realising a Application with ODBC
    ... I'm writing an Application which connect to a database by ODBC (User DSN). ... The ODBC file links to an MS Access Database which is located in the ... I'd like to have a Windows Installer Packet for Installing the Program. ...
    (microsoft.public.data.odbc)
  • Re: Connection String
    ... I wish to connect to a Access Database for which there is User DSN from an ASP page. ... I would be grateful if you could indicate the connection string. ...
    (microsoft.public.sqlserver.olap)
  • Intermittent problem with update
    ... Connection via a user DSN. ... Access database is secured - I've checked permissions on both Access and SQL server - all good. ...
    (microsoft.public.access.forms)
  • Re: How to manage SQL server Authentication in Access2007
    ... Are you using User DSN or System DSN. ... SQL 2005 is using SQL Server authentication with a password. ...
    (microsoft.public.sqlserver.security)
Loading