Linking FoxPro Tables DSN-less...

[Michael Sommer]

Hi!

What i trie to do is to link a FoxPro Table DSN-less.
Is this possible?

Linking FoxPro Tables to Access 2002 with the following ConnectionString
works fine:

sConnect =
"ODBC;DSN=dbFoxProTest;SourceDB=D:\somefolder\somedatabase.DBC;SourceType=DB
C;Exclusive=No;"

but this requires the dbFoxProTest DSN to exist on the System. I want to
link the Tables DSN-less (which works for dbase, paradox, text, sql-server,
etc...) like:

sConnect = "ODBC;Driver={Microsoft Visual FoxPro
Driver};SourceDB=D:\somefolder\somedatabase.DBC;SourceType=DBC;Exclusive=No;
"

Sample Code:
---
Dim td as TableDef

sConnect = <one of the above>

Set td = db.CreateTableDef(sTableInternal, dbAttachSavePWD,
sTableExternal, sConnect)
db.TableDefs.Append td
---

Trying to link DSN-less i get the error -7778 (There is no description for
this error).

What am i doing wrong? Is this at least not possible at all?

Greetings

Michael Sommer
HaPeC GmbH