Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: Problem while connecting to FDR

    Hello,

    I am having a problem while opening DB connection to FDR database through ADO.

    Here is the code.....

    conStr = "DSN=<DSNName>;UID=<UserID>;PWD=<PWD>;database ="
    Set cn = Server.CreateObject("ADODB.Connection")
    cn.Open conStr

    The following error is occuring whenever "cn.Open" gets executed.....

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [INTERSOLV][ODBC SQL Server driver][SQL Server]ct_init(): network packet layer: internal net library error: Attempt to spawn thread failed
    /CRM1/Results1SCP.asp, line 70

    Does any one know fix for this?

    Additional Information:
    1. I am using ChiliASP & SQL Server....Both DB Server and Web Server are on Windows Platform...
    2. DSN is created using Sysbase Driver in order to connect to FDR database...

    Thanks,
    Arun

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    I'm sorry, maybe I didn't catch something, so bear with my questions here.

    You have SQL Server, but you're using a Sybase driver to connect to it? When you test the DSN, does it connect?

    What is an "FDR" database?

    Why do you have to use a DSN? DSN-less connections have less overhead and more portability.
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Aug 2004
    Posts
    2
    Thanks for your reply...

    Well, the SQL Server is being used for reporting purpose. The reporting data is nothing but copy of Mainframe Database.

    Now, to pull the Mainframe data we are using FDR. FDR will provide access to Mainframe. So, I must connect to the FDR in order to pull the data from Mainframe.

    In order get connected to FDR we should use Sybase driver!

    I donno whether I can make use of DSN-less connection or not.

    Will that make any difference while opening the Database connection?

    Thanks
    Arun

  4. #4
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Ok, so you have two DBs? Mainframe and SQL Server? You can do the SQL Server connectivity with a DSN-less connection, but I don't know anything about FDR.

    Are you getting the error opening a connection to the SQL Server, or to the Mainframe?
    That which does not kill me postpones the inevitable.

Posting Permissions

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