General Discussion - VB/RDO/SQL Server

Print Page | Close Window

VB/RDO/SQL Server

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8015
Printed Date: 30 March 2026 at 3:03pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: VB/RDO/SQL Server

Posted By: Gullanian
Subject: VB/RDO/SQL Server
Date Posted: 11 December 2003 at 6:35pm

Looked for a bit on google, cant find anything useful on how to connect to a remote SQL Server database through VB?

Any links to tutorials or code snippets appreciated, thanks. Im trying to make desktop software for my Live Support software.

Replies:

Posted By: God_Struth
Date Posted: 11 December 2003 at 7:16pm

oConn.Open "Provider=sqloledb;" & _

             "Network Library=DBMSSOCN;" & _

             "Data Source=xxx.xxx.xxx.xxx,1433;" & _

             "Initial Catalog=myDatabaseName;" & _

             "User ID=myUsername;" & _

             "Password=myPassword"

http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/ado270/htm/pg_ado_providers_6.asp

-------------
"I'm only trying to help......"

Posted By: Gullanian
Date Posted: 11 December 2003 at 7:28pm

Thank you!