Automatically Create DSN Connection

Anonymous — Mon, 26 Sep 2005 08:48:29 GMT

Hi Everyone

I have done this sort of thing with SQL Server but not with ArchiCAD

What i am trying to do is import data from a pln file to an access database

The import process works fine providing there is a DSN current

If no then I would like to have one create automatically

I am trying to use the following VB Script but keep getting prompted to start the Data Source Configuration Wizard

Here is when I am stuck

Private Declare Function ArchiCADConfigDataSource Lib "odbccp32.dll" _
(ByVal hwndParent As Long, _
ByVal fRequest As Integer, _
ByVal lpszDriver As String, _
ByVal lpszAttributes As String) As Long

Function Connect

lngResult = ArchiCADConfigDataSource(0, _
ODBC_ADD_SYS_DSN, _
"ArchiCad Plan ODBC Driver v9.0.0", _
"DSN=" & JDS_DSN_name & _
"Description=Plans" & Chr(0) & _
"PlanFile=C:\Test.pln" & Chr(0) & _
"MapBigIntToInt=false" & Chr(0) & Chr(0))
End Function

topic Automatically Create DSN Connection in Collaboration with other software

Automatically Create DSN Connection