Previous Topic Next Topic

How to connect db through input from userform

Closed
Aadi - Nov 17, 2016 at 01:11 PM
yg_be Posts 24281 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 - Nov 17, 2016 at 03:53 PM
Hello,

i need to connect to db server with the inputs from the userform. here is the code. Please correct/add if any.

user = Val(REPORT.TextBox1.Value)
pwd = Val(REPORT.TextBox2.Value)
db = Val(REPORT.TextBox3.Value)
strCon = "Driver={Microsoft ODBC for Oracle};CONNECTSTRING=db;uid=user;pwd=pwd;"
connect.Open (strCon)

1 response

Answer 1 / 1
yg_be Posts 24281 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 5
Nov 17, 2016 at 03:53 PM
Does that work as is?

Similar discussions

Input phone lock code
Lucas -
M.Mudasir -

3 responses
Forgotten input phone lock code
jared -
closeup22 -

1 response
phone lock <SOS>
keary88 -
Ambucias -

1 response
Phone lock code
jax -
Ambucias -

1 response
Can you rename the inputs on LG Smart TV (WebOS)?
sjdunning -
dhh1 -

4 responses