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!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net