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?
LadyFinger 0 Newbie Poster
Paul.Esson 53 Junior Poster
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
mnemtsas 3 Posting Whiz in Training
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.aspx?tabid=87#OLEDBProviderForSQLServer
jwshepherd 0 Junior Poster
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"
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.