Skip to Content
0
Dec 31, 2019 at 06:04 PM

Can i use asp(not asp.net) to connect hana?

159 Views

hi,

my ap server is winser2019 std, i have installed iis10, asp, isapi.

i can use the string to connect SQL Server success,

Set Connect = CreateObject ("ADODB.Connection")

Connect.Open "DRIVER={SQL Server};UID=oooo;PWD=oooo;server=SAP;database=TEST"

but when i use the string

Set Connect = CreateObject ("ADODB.Connection")

Connect.Open "DRIVER={HDBODBC32};UID=SYSTEM;PWD=xxxx;SERVERNODE=SAPHana:30015;DATABASENAME=TEST"

the asp page "http 500 error".

what should i do.