carlaferreira2
asked on
Variable Error connecting sql server 2005
Hi,
When I run the code below I get a runtime error saying: "The name "&a&" is not permited in this context. Valid expressions are....."
Dim MyDatabase As ADODB.Connection
Dim MyCommand As ADODB.Command
Dim MyRecordSet As ADODB.Recordset
Dim connStr As String
Dim a As Integer
a = 2
connStr = "Provider=SQLNCLI;Server=c aronte;Dat abase=Proj ectServer_ Reporting; Trusted_Co nnection=y es;"
Set MyDatabase = New ADODB.Connection
MyDatabase.CursorLocation = adUseClient
'MyDatabase.Properties("Pr ompt") = adPromptAlways
MyDatabase.Open (connStr)
MyDatabase.Execute "INSERT INTO[MSP_PMO_Teste]([id])V ALUES(""&a &"")"
How can I insert variables inside sql statements?
Thanks in advance!
When I run the code below I get a runtime error saying: "The name "&a&" is not permited in this context. Valid expressions are....."
Dim MyDatabase As ADODB.Connection
Dim MyCommand As ADODB.Command
Dim MyRecordSet As ADODB.Recordset
Dim connStr As String
Dim a As Integer
a = 2
connStr = "Provider=SQLNCLI;Server=c
Set MyDatabase = New ADODB.Connection
MyDatabase.CursorLocation = adUseClient
'MyDatabase.Properties("Pr
MyDatabase.Open (connStr)
MyDatabase.Execute "INSERT INTO[MSP_PMO_Teste]([id])V
How can I insert variables inside sql statements?
Thanks in advance!
INSERT INTO[MSP_PMO_Teste]([id])V ALUES('" & a & "')
yes, like this:
MyDatabase.Execute "INSERT INTO[MSP_PMO_Teste]([id])V ALUES(" & a & ")"
MyDatabase.Execute "INSERT INTO[MSP_PMO_Teste]([id])V
MyDatabase.Execute "INSERT INTO[MSP_PMO_Teste]([id])V ALUES('" & a & "')"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.