Help for connecting Data Base

Results 1 to 2 of 2

Thread: Help for connecting Data Base

  1. #1
    Join Date
    Dec 1969

    Default Help for connecting Data Base

    Hi, I am newbie in programing in asp, How I can connect a data base in code asp to intranet´s server?<BR>Someone can I help me?<BR>Thanks.

  2. #2
    Adam Collis (Grrr Baby!!) Guest

    Default RE: Help for connecting Data Base

    Set DBConnection = Server.CreateObject("adodb.Connection") - Just Write it...It Sets up a Connection<BR><BR>DSN="Provider=MSDAORA.1;Password =amcollis;User ID=amcollis;Data Source=DSSA;Persist Security Info=True" - This is the Parameters for the Connection that you Created.<BR><BR>DBConnection.Open DSN - Opens the Connection with the Parameters you Created.<BR><BR>SQL="SELECT -bla bla bla" - Define your SQL <BR><BR>Set SQLRecordSet=DBConnection.Execute(SQL) - Connect, and Run your Querry!! :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts