ODBC using DBLOOKUP/DBCommand

HCL Domino Domino Forum
1

Hi I am extracting the data from SQL server,this is the first instance that i need to extract some data from externa.

I don’t know much about the ODBC.just a starter.I tried to extract the data using

@DbCommand(“ODBC”;" Rmsi_sql\rmsi_production";“dbo”:“”;" tblTimeRegister":“”;

“SELECT in1 FROM dbo. tblTimeRegister WHERE PayCode='N01207’AND DateOffice=‘2008-05-16’”)

but it is giving the error

Could not execute @db function.

Can some one guide me how to use the statement and fetch the data from SQL Server.

Do I have to setup ODBC somewhere.

2

Subject: ODBC using DBLOOKUP/DBCommand

Is your local PC configured to connect to the ODBC datasource?

3

Subject: RE: ODBC using DBLOOKUP/DBCommand

I’m facing the similar problem with SQL Server data retrieval.

The command being used is :

@DbLookup(“ODBC”;“DSNname”;“userid”;“password”;

“dbo.tablename”;“field1”:“Discard”;“field2”;“searchvalue”;“Ascending”);

I have created a DSN for the corresponding database on the server with the name : DSNname, and its test connection is working fine but still facing the error :

Could not execute @Db function