Basically I was trying to connect to some database within kdb+following the instructions here:https://code.kx.com/trac/wiki/Cookbook/ODBC/qclientBut when I doing the open or load like:q)h:.odbc.open `northwind / open northwind databaseI got an error message said:'28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed foruser ‘’.The user is not associated with a trusted SQL Server connection.Anyone can tell me how to specify the username and password for thatDSN? Thanks in advance!
I believe you have to specify a dsn or a connection stringto .odbc.openI don’t have much experience with DSNs, but if you use a connectionstring, it would look something like this:"Driver=;Database=master;port=1433;Server=<your_sql_server>;uid=;PWD="On Oct 18, 9:24?pm, bovine <chenying…> wrote:> Basically I was trying to connect to some database within kdb+> following the instructions here:https://code.kx.com/trac/wiki/Cookbook/ODBC/qclient>> But when I doing the open or load like:> q)h:.odbc.open `northwind ? ? ? ? ? ? ? / open northwind database>> I got an error message said:> '28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for> user ‘’.> The user is not associated with a trusted SQL Server connection.>> Anyone can tell me how to specify the username and password for that> DSN? Thanks in advance!</chenying…></your_sql_server>
Hi,
How about
h: .odbc.open “Driver={SQL Server};Server=servername;Database=dbname;Uid=user;Pwd=pass”
Name of the driver should have the right spelling.
Drivers are usually enclosed in curly brackets.?
regards,