User bio
404 bio not found
Member since Nov 2, 2016
Posts:
Kai has not published any posts yet.
Replies:

You may configure an ODBC Data Source to your MSAccess "file" and use the %SQLGatewayConnection class.

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls... When I had to use it around 2012 was looking like this:

set dsn="<yourODBCSource>"
set conn=##class(%SQLGatewayConnection).%New()
set sc=conn.Connect(dsn,"","",0) 
set res=##class(%ResultSet).%New("%DynamicQueryGW:SQLGW")
set sc=res.Prepare("SELECT * FROM yourAccessTable",,conn)
set sc=res.Execute()
while res.Next() { 
  write !;res.Get("yourColumn") 
}
Certifications & Credly badges:
Kai has no Certifications & Credly badges yet.
Global Masters badges:
Kai has no Global Masters badges yet.
Followers:
Kai has no followers yet.
Following:
Kai has not followed anybody yet.