hi,
I developed one application in visual basic 6.0 with the backend of Sql server 2000.
I want this application can be run in all client level. what i did is i installed windows 2003 server and sql server 2000 in one system and i copied the exe file of the application in all the client level which is already installed vb 6.0 also. The database is available in main server but it is not working. what should i do ? Can any one help on this with step by step instructions.
Thank you.
go to control panel/administrative tool/ data sources
once you run the data sources
click SYSTEM DSN
click add and locate the database of your system
name it EX. "MYDSN"
on your VB code
just do something like this
conn.open "DSN=MYDSN"
now all the copies of ur .exe will point to a single Database
use Active Data Objective (ADO).
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.