For BAM, and anyone who can help

Results 1 to 6 of 6

Thread: For BAM, and anyone who can help

  1. #1
    DBNewbie Guest

    Default For BAM, and anyone who can help

    Bam,<BR><BR>I created an include file for my connection string, and this error has occurred before: how can I resolve it?<BR><BR>When I open my recordset, the connection argument matches my db connection name, and when i put it in an include I get thios error:<BR><BR>Arguments are out of acceptable range, or are in conflict with one another.<BR><BR>when i drop in the connection string, it works great. How can I work around this?<BR><BR>Thanks again for your time<BR>DBNewbie

  2. #2
    BAM Guest

    Default Post your code


  3. #3
    NPKumar Guest

    Default RE: For BAM, and anyone who can help

    Pls paste your code here.<BR>You might be using <BR> "Conn_String"<BR>Remove quotes and use Conn_String

  4. #4
    DBNewbie Guest

    Default RE: Post your code

    set db = server.CreateObject("adodb.connection") <BR>db.Open "Driver=SQL Server;Server=;UID=sa;PWD=;Database=Devel opment;"<BR><BR>set rs = server.CreateObject("ADODB.recordset")<BR>stmt = "SELECT * FROM states ORDER BY stateabbr"<BR><BR>rs.Open stmt, db, adOpenKeyset, ,adCmdText<BR><BR>its when i drop out the first 2 lines that the page borks

  5. #5
    BAM Guest

    Default RE: Post your code

    If you&#039;re using a db include file then you don&#039;t need the connection at the top of the page. You only need one or the other.

  6. #6
    NPKumar Guest

    Default RE: Post your code

    db.Open "Driver=SQL Server;Server=;UID=sa;PWD=;Database=Devel opment;"<BR>Try with the foolowing one.<BR>db.Open "Provider=SQLoledb; Server=;UID=sa;PWD=;Database=Development; "

Posting Permissions

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