(0x800A0415) Expected literal constant

[unixnewsboy]

For the life of me I can't see what is going wrong here... Why am i
getting the above error

<%

'DataBase
const DSN_NAME = "ORADBA"
const DSN_SERV = "localhost"
const DSN_UID = "ORADBA"
const DSN_PWD = "ORADBA"
const MM_Prod_DSN = "dsn=" & DSN_NAME & ";server=" & DSN_SERV & ";uid="
& DSN_UID & ";pwd=" & DSN_PWD & ";"


%>


Please note, MM_Prod_DSN is defined on a single line.

 

[McKirahan]

For the life of me I can't see what is going wrong here... Why am i
getting the above error

<%

'DataBase
const DSN_NAME = "ORADBA"
const DSN_SERV = "localhost"
const DSN_UID = "ORADBA"
const DSN_PWD = "ORADBA"
const MM_Prod_DSN = "dsn=" & DSN_NAME & ";server=" & DSN_SERV & ";uid="
& DSN_UID & ";pwd=" & DSN_PWD & ";"


%>


Please note, MM_Prod_DSN is defined on a single line.

You cannot construct a constant! Try this instead:

Dim MM_Prod_DSN
MM_Prod_DSN = "dsn=" & DSN_NAME & ";server=" _
& DSN_SERV & ";uid=" & DSN_UID & ";pwd=" & DSN_PWD & ";"

 

[unixnewsboy]

ahh... I thought it was ok as long as i didn't try to change it
afterwords.

thank you