App Connect

 View Only

 error in using odbc

Tzipi Rosenfeld's profile image
Tzipi Rosenfeld posted Tue January 20, 2026 05:56 PM

hello,

I try to connect to SQL

ODBC created and tested

using the name in "data source" on DATABASE node

but when running get error 

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "Test" requested by the login. The login failed.

maybe need to add user on the DB but there i get when trying to add my user (the user that is running the windows and login with it) getting "invalid character" no space no special character. the only thing is that the letters are doubled. i dont think it is a readon

how can i bring my application to work against my DB?

Ali Mashally's profile image
Ali Mashally posted Thu March 05, 2026 08:22 PM

Hey Tzipi, are you sure you have a sql server on your machine?

Ahmed Elelaimy's profile image
Ahmed Elelaimy posted Sun March 08, 2026 04:34 AM

1) to check if the db user already functioning , please login on the db using it on the sql server first . 

2) Rerun the commands mqsisetdbparams and after successfull command initiation use mqsicvp to check if the connection to the DSN is successfully intaited or not as the mqsisetdbparams if written correctly with correct flags will return success but don't checks for the validation of these credentials . 

3) mqsistop and mqsistart for the integration node . 

Related Content