Connect to MS Access

[matelix]

Hi All

I need to connect to an MS Access database via TD 5.2, I'm looking for something similar to the VB jet engine or ADO connection. Does TD have anything like this?

Thanks in advance

[Jeff Luther]

Connection is likely via ODBC.

[matelix]

I feared that might be the case. Can i at least automate the ODBC connection? I don't want the user to go fiddling with these settings for themselves

Thanks Jeff

[gigit]

Hi, Matelic.
You only need and entry in your SQL.INI like this.
No DSN is required, only drivers installed.
Or, of course, you can build the connection string into the application.


[win32client.dll]
; ------------------------- DLL per odbc
comdll=sqlodb32

; Connection strings
; ACCESS

REMOTEDBNAME=AGEPRO,Driver=Microsoft Access Driver (*.mdb);Dbq=G:\database\access\agepro.mdb;MaxBufferSize=2048;PageTimeout=5;UID=admin;

;SQLSERVER
REMOTEDBNAME=WIGWAM,Driver=Sql Server;Server=GIGI01\SQL2008R2;Database=WIGWAM;LastUser=sa;UseProcForPrepare=0;AnsiNPW=No;QuotedId=No;AutoTranslate=No;Language=English

[Jeff Luther]

gigit is correct about the TD SQL.INI setting, but just to be sure you are clear: if will not work if [win32client.dll] section only has the comdll= entry for ODBC. This is correct -- and I will keep the comment that's in the default INI file on install:

[win32client.dll]
; order of win32client dll's is important when connecting to multiple databases.
; sqlws32 should always be the last and sqlodb32 be 2nd last.
; comdll=sqlifx32
; comdll=sqlora32
; comdll=sqlsyb32
comdll=sqlodb32
comdll=sqlws32

I've put in bold the fact that sqlodb32 is second to last, and even if you do not connect to SQLBase, that last entry must be there: comdll=sqlws32
Reason? That enables TD internally to call common/general SQL/API functions that are needed for any DB connectivity.