Nouvelle publication

検索

Question
· Oct 21, 2024

How to connect to InterSystems Caché using IPv4 and enable remote connections?

#Environnement de développement #ODBC #Caché

I’m trying to connect to an InterSystems Caché database from my local development environment using an IPv4 address. Most examples I’ve found show how to connect using the ODBC driver with the localhost or the default IP address (127.0.0.1). However, I want to know how to connect using my local IPv4 address.

Here’s what I need help with:

  1. Connecting with IPv4: I want to know how to specify my local IPv4 address in the ODBC connection string or any other method to connect to the Caché database.
  2. Enabling Remote Connections: Additionally, how can I configure InterSystems Caché to allow remote connections from other PCs on the same network or from outside network? What settings do I need to adjust?

What I’ve Tried:

  • I’ve attempted changing the Server value to my local IPv4 address, but I encounter errors.
  • I’ve checked the InterSystems documentation but haven’t found clear instructions for enabling remote access.
4 Comments
Discussion (4)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Oct 18, 2024

¿Cómo obtener el error SQL nativo en SQL Outbound adapter?

#SQL #InterSystems IRIS

Hola a todos,

Tenemos una restricción en una base de datos de SQL con un índice único.

Queremos capturar la excepción cuando intenta insertar o actualizar un valor que incumpla la condición del índice único.

// run the query
Set tSC = ..Adapter.ExecuteUpdateParmArray(.nrows,SQL,.param)

// Check if there is any error
If $$$ISERR(tSC)
{
	Set msgError = $System.Status.GetErrorText(tSC) 
	// Check here if the native error code is 2601 (Cannot insert duplicate key row into object 'MYPATIENTS' with unique index 'UQ_UNIQUE_INDEX')
	??????
}

He intentado capturar el valor de ..Adapter.%SQLCODE, pero está vacío

¿Está este código oculto en la variable tSC? Me explico, de la misma forma que pueda capturar el texto del error usando la clase $System.Status, ¿Hay algún método para capturar el error nativo?

Saludos cordiales

1 Comment
Discussion (1)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Oct 16, 2024

Generate JWT token in Cache 2018

#Sécurité #Caché

Hi,

I try to generate JWT tokens in Cache (not in IRIS).

In IRIS I managed to generate tokens using ##class(%OAuth2.JWKS).AddOct("HS256",secret,.jwks).

But In Cache there is no such routine.

Could you provide me a place to find an example how to use JWT, please ?  I am interested to generate a token in Cache, send it to javascript client, and read a token provided by the client and check it is valid.

Kind regards,

 

Alin Soare.

1 Comment
Discussion (1)2
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Oct 14, 2024

O Concurso de Tutoriais Técnicos InterSystems IRIS está começando!

#Concours #IRIS contest

Olá Desenvolvedores! 

Tenho o prazer de anunciar que hoje inicia o novo concurso da nossa Comunidade de Desenvolvedores InterSystems.

 

Aproveite a chance de se aprimorar e compartilhar aprendizados com a Comunidade de Desenvolvedores, e concorrer a prêmios excelentes. 
Todas as informações e regras estão publicadas no anúncio ✍️ Concurso de Tutoriais Técnicos InterSystems IRIS ✍️

Participe e compartilhe! 😉 

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Oct 14, 2024

InterSystems IRIS Technical Tutorial Contest in Portuguese

#Concours #Événements #IRIS contest

Hello, Community!

It's time for the next InterSystems Developer Community contest!

✍️ InterSystems IRIS Technical Tutorial Contest ✍️

Create a Technical Tutorial** that can be considered a guide for InterSystems IRIS programmers of any level: beginner/intermediate/senior, from October 14th to November 24th. The tutorial can be in the form of an Article with text and images and/or a Demonstration Video.

Enjoy and let your creativity flow! Show how easy and fun it can be to create solutions with InterSystems IRIS.

🎁 Prizes for everyone: A special prize for each author participating in the competition!

Prizes

1. Everyone is a winner in the Tech Article Contest! Any member who writes an article during the competition period will receive a special prize:

🎁 InterSystems - Developer Community Thermos Bottle (300 ml)

2. Expert Awards – articles will be judged by InterSystems experts:

🥇 1st place: iPad Air de 11” Wi-Fi 128 GB 

🥈 2nd place: Air Pods Pro 2nd gen

🥉 3rd place: Echo Show: Smart Display Full HD 15,6’’ com Alexa

3. Developer Community Award – article with the most likes:

🎁  Echo Dot - Alexa Echo Dot 5th gen

Note: 

  1. The author can only be awarded once per category (in total, the author will win two prizes: one for Expert and one for the Community)
  2. In the event of a tie, the number of votes of the experts for the tied articles will be considered a tie-breaking criterion.  

Who can participate?

Any Developer Community member, except for InterSystems employees. Create an account!

Contest period

📝  October 14th to November 10th: Publication of articles. 

🗳️  November 11th to November 17th: Voting time. 

🏅  November 18th: Winners announcement. 

Publish an article(s) throughout this period. DC members can vote for published articles with Likes – votes in the Community award.

Note: The sooner you publish the article(s), the more time you will have to collect both Expert & Community votes.

What are the requirements? 

❗️ Any article written during the contest period and satisfying the requirements below will automatically* enter the competition:

  • The article must be a tutorial** on the InterSystems IRIS topic. It can be either for beginners, middle or senior developers.
  • The article must be in Portuguese (incl. inserting code, screenshots, etc.).  
  • The article must be 100% new (it can be a continuation of an existing article not in the contest).  
  • The article cannot be a translation of an article already published in other communities.  
  • The article should contain only correct and reliable information about InterSystems technology.
  • The article has to contain the Tutorial tag.
  • Article size: 400 words minimum (links and code are not counted towards the word limit).  
  • Articles on the same topic but with dissimilar examples from different authors are allowed.

* Our experts will moderate articles. Only valid content will be eligible to enter the contest.

** Tutorial “is a method of transferring knowledge and may be used as a part of a learning process. More interactive and specific than a book or a lecture, a tutorial seeks to teach by example and provide the information to complete a certain task.”
https://en.wikipedia.org/wiki/Tutorial

Tutorials provide step-by-step instructions that a developer can follow to complete a specific task or set of tasks.

🎯 EXTRA BONUSES

This time, we've decided to add additional bonuses that will help you to win the prize! Please welcome: 

Bonus

Nominal 

Details

Topic bonus

5 

If your article is on the topic from the list of proposed topics (listed below), you will receive a bonus of 5 Expert votes. 

Video bonus

3 

Besides publishing the article, make an explanatory video.

Discussion bonus

1

Article with the most useful discussion, as decided by InterSystems experts. Only 1 article will get this bonus.

New participant bonus

3

If you haven't participated in the previous contests, your article(s) will get 3 Expert votes.

Programming bonus

5

Besides publishing the article, Publish your related application on InterSystems Open Exchange. And don't forget to reference it in the article.

Proposed topics

Here's a list of proposed topics that will give your article extra bonuses:

✔️ Using AI/ML/GenAI
✔️ Using Vector Search
✔️ Using FHIR SQL Builder

Note: Articles on the same topic from different authors are allowed.

It's time to show off your writing skills! Good luck  ✨

2 Comments
Discussion (2)2
Connectez-vous ou inscrivez-vous pour continuer