Graphics

Is there a datalinq server API? Theres a few use cases I can think of where automating the path of a data source inside Datalinq Server would save me time and provide some flexibility (we run a lot of package-specific data sources via some command line applications that all share a common name in datalinq, just changing the pathing per show). I do see a DLL file for xpDatalinqClient but when I load it in Visual Studio it has very little in the way of interfacing with the server.

Thanks,
Nick

------------------------------
Nick Huntley
------------------------------

We're in a similar situation where we need to choose from multiple projects from our sites around the country on our development PC. Each site has their own .dsc file. The solution we've come up with is to:

1. Terminate the "xpDataLinqServer" process
2. Overwrite the "datalinqs.dat" file in "C:\Program Files\XPression\DataLinqServer" with the site's .dsc file
3. Run xpDataLinqServer.exe again

We automate this in our software. It would be nice to have a better way. It would also be nice if they had some kind of plugin API so we can add our own data sources. For example, Sqlite or maybe a live data stream.

------------------------------
JOHN
------------------------------

Original Message:
Sent: 11-23-2021 15:57
From: Nick Huntley
Subject: Datalinq Server API

Is there a datalinq server API? Theres a few use cases I can think of where automating the path of a data source inside Datalinq Server would save me time and provide some flexibility (we run a lot of package-specific data sources via some command line applications that all share a common name in datalinq, just changing the pathing per show). I do see a DLL file for xpDatalinqClient but when I load it in Visual Studio it has very little in the way of interfacing with the server.

Thanks,
Nick

------------------------------
Nick Huntley
------------------------------

Hey John!

Regarding SQLite, you can download a SQLite ODBC connector and use a ODBC connection string to connect Datalinq server via ADODB to the SQLite source.
https://www.connectionstrings.com/sqlite3-odbc-driver/
Datalinq server can also connect any to 32bit DSNs you have in windows ODBC Data sources using ADODB.

At this time we don't have an API that can be used to control Datalinq server.

------------------------------
Brandon Derry
Ross Video
------------------------------

Original Message:
Sent: 11-24-2021 07:37
From: JOHN CORIGLIANO
Subject: Datalinq Server API

We're in a similar situation where we need to choose from multiple projects from our sites around the country on our development PC. Each site has their own .dsc file. The solution we've come up with is to:

1. Terminate the "xpDataLinqServer" process
2. Overwrite the "datalinqs.dat" file in "C:\Program Files\XPression\DataLinqServer" with the site's .dsc file
3. Run xpDataLinqServer.exe again

We automate this in our software. It would be nice to have a better way. It would also be nice if they had some kind of plugin API so we can add our own data sources. For example, Sqlite or maybe a live data stream.

------------------------------
JOHN

Original Message:
Sent: 11-23-2021 15:57
From: Nick Huntley
Subject: Datalinq Server API

Is there a datalinq server API? Theres a few use cases I can think of where automating the path of a data source inside Datalinq Server would save me time and provide some flexibility (we run a lot of package-specific data sources via some command line applications that all share a common name in datalinq, just changing the pathing per show). I do see a DLL file for xpDatalinqClient but when I load it in Visual Studio it has very little in the way of interfacing with the server.

Thanks,
Nick

------------------------------
Nick Huntley
------------------------------

Yes, you can use an ODBC driver, but the nice thing about Sqlite is that it is file based. With a Sqlite aware app, nothing else needs to be installed - no drivers or ODBC, etc. This helps simplify deployment and avoids 32/64 bit driver issues.

------------------------------
JOHN
------------------------------

Original Message:
Sent: 11-24-2021 10:00
From: Brandon Derry
Subject: Datalinq Server API

Hey John!

Regarding SQLite, you can download a SQLite ODBC connector and use a ODBC connection string to connect Datalinq server via ADODB to the SQLite source.
https://www.connectionstrings.com/sqlite3-odbc-driver/
Datalinq server can also connect any to 32bit DSNs you have in windows ODBC Data sources using ADODB.

At this time we don't have an API that can be used to control Datalinq server.

------------------------------
Brandon Derry
Ross Video

Original Message:
Sent: 11-24-2021 07:37
From: JOHN CORIGLIANO
Subject: Datalinq Server API

We're in a similar situation where we need to choose from multiple projects from our sites around the country on our development PC. Each site has their own .dsc file. The solution we've come up with is to:

1. Terminate the "xpDataLinqServer" process
2. Overwrite the "datalinqs.dat" file in "C:\Program Files\XPression\DataLinqServer" with the site's .dsc file
3. Run xpDataLinqServer.exe again

We automate this in our software. It would be nice to have a better way. It would also be nice if they had some kind of plugin API so we can add our own data sources. For example, Sqlite or maybe a live data stream.

------------------------------
JOHN

Original Message:
Sent: 11-23-2021 15:57
From: Nick Huntley
Subject: Datalinq Server API

Is there a datalinq server API? Theres a few use cases I can think of where automating the path of a data source inside Datalinq Server would save me time and provide some flexibility (we run a lot of package-specific data sources via some command line applications that all share a common name in datalinq, just changing the pathing per show). I do see a DLL file for xpDatalinqClient but when I load it in Visual Studio it has very little in the way of interfacing with the server.

Thanks,
Nick

------------------------------
Nick Huntley
------------------------------