DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

SQL Server 2000 and VB 6

•

Join Date: Aug 2005

Posts: 4

Reputation: LadyFinger is an unknown quantity at this point

Solved Threads: 0

LadyFinger LadyFinger is offline

Offline

Newbie Poster

SQL Server 2000 and VB 6

Aug 8th, 2005

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?

•

Join Date: Feb 2005

Posts: 181

Reputation: Paul.Esson is an unknown quantity at this point

Solved Threads: 10

Paul.Esson Paul.Esson is offline

Offline

Junior Poster

Re: SQL Server 2000 and VB 6

Aug 8th, 2005

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

•

Join Date: Jul 2004

Posts: 200

Reputation: mnemtsas is an unknown quantity at this point

Solved Threads: 1

mnemtsas

Offline

Junior Poster

Re: SQL Server 2000 and VB 6

Aug 9th, 2005

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

Mark Nemtsas

Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books

•

Join Date: Jun 2005

Posts: 121

Reputation: jwshepherd is an unknown quantity at this point

Solved Threads: 5

jwshepherd jwshepherd is offline

Offline

Junior Poster

Re: SQL Server 2000 and VB 6

Aug 16th, 2005

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"

.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf