I have an application in Visual Basic 6 with SQL Server as the back-end. It is supposed to be run on a server, but it will not access the server when installed and run on a client’s machine. I think it might be a code issue; I have used the following coding at form load:
cnh = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Pharmacy;Data Source=WIN2006"
db.CursorLocation = adUseClient
Is this code accurate?
September 11, 2008 5:40 PM
September 12, 2008 1:59 AM