Bah.ODBC Questions

BlitzMax Modules Forums/Brucey's Modules/Bah.ODBC Questions

Creating a NEW ODBC Database:

In my tests I have supplied a blank database with a FileDSN for the LoadDatabase call.
I can add/delete tables/records.

What i can't seem to do is CREATE the blank file from within Blitz. The only function i can see is LoadDatabase.
The below code has me confused:
SuperStrict
Import bah.dbodbc

Global db:TDBConnection
db = LoadDatabase("ODBC", "C2D.mdb", Null, Null, Null, Null, "c:\C2D.mdb")

' Check that the DB connection has been made
If Not db Then
	Notify("Unable to Open the Database c:\C2D.mdb")
	End
Else
	DebugLog ("Opened")
End If
	
' Check if the database has an error on opening
If db.hasError() Then
	errorAndClose(db)
End If
	
Function errorAndClose(db:TDBConnection)
	DebugLog(db.error().toString())
	db.close()
	Notify("Read the DebugLog to see what the error was")
	End
End Function

The debuglog tells me db has opened but i suppose that is because db exists, even if it is null. then the errorandclose function kicks in.
No file is created.

I have read the source files and found references for SQLWriteFileDSN.c but i don't have the faintest clue how to invoke it.

also i was hoping the LoadDatabase call would act like an OpenStream call whereby the file is created if it doesn't exist. obviously it doesn't. I couldn't locate any other command like "CreateDatabase".

How do you guys create a database file and a file DSN for ODBC types?

Cheers
Glenn