Using vbscript I want to create a runtime html login page on the fly.
The html page should have username/pasword form and I will use this username/password to connect to a sql database.
Is there a way to create this runtimehtml page using vbscript and them collect the username/password from the page to connect to sql using a connection string?
----------
thank you so much cguan_77!!
I recommend against using VB for this as it requires users to have MSIE browsers only.
However, a workaround that is not seemingly mentioned Anywhere is the following...
in the tag script language=vbscript (if used)
remove the language definition and netscape/mozilla should be able to treat the page as ASP instead of looking for VBS in older browsers.
This also goes for the page header %vbscript%
Drop that completely to enable better cross browser support
I tried to coonect to a database as mentioned above and the link, but I am getting an error which says login failed for the user.
The connection string is:
strSQLconn = "Driver={SQL Server};Server=Servername;Database=dbname;" & _
"Uid=username;Pwd=& strPw;"
objSQLconn.Open strSQLconn
strPw is the variable in which I am storing the password.
It works fine when I do it without the login form.
Can anyone tell me why this error is showing up?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.