HELP, HELP, HELP Please Connection to remote database

Visual Basic

    Next

  • 1. run time error
    I built a vb program and installed to other workstation for test, the installation is completed and ok. but when i execute the program that the following error occured : ''''''''''''''''''''''''''''''''''' Run-time error '-214767259 (80004005) Method '~" of object '~' failed '''''''''''''''''''''''''''''''''' I can sure the program is complied and it can work smooth in other workstation. The program is connect to Oracle database to retrieve data. The workstation installed w2k sp4 IE6 sp1 and all the updates from windows update. Could anyone tell me how to solve the problem Thx & Rgds Frankie .
  • 2. Executing MS-Access Functions via VB6
    Hi, I have written a Query in Access which uses a function that I have written in an Access module: select * from myTable where myFunction([aDatabaseField]) = true This works fine if I run it from Access, but If I try to call this from a VB program: Set command = new ADODB.Command command.CommandType = adCmdStoredProc command.CommandText = "myQuery" rs = command.Execute Then I get an error: 'Undefined function myFunction in Expression' My question is, is it possible to tell VB/Access where to find the function, or is this technique just not possible. IE can I only access the data and not the code modules in my database via VB6? Thanks in anticipation of your help, Regards, ChrisM
  • 3. Problam with Knowledge Base Article - 240222
    Hi! This code was done with the help of Knowledge Base Article - 240222. It creates the link between two databases, but when I open the database the link table does not contain any data (original table contains data i.e. tblDetail). Can some one help me with this code please. ******************************************************************************* Public Function fn_CreateLink() 'Create Link... Set adoCat = New ADOX.Catalog Set adoCat.ActiveConnection = mMain.cnSetup_db Set adoTbl.ParentCatalog = adoCat adoTbl.Name = "tblDetail_Linked" 'remote database details adoTbl.Properties("Jet OLEDB:Link Datasource") = "E:\zNew\Dababase\db_Data.mdb" adoTbl.Properties("Jet OLEDB:Link Provider String") = "MS Access;Pwd=123" adoTbl.Properties("Jet OLEDB:Remote Table Name") = "tblDetail" adoTbl.Properties("Jet OLEDB:Create Link") = True 'Append the table to the tables collection adoCat.Tables.Append adoTbl Debug.Print "Link Created..." End Function ******************************************************************************* Thanks & Regards, Nalaka.
  • 4. Large volume of data
    Hi all, I need to retrieve large volume of data by ADO/VB6, can you guys tell me how to improve the speed. because the speed is very slow now. (Can I just browse the table, like using enterprise manager, in VB6??) Any example would be appreciated Douglas
  • 5. Newbie question: SQLOLEDB
    Hi, Which all databses does the SQLOLEDB support? Currently, I am using SQL server and connecting to it thro' my VB app using the .Provider= SQLOLEDB. So some day, if I change my database to say, MYSQL or MS Access will my app still work? If no, is there a work aroud by which my app can work for all DBs? Thanks and regards, Pranav.

HELP, HELP, HELP Please Connection to remote database

Postby Nikola Knezevic » Thu, 29 Jul 2004 17:43:58 GMT

I am trying to connect to remote ms acces mdb which is locate od web adress
 http://www.**--****.com/ 

name of database is:  real_estate.mdb

my dns name is DNS_real-estate

it tryed several times to test connection with this code and always get the
message "Unscpecified error", pointing to this line of code:
rd_informacije.Open "SELECT * FROM Informacije", db_real_estate

Can anyone please tell me what is wrong whit this code and how i can
retreive recordset information from this remote database from my VB app

db_real_estate.Open "Provider=MS Remote;" & _
          "Remote Server= http://www.**--****.com/ ;" & _
          "Remote Provider=MSDASQL;" & _
         "DSN=DNS_real-estate;"

Set rd_informacije = New ADODB.Recordset
rd_informacije.CursorType = adOpenForwardOnly
rd_informacije.LockType = adLockReadOnly

rd_informacije.Open "SELECT * FROM Informacije", db_real_estate
rd_informacije.close

