Recent content by mimpuerto

Hello! I really want to know how to change password of an MS Access database through OLEDb. If I have db1.mdb, my connection string would be: gstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Jet OLEDB:Registry Path=;Jet OLEDB:Database Password=;Jet OLEDB:New Database...

I already solved the problem. My procedure is placed under user1 account. while my connection in asp is using user2 account. when calling the stored procedure in asp, you should specify the owner of the stored procedure. example: cnn.execute "user1.storedproc1" Hope this works for...

I have an ASP code calling an Oracle stored procedure with IN parameters. Code written as shown below: <% Dim Cnn Dim Cmd Set Cnn = Server.CreateObject(&quot;ADODB.Connection&quot;) Set Cmd = Server.CreateObject(&quot;ADODB.Command&quot;) Cnn.Open DBCONN Set Cmd.ActiveConnection = Cnn...

Hello! I have a problem calling a Crystal Report via ASP. The page was successfully loaded the Crystal Smart Viewer ActiveX. Unfortunately, records were not retrieved and a prompt saying &quot;User Session Has Expired&quot; is visible on my screen. I am using ADO (Data Definitions Only). During...

Hi. I have an Excel application. This application is opening multiple Excel files. The Excel file contains macros. The macro opens another Excel file. When triggered by a VB application, the macro is executed except all methods issued. Thus, if i issue OPEN method, the macro will just run the...