Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Connectivity using MS Visual Basic 6.0

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-10-26 : 08:48:14
Mrunalini writes "How do I work with MS SQL Server with MS Visual Basic 6.0 as front end?"

nr
SQLTeam MVY

12543 Posts

Posted - 2004-10-26 : 09:53:31
see
http://www.nigelrivett.net/VB6DataAccessLayer.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

tuenty
Constraint Violating Yak Guru

278 Posts

Posted - 2004-10-26 : 12:21:18
if you don't know for sure the values of Server, Database, User, PWD or provider or you
having trouble with the connection then you can cheat a bit
**create an empty text file and change the extension to udl
**then double click on the file a fill the fields and test the connection until it works
**open the file with notepad and copy/paste the connection string
conn.ConnectionString = "copied string"
or set the connection string as
conn.ConnectionString = "File Name=\\yourPath\yourFile.udl"


*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*

A candle loses nothing by lighting another candle
Go to Top of Page
   

- Advertisement -