Database Connection with ASP

Results 1 to 2 of 2

Thread: Database Connection with ASP

  1. #1
    Join Date
    Dec 1969

    Default Database Connection with ASP

    Hi,<BR><BR>I have a problem where I can access my informix database with microsoft excel (get external data --&#062; new database query) but for some reason when I to try to access it on the web with asp code it doesn&#039t return anything. It seems as though asp didn&#039t even register, because anything within the &#060;% %&#062; doesn&#039t come out.<BR><BR>this is my code to connect to the database in asp:<BR>&#039 try logging into the database<BR>Set timesheetsConn = Server.CreateObject("ADODB.Connection")<BR>timeshe "DSN=amy;UID=informix;PWD=informix"<BR><BR>any help is truely appreciated!!<BR>Amy<BR>

  2. #2
    Danken Shih Guest

    Default RE: Database Connection with ASP

    Hi,Amy<BR>Your connecting code to informix with asp is correct.<BR>you could try this:<BR>&#039print out connecting state, if state=1 mean connecting OK <BR> Response.write conn.State&"<BR>" <BR>&#039print how mamy error messages <BR>Response.write "System has"& conn.Errors.Count&"errors<BR>"<BR><BR>I don&#039t know if this could help,try it.<BR>any question mail to

Posting Permissions

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