OK - I have everything working on my Production computer to find out that when I upload my page to my Shared Hosting Server, to find out my application will not work because I do not have high enough permissions to for aspcompat to be true.
This works on my development server which of course I have full access to:
'Creating Connection Object and opening the database
con = Server.CreateObject("ADODB.Connection")
con.Open(data_source)
con.Execute(sql_insert)
'Done. Close the connection
con.Close()
con = Nothing
Response.Write("Your Information was Successfully Added.")
Is there another method to execute my sql string (which contains my INSERT INTO statement, and is in my .vb code file ) with just a Medium Access Level? Other wise I will have to purchase a Dedicated server, which currently I can not really afford!
Thanks!
View Complete Post