Post reply

RE:

  • September 21, 2005 at 8:52 pm

    #67850

    please help me were can how to connect from visualbasic to SQL Server 2000? what will be the syntax of the command? please help me all visual basic developers.. i need pls...

  • September 21, 2005 at 10:16 pm

    #592073

    Please refer to MSDN, or here the simple VB script to connect to databse :

    set cn = CreateObject("ADODB.Connection")

    cn.Open "Provider = SQLOLEDB.1;Data Source = SERVERNAME;Initial Catalog=DATABASENAME;User Id=UserName;Password=Password"

  • September 23, 2005 at 12:27 pm

    #592713

    here's a website you'll probably bookmark: http://www.connectionstrings.com/

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply