Using an Access Database

The forum is locked. These are the original blitzbasic.com forums, kept so they can still be read. No new topics, replies or edits can be made here. To join in, head over to the Blitz3D+ forums.

Glenn Dodd

Here is my LoadDatabase line:

Local db:TDBConnection = LoadDatabase("ODBC", "Glenn", Null, Null, Null, Null, "GlennDSN")

where Glenn is a database (access 2003) saved as c:\Glenn.mdb

GlennDSN is the DSN entry, as below:

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=C:\
DBQ=C:\Glenn.mdb

This is the default data and i haven't modified it in any way.
I am using Test_01 from the odbc folder
Here are the first few lines

SuperStrict

Framework BaH.DBODBC

' database dsn name
Local db:TDBConnection = LoadDatabase("ODBC", "Glenn", Null, Null, Null, Null, "GlennDSN")

If Not db Then
DebugLog("Didn't work...")
End
End If

If db.hasError() Then
errorAndClose(db)
End If
DebugLog( "Database Loaded")

I keep getting db.hasError().

Any ideas appreciated.

Regards
Glenn