...

View Full Version : ERROR MESSAGE: Asp database connect to Oracle - TRUNC function.



bsharif
12-05-2007, 03:12 PM
Good morning,

I'm trying to connect to an oracle database to retrieve records than display the results back in ASP. When I do this using the code:



strSQL = "select distinct "
strSQL = strSQL & "c.cust_name_key1 as lastname, "
strSQL = strSQL & "c.cust_name_key3 as middleinitial, "
strSQL = strSQL & "c.cust_name_key2 as firstname, "
strSQL = strSQL & "c.cust_street as address, "
strSQL = strSQL & "c.cust_city as city, "
strSQL = strSQL & "c.cust_state_cntry as state, "
strSQL = strSQL & "c.cust_postal_code as zipcode, "
strSQL = strSQL & "c.txnl_licn_type as licensetype, "
strSQL = strSQL & "c.ltype_desc as licensedescription, "
strSQL = strSQL & "c.txnl_year as LicenseYear, "
strSQL = strSQL & "c.txnl_expire_date as expiredate, "
strSQL = strSQL & "c.cust_res_type as residence "
strSQL = strSQL & "from "
strSQL = strSQL & "flhf.customer_license_view c "
strSQL = strSQL & "where "
strSQL = strSQL & "c.agent_county = " & select_county & " "
strSQL = strSQL & "and trunc (c.txnl_expire_date) "
strSQL = strSQL & "between (sysdate+1) and ( " & expire_Date & ") " with the variables select_county being the county givin by the user and expire_Date being the expire date provided by the user as well, I get the error message :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[IBM][CLI Driver][DB2/NT] SQL0440N No function by the name "TRUNC" having compatible arguments was found in the function path. SQLSTATE=42884

/reports/county_asp_from_html_real_one.asp, line 72 Need help, totally LOST!! Unfamiliar with error message.

-Thanks

Spudhead
12-05-2007, 05:51 PM
If you're using an Oracle database, why are you getting an error message from an IBM DB2 driver?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum