Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - VB/RDO/SQL Server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

VB/RDO/SQL Server
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Topic: VB/RDO/SQL Server
    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.
Back to Top
God_Struth View Drop Down
Senior Member
Senior Member
Avatar

Joined: 07 August 2003
Location: United Kingdom
Status: Offline
Points: 218 		Post Options Post Options   Thanks (0) Thanks(0)   Quote God_Struth Quote  Post ReplyReply Direct Link To This Post 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......"
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 11 December 2003 at 7:28pm
Thank you!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.