vneti
asked on
ASP using VB Script and SQL Server 6.5
Hi Experts
I wrote a sql in my asp page
querystring = "select subr_acct_id, subr_acct_nm from subr_acct where substr(subr_acct_nm,1,1)= substr(Upper(search),1,1)"
adors.Open querystring,"dsn=vneti;dat
when I execute it is not able to recognise substr funtion. It returns an error saying
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]'substr' is not a recognized built-in function name.
Can you help me out.
Thx
-Vneti
I wrote a sql in my asp page
querystring = "select subr_acct_id, subr_acct_nm from subr_acct where substr(subr_acct_nm,1,1)= substr(Upper(search),1,1)"
adors.Open querystring,"dsn=vneti;dat
when I execute it is not able to recognise substr funtion. It returns an error saying
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]'substr' is not a recognized built-in function name.
Can you help me out.
Thx
-Vneti
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"ODBC COULD NOT BE INSTALLED, COULD NOT LOAD ODBCCP32.DLL, THE ODBC INSTALLER. PLEASE INSTALL IT FROM CD"
I am not able to find this DLL. Does this any way effect the error which I am getting.