ole32.dll HTTP 500. Error

[choosesg]

Having a hard time trying to deploy my website, http://choosesggirls.heliohost.org/ Can anyone help me or point me in the direction of my error? I am trying to use ASPX with postgres database. Thanks! Username: choosesg

 

ole32.dll

Description: HTTP 500. Error processing request.

 

Stack Trace:

 

System.DllNotFoundException: ole32.dll

at (wrapper managed-to-native) System.__ComObject:CoCreateInstance (System.Guid,intptr,uint,System.Guid,intptr&)

at System.__ComObject.Initialize (System.Type t) [0x00000] in <filename unknown>:0

at (wrapper remoting-invoke-with-check) System.__ComObject:Initialize (System.Type)

at Mono.Interop.ComInteropProxy.CreateProxy (System.Type t) [0x00000] in <filename unknown>:0

at System.Runtime.Remoting.RemotingServices.CreateClientProxyForComInterop (System.Type type) [0x00000] in <filename unknown>:0

at System.Runtime.Remoting.Activation.ActivationServices.CreateProxyForType (System.Type type) [0x00000] in <filename unknown>:0

at <0x00000> <unknown method>

at WebApplication1._Default.Page_Load (System.Object sender, System.EventArgs e) [0x00000] in <filename unknown>:0

at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] in <filename unknown>:0

at System.Web.UI.Control.LoadRecursive () [0x00000] in <filename unknown>:0

at System.Web.UI.Page.ProcessLoad () [0x00000] in <filename unknown>:0

at System.Web.UI.Page.ProcessPostData () [0x00000] in <filename unknown>:0

at System.Web.UI.Page.InternalProcessRequest () [0x00000] in <filename unknown>:0

at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] in <filename unknown>:0

 

--------------------------------------------------------------------------------

[choosesg]

ole32.dll

Description: HTTP 500. Error processing request.

 

found out that this happens when i try to connect to the postgres database. currently i used this:

db.Open("DSN=PostgreSQL30;Server=localhost;Port=5432;Database=choosesg_main;Uid=choosesg;Pwd=[correct password];")

 

is my connection string to the database correct? any help is greatly appreciated!

 

[Wizard]

Database and ID is wrong. IIRC, it should be [username]_[whatever name you gave to the database]. Likewise for ID.

[choosesg]

Thanks for replying!

 

I have tried many times trial and error but still cant get it to work on:

db.Open("Server=localhost;Port=5432;[Database]_[choosesg_main];[uid]_[choosesg];[Pwd]_[valid password];")

 

On development I am currently using this which is working but now trying to deploy on heliohost:

Dim db As ADODB.Connection

db = New ADODB.Connection

db.Open("Server=localhost;Port=5432;Database=choosesg_main;Uid=choosesg;Pwd=[valid password];")

 

I have a Database created using phppgadmin, so database name should be correct. Using postgres currently. Please help me as I cant get my site up

 

Thanks!

 

 

 

[Wizard]

Did you add a user to the database with the proper permissions? My cPanel username is wizard. If I were to create a user named "user" for a database named "db", my user and database name would be wizard_user and wizard_db.

[Guest Geoff]

 

db.Open("DSN=PostgreSQL30;Server=localhost;Port=5432;Database=choosesg_main;Uid=choosesg;Pwd=[correct password];")

 

This code appears to be correct. I think the error that you are getting is caused by ole32.dll not being in your bin folder.

 

This might be a problem with the mono configuration; I would try this:

 

1. Download ole32.dll here: http://dll-download.net/download-ole32.html

2. Unzip the file, and copy the dll to some place you can find it

3. Create a folder called bin, inside the root of your application

4. Upload ole32.dll to the bin folder that you just created.

 

Then try running your site again.

[choosesg]

db.Open("DSN=PostgreSQL30;Server=localhost;Port=5432;Database=choosesg_main;Uid=choosesg;Pwd=[correct password];")

 

This code appears to be correct. I think the error that you are getting is caused by ole32.dll not being in your bin folder.

 

This might be a problem with the mono configuration; I would try this:

 

1. Download ole32.dll here: http://dll-download.net/download-ole32.html

2. Unzip the file, and copy the dll to some place you can find it

3. Create a folder called bin, inside the root of your application

4. Upload ole32.dll to the bin folder that you just created.

 

Then try running your site again.

 

Thanks for replying! Have tried downloading and adding the ole32.dll file to bin:

 

Still not working

 

But have narrowed down the error! sorry about it seems like this line is throwing the error:

Dim db As ADODB.Connection

The aspx page fuctions well when i remove this. cant use ADODB? but i added the ADODB.dll in the bin folder as well.

 

Please help and advice again. Greatly appreciated

 

[Guest Geoff]

You have to remeber that you are not dealing with ASP.NET here, you are dealing with Mono. Similar, but not the same. After some googling, I found that

 

1. Mono does not support the object you are using (found here)

2. There Is a substitute, but it only works with MySQL (found here)

 

Also, I found that the library that you are using is OLD, so maybe consider upgrading to a new db interface, like Connector NET.

 

PS: Your site is down at 18:23 CST 11/03/2010. It is giving an empty response.