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

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.

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

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?