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.
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 |
|
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 |
|
|
|
|
|