Thank you in advance!

Nikola



Similar Threads:

1.Database Connection Problem. Please Help

Hi all,

I have a process which first pulls one time all application IDs from a 
database and stores them in a table(this process works fine everytime). I 
then loop through the table, one at a time, and use application id to pull 
details info and process it. For example, if I have 500 records in my table, 
then I would have to open database 500 times. Also between processing each 
record, my process sleep 3 seconds.

The problem is that after processing about 100 records, using SqlDataReader, 
my database connection will starts failing. When I traced the error in my 
try catch clause, the exception message just say connection fails to open 
database. I also found that all the subsequent connection also failed to 
open unless I stop my window service and restart it.

Would some one please give me a hand? I've been trying to find a way to pull 
all details for all records at once, instead of one at a time but I have not 
been able to do that.

Thanks in advance for everyone's suggestions

Regards,

Sam


Here is part of my process that pull details of an application base on 
applicationID
===============================
         Dim appReader As SqlDataReader

        appReader = GetDataReader("user_ApplicationDetails", _
                "@appID", appID)

        Do While appReader.Read ' Read applicat

              'process data
         Loop

     If Not appReader Is Nothing Then appReader.Close()

================================
Here is my function that returns sqldataReader

        Public Function GetDataReader(ByVal sStoredProc As String, ByVal 
sVarName As String, ByVal iInt As Integer) As SqlDataReader

            Dim aCommand As New SqlCommand

            Try

                aConnection = OpenConnection(aConnection) ' OpenConnection 
returns sqlconnection

                aCommand.CommandText = sStoredProc
                aCommand.CommandType = CommandType.StoredProcedure
                aCommand.Connection = aConnection

                aCommand.Parameters.Add(sVarName, iInt)

                Return(aCommand.ExecuteReader(CommandBehavior.CloseConnection))
            Catch e As Exception
                Throw New Exception(e.Message, e)
            Finally
                If aConnection.State.Open = True Then
                    aConnection.Close()
                    aCommand.Dispose()
                End If
            End Try

        End Function 


2.Need help with mstsc (RDP, Remote Desktop Connection)

3.help with Data Environment Connection String help?

I am New to using data environment, but I need some help. I am using data environment to connect to an 2000 access DB. and I have a data report to show data fromt he DB. I have a vb6 app that connects to the access DB, and the user can specify the path of the database.

I wanted to know How and were to put the code to refesh the connection string in the data environment and if so, data report as well, so when it load, it has the new path to the access DB. This is what I was thinking of using.

dbReportConnection.ConMPM.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & DP & "

I don't know if that is right, I just took a shot at it. Can anybody help.

I also need (if any body can help) to Be able to update while the aplication is running, EX. If a user enters a new cutomer, and I run the report, the cutomer does not show up, but if I exit the app, and reopen it, the customer is there. How can I open and close and update the connection string when I run the reports?

Thanks..

4.Problem whit remote data access !!!! PLEASE HELP

5.Guidence Please - VB6 Frame Work Studio and VB.Net - Help Help

Dear Anthony:

Thank you for your rapid reply however, is visual basic packeged with Frame 
Work, Studio and .Net?

How is it combned..

Waremst Regards,

Doug
-- 
Warmest Regerds

Doug


"Anthony Jones" wrote:

> "Clonecrp" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> > I am Confused.. Please help me put it together
> >
> > VB6 Frame Work Studio and VB.Net - So how do these all fit in.
> >
> > Is there a history of Visual Basic and it's equivenent today.. what is old
> > and what is current?
> >
> 
> VB6 old, VB.Net new.  Current version found in Visual Studio 2008 ( I think
> the VB version is sometimes refered to as VB9).
> 
> You can download an free express version of the studio for VB.NET from
> Microsoft.
> 
> 
> -- 
> Anthony Jones - MVP ASP/ASP.NET
> 
> 
> 

6. Help required with Word - Please help

7. MS-VB6 Help using Help Please

8. Need help with using Time comparison in code - please help



Return to Visual Basic

 

Who is online

Users browsing this forum: No registered users and 68 guest