2. ASPRunnerPro General questions
  3. Microsoft OLE DB Provider for ODBC Drivers error
This topic is locked

Microsoft OLE DB Provider for ODBC Drivers error

 		2/11/2008 11:19:54 AM
ASPRunnerPro General questions
A
 adamsville2k author

Hi,
I've setup ASPRunner Pro 5.1 on my XP PC. From a Unxi Informix Database, I want to export and create a Windows database stored on a Win2k Server SP4 which run IIS. I've created both and virtual directory in which the database is srored. All the step by step process of creating the project just works fine but when trying to connect to the project using Iexplore, I got the following:
The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the levesque-01 home page, and then look for links to the information you want.

HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/asp/include/dbcommon.asp, line 117
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322)
Page:

GET /asp/login.asp
Time:

11 février 2008, 10:53:38
More information:
What is worng I don't know but want to fix it...
Thanks in advance.
Adam
Sergey Kornilov admin 2/11/2008

Adam,
you need to clarify the following for me:

"From a Unxi Informix Database, I want to export and create a Windows database"
A
 		adamsville2k author 2/12/2008

Hi Sergey,
Well all it means is simple, the source is fron a Unix Informix database and of cours the ASP result is stored on a Won2k server. I'm sorry about that because it is not clear!!
Thanks
Adam
A
 		adamsville2k author 2/12/2008

I found out whta was wrong but now have this one:
HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[SCO Vision][ODBC Driver]SQL-Retriever Server - Syntax error

/asp/include/commonfunctions.asp, line 1020
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322)
Page:

GET /asp/emp1_list.asp
Time:

12 février 2008, 11:42:28
J
 		Jane 2/13/2008

Adam,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
A
 		adamsville2k author 2/13/2008

Hi Sergey,
Sorry I don't understand what is Demo Account???
Steve
Sergey Kornilov admin 2/13/2008

Demo Account button can be found on the last screen in ASPRunnerPro.
A
 		adamsville2k author 2/13/2008

Sorry but I don't see that button....
Sergey Kornilov admin 2/13/2008

Adam,
my bad, Demo Account won't work with Informix.
Zip and send the whole project folder to support@xlinesoft.com along with your order number..
A
 		adamsville2k author 2/18/2008

Hi Sergey,
I got it to work thru SQL Server . I exported one of the database table using SLQ 2000 and proceed with ASPRunner to create a project. I can now access the new created ASP pages with no problem and I rather program it in using duplicates databases instead of the production tables.
Thanks for your support.
Adam