I'm trying to call SQLConfigDataSource API to create a
DSN entry to read an Access database from VFP.

The problem is I don't know what string to pass as 4th argument.
I tried "DSN=temp"+CHR(0)+"Description=temp"+CHR(0)+"DBQ=c:\test.mdb"
but it doesn't work.
Example:
err=SQLConfigDataSource(0,1,"Microsoft Access Driver",
"DSN=temp"+CHR(0)+"Description=temp"+CHR(0)+"DBQ=c:\test.mdb")

I successfully created DSN entry for VFP tables in the same way
(the string is obviously different).

Someone can help me?
I can't use a static DSN. I need to call the API to create the entry.

--
Andrea Mariottini

Hi, Andrea!
You wrote  on Thu, 13 Mar 2003 18:56:45 +0100:

 AM> Someone can help me?
 AM> I can't use a static DSN. I need to call the API to create the entry.

Maybe you can use DSNless connection?

m.lnHandle = SQLSTRINGCONNECT("Driver=Microsoft Access Driver
(*.mdb);DBQ=C:\Program Files\Microsoft
Office\Office\1033\FPNWIND.MDB;DefaultDir=C:\Program Files\Microsoft
Office\Office\1033;MaxBufferSize=2048;PageTimeout=5;")

The same connection string may be used for Connection object in DBC.

WBR, Igor

Thanks! It works.

--
Andrea Mariottini