Correct coding to executing MS SQL file in VBS script

Avbrutt Lagt ut 6 år siden Betales ved levering

$10-30 USD

Betales ved levering

Avbrutt Betales ved levering

I need to correct the code below as it gives me error as shown in the attached file

======

Dim oConn

If not isObject(oConn) then

Dim Connstr

Set oConn = CreateObject("[login to view URL]")

[login to view URL] = 1

set fs=CreateObject("[login to view URL]")

Set oRs=CreateObject("[login to view URL]")

Connstr="Provider=SQLNCLI11;Persist Security Info=False;Data Source=******;Initial Catalog=qdcostdb1;User Id=sa;Password=sa***"

[login to view URL] Connstr

set f=[login to view URL]("C:\Job\[login to view URL]",1,true)

strQuery=[login to view URL]

[login to view URL]

[login to view URL](strQuery)

'Set oRs = [login to view URL](strQuery)

End if

Microsoft SQL Server SQL Visual Basic

Prosjekt-ID: #15705042

Om prosjektet

11 bud Eksternt prosjekt Aktiv 6 år siden

Ønsker du å tjene litt penger?

Fordeler med budgivning på Freelancer

Oppgi ditt budsjett og tidsramme
Få betalt for ditt arbeid
Skisser ditt forslag
Det er gratis å registrere seg og by på jobber

11 frilansere byr i gjennomsnitt $28 for denne jobben

schoudhary1553 sitt profilbilde
schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience in M Mer

$30 USD på 1 dag
(158 Omtaler)
7.6
vmadhavan15 sitt profilbilde
vmadhavan15

I am not a tandom bidder. I have 14+ years of exp and I hope I can fix this one. Please ping me if you are interested on my proposal. Thank you

$30 USD på 1 dag
(29 Omtaler)
5.1
bnrajumnc sitt profilbilde
bnrajumnc

write the correct VBA code to load the text file data into MS SQL database. Relevant Skills and Experience V,B, SQL SERVER Proposed Milestones $45 USD - write the correct VBA code to load the text file data into MS S Mer

$45 USD på 1 dag
(9 Omtaler)
3.7
zameerfaiz sitt profilbilde
zameerfaiz

Greetings, I'll fix error in your vb code. Relevant Skills and Experience I am experienced .Net developer with hands on knowledge and experience in VB. Proposed Milestones $30 USD - Project milestone

$30 USD på 1 dag
(1 anmeldelse)
2.4
jitendrabaraiya sitt profilbilde
jitendrabaraiya

i can do your job

$30 USD på 3 dager
(1 anmeldelse)
2.1
brzijax sitt profilbilde
brzijax

I will check where is problem. Relevant Skills and Experience I am master for SQL and I will check whether problem is in some services or code. 15 years SQL admin and programmer in Delphi,VB,C# on SQL as DBMS. Propos Mer

$25 USD på 3 dager
(1 anmeldelse)
2.1
vsvinaysimha sitt profilbilde
vsvinaysimha

will work as per your requirement with good quality Relevant Skills and Experience Excel VBA Proposed Milestones $25 USD - will work as per your requirement with good quality will work as per your requirement with g Mer

$25 USD på 1 dag
(0 Omtaler)
0.0
vw1676486vw sitt profilbilde
vw1676486vw

A proposal has not yet been provided

$28 USD på 3 dager
(0 Omtaler)
0.0
davidmesm sitt profilbilde
davidmesm

The error is not in the code, well not exactly. The problem is the query which is being run. With SQL tracer we can see the error on the query and correct the problem. Habilidades y experiencia relevante SQL, Oracle, Mer

$25 USD på 2 dager
(0 Omtaler)
0.0
Legg ut et slikt prosjekt