Microsoft OLE DB.....Timeout expired -- HELP !!!!

Posted on 2003-03-02
Medium Priority
Last Modified: 2008-01-09
Hi expert!

i've windows 2k advanced server as a Web Server with 2 network cards (external & internal ip), 'external' is linked to the internet and the 'internal' is link to my SQLserver with 192.168.10.x. the problem is when i make connection to SQL via simple ASP command by calling....

    Set oRs = Server.CreateObject("ADODB.Recordset")
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open session("MyConnectionString")

...then, the web page always raised an error like below...

Microsoft OLE DB Provider for SQL Server error '80004005'

Timeout expired

/myvirtual/myfile.asp, line xx

...the GLOBAL.ASA is so simple like this....

session("MyConnectionString") = "Provider=SQLOLEDB;Data Source=SQLSERVERNAME;Initial Catalog=MYDB;User ID=staff01;Password=staff01"

any idea?

I guess...may the problem will came from the routing table (both 'internal', 'external'), because when i disable the 'external' network card it can be establish the SQL connection properly (no so sure am i right???)

you will get 100 points from me for working solution....

many thank!
Question by:indigosmx
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 400 total points
ID: 8055760
Try replacing the
Data Source=<internal IP address>

LVL 11

Expert Comment

ID: 8057576
Normally a connection string to SQL looks like:

driver={SQL Server};server=[];uid=[UserID];pwd=[Password];database=[DBName]

Replace all values in [] with your fitting values!

Expert Comment

ID: 9276206
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.
LVL 11

Expert Comment

ID: 9276695
Try: session("MyConnectionString") = "driver={SQL Server};server=[];uid=[UserID];pwd=[Password];database=[DBName]"
LVL 12

Expert Comment

ID: 10994210
No comment has been added to this question in more than 245 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: angelIII http:#8055760

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question