I am using a VB6 application as frontend on client machines and SQL 2005 Enterprise as backend database installed on Win XP Pro machine (4GB Mem/Core2Duo 2.6GHz).
Through the VB6 application, we use the following string to connect to SQL 2005 database.
login.connstring = "Provider=SQLOLEDB.1;Password=pwd123;Persist Security Info=True;User ID=sa;Initial Catalog=MYDB123;Data Source=XPProMachine"
The VB6 application, connects to the database, queries the database, displays the results, disconnect from database.
View Complete Post