More Visual Basic Answers
Question Library
Ask a question about Visual Basic
Volunteer
Experts of the Month
Expert Login
Awards
About Us
Tell friends
Link to Us
Disclaimer
|
| |
|
|
| |
| | | |
About Ravindra
Expertise
visual basic application programming from design to access information, sql, engineering and commercial applications. access databases, excel.
Optional:
1)a large number of people want me to do work which takes some time and effort. Pl.note that i would like to be paid for such work.
2) if you want me to spend quality time and do special work, i expect to be paid a reasonable price for my time.
3) if you are pleased with my reply you could consider a donation of 1$.
4) you can visit my website http://ravindra.coolpage.biz (under constrn)
Experience
Past/Present clients
project work for a Norway company, and a Canadian company completed. Freelance Project work and Teaching
teaching vb
| | |
| |
You are here: Experts > Computing/Technology > Basic > Visual Basic > VB6 & SQL Server 200
Expert: Ravindra
Date: 9/6/2008
Subject: VB6 & SQL Server 200
Question
QUESTION: I have a project on VB6 and the back end is SQL Server 2000. My problem is how am I to run the application in a network environment where many users can access the application and enter data. What steps should I take on this installation?
ANSWER: the path of the database must be made available.
if you can locate the path to the sql server from your computer then you can do it
---------- FOLLOW-UP ----------
QUESTION: Dear Ravindra
Thank you for the Answer.
When Find the path can I give a link to the application from the server or do I have to copy the application to all the computers in the network.
ANSWER: you can make an exe in one computer and others can get access this from other computers
---------- FOLLOW-UP ----------
QUESTION: Dear Mr. Ravindra How can I break this coding in to each line (row) since it is appearing in one line.
db.Execute "insert into pdcheque(customer,chqno,chqmonth,chqdate,chqbank,chqamount,status,invno,docno)values('" & CboCustomer.Text & "','" & TxtChqno.Text & "','" & m_mthyr & "','" & TxtChqDate.Text & "','" & TxtChqBank.Text & "','" & CDbl(TxtChqAmount.Text) & "','" & "I" & "','" & TXTINVNO.Text & "','" & TXTINVNO.Text & "')"
Answer
sample code:
esql = "insert into testable values" & "(" & "'" & Text1 & " '" & "," & Val(Text2) & "," & Text3 & ")"
conn.Execute (esql)
'further you can add the next steps
esql= esql & ....
esql=esql & ....
But you need to be very careful to do this.
put a break point at each point and check if proper string is being passed to the variables
Add to this Answer
Ask a Question
|
|
