SQL Server 2000 and VB 6
 

hi...i have an assignment which is to develop a registration system by using SQL 2000 and vb 6...the problem is i don't know how to integrate vb 6 with SQL server 2000.
any idea how can i do that?

Re: SQL Server 2000 and VB 6
 

Can't use VB.NET... ADO.NET is really easy to work with IMO

anyway, if you want to use vb6 have a look at the DB tutorials here
http://www.tutorialized.com/tutorial/SQL-in-VB/3889

Re: SQL Server 2000 and VB 6
 

Try looking at my ADO tutorial (http://www.timesheetsmts.com/adotutorial.htm) and using a different connection string for SQL Server. You can read about SQL Server connection strings here: http://www.carlprothman.net/Default....erForSQLServer

Re: SQL Server 2000 and VB 6
 

same as using ado and ms access change the connection string :

"Driver={SQL Server};Server=BMC;Address=xxx.xxx.xxx.xxx:1433;Network=DBMSSOCN;Database=dbPos;Uid=SQL;Pwd=sql"