dynamic dsnless string set up

[dazzleblu]

I am trying to set up a dynamic dsnless connection string, so I can use one set of pages connecting to different dabases (they all are the same, tables and fields, but different names.) A user chooses a database name, username and password. it is stored as a cookie, then it is retrieved to be used for the dsnless sting. The only way I know how, is below:

Sub Session_OnStart
Session("dbconn_ConnTimeout&quot = 30
Session("dbconn_CommandTimeout&quot = 60
Session("dbconn_CursorLocation&quot = 2
Session("dbconn_Host&quot = Request.Cookies("database&quot
Session("dbconn_UserName&quot = Request.Cookies("username" )
Session("dbconn_Password&quot = Request.Cookies("password" )

Session("dbconn_DsnlessString&quot = "DRIVER={MySQL};SERVER=66.xxx.xxx.xxx;DATABASE="&Session("dbconn_Host&quot&";UID="&Session("dbconn_UserName&quot&";PASSWORD="&Session("dbconn_Password&quot&""

End Sub

I can pull the variables from the cooke, but when I do a Response.Write Session("dbconn_DsnlessString&quot, nothing shows up.

Any Ideas?....

 

[snowboardr]

Try putting this part

strMySQL = "DRIVER={MySQL};SERVER=66.xxx.xxx.xxx;DATABASE="&Session("dbconn_Host&quot&";UID="&Session("dbconn_UserName&quot&";PASSWORD="&Session("dbconn_Password&quot&""

'# in a string first then put it in the session

Session("dbconn_DsnlessString&quot = strMySQL www.vzio.com
ASP WEB DEVELOPMENT

 

[dazzleblu]

Yes, it worked very well, thank you! I tried it in the global.asa file, and for some reason my chilisoft server is not reading my .asa files. So, I created a session veriable in the page, and replaced the string just like above, and it worked!! Then I used an include file, and used the session variable like above, and it worked also!

Thank You.

 

[dazzleblu]

Yes, it worked very well, thank you! I tried it in the global.asa file, and for some reason my chilisoft server is not reading my .asa files. So, I created a session veriable in the page, and replaced the string just like above, and it worked!! Then I used an include file, and used the session variable like above, and it worked also!

Thank You.