Hello I'm trying to create a ODBC connection programmatically to Perasive.sql from a module in Access. I know I need to create a system DSN. I have no problem creating a User DSN but pervasive.sql needs to have a system DSN. I can make a system DSN if I make an one with an Access driver, for some reason I can't find anything to help me with coding a Pervasive ODBC Engine Interface driver.
ret = SQLConfigDataSource(0, ODBC_ADD_SYS_DSN, Driver, Attributes)
' ret is equal to 1 on success and 0 if there is an error
If ret <> 1 Then
MsgBox "DSN Creation Failed"
I can get it to create the Access system DSN but not the pervasive System DSN. I went to the pervasive site and it said the Engine interface only needed the Driver, DSN, UID, and PWD.
I'm trying to connect to DDF files that are from MPM 3.0. I was going to try and use Pervasive.slq V8 it has ole db capabilities, but the people at Business Engine said I cannot use the Pervasive.slq V8 it will not work with the current version of MPM.
Are you running everything on the same server? The engine interface will only work if run on the same server where pervasive is running. And at that point there should already be an ODBC defined for that database so you don't need to specify it programmatically.
You should use the client odbc if you are running access on a box different than the database server, and must also specify the SERVER as well as the database.