User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 401,693 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,681 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 7680 | Replies: 3
Reply
Join Date: Aug 2005
Posts: 4
Reputation: LadyFinger is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
LadyFinger LadyFinger is offline Offline
Newbie Poster

Solution SQL Server 2000 and VB 6

  #1  
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?
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2005
Location: Ballarat, Australia
Posts: 164
Reputation: Paul.Esson is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 6
Paul.Esson's Avatar
Paul.Esson Paul.Esson is offline Offline
Junior Poster

Re: SQL Server 2000 and VB 6

  #2  
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
Reply With Quote  
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation: mnemtsas is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 1
mnemtsas's Avatar
mnemtsas mnemtsas is offline Offline
Junior Poster

Re: SQL Server 2000 and VB 6

  #3  
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
Reply With Quote  
Join Date: Jun 2005
Location: Texas
Posts: 120
Reputation: jwshepherd is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 5
jwshepherd's Avatar
jwshepherd jwshepherd is offline Offline
Junior Poster

Re: SQL Server 2000 and VB 6

  #4  
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
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 8:08 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC