JDBC Adapter and MS SQL Server with special table and column names

[Former Member]

Hi Freaks,

i have trouble with the jdbc adapter and a ms sql database.

How can i define a pi datatype for the folllowing sql (ms sql) statement:

select "Search Name" from "dbo"."client 1$vendor"

where "country code" = 'DE'

Please notice the spaces in the column and table names!

Thanks and regards

Sebastian

[prateek]

Instead of "Search Name", try "[Search Name]" or "['Search Name']"

Regards,

Prateek

[VijayKonam]

If it is sender side, copy the executing query from SQL Query manager in to sender adapter.

If on receiver side, use the SQL XML format for specifying the query.

VJ