Re: test connection failed

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 04/05/04


Date: Mon, 5 Apr 2004 10:12:45 +0400


.udl contains connection string and path to database (for Microsoft Jet
provider) as Data Source property. Be sure that you copy database into the
same directory as on your XP machine or edit .udl file with notepad.

Check also that you have Jet provider installed or install Jet SP from
Microsoft.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Terry" <cooleyt@woh.rr.com> сообщил/сообщила в новостях следующее:
news:407039dc$1@newsgroups.borland.com...
> Using Microsoft access, ADO and D6.
> Implemented an application on XP. Using a .udl file for the connection to
> the database.
> I need to run the application on an NT4 machine. I installed MDAC 2.8 on
> the NT4 machine, and copied the .udl, the database, and the exe to the NT4
> machine. When testing the connection, on the Provider tab I selected
> Microsoft Jet 4.0 OLE Provider, and on the Connection tab, the database
etc.
> I get the following error:
> 'Test connection failed because of an error initializing provider.
> Unspecified error.'
>
> Any ideas??
>
> Thanks
>
>



Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Closing Jet Database seems unreliable
    ... Could it be that JET has not finished writing the cache to the database? ... and the connection ... I want to do this so that my app can backup or restore the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access Lock Remains after Connection Closed - OLE DB / Jet
    ... I have used this provider for serveral years against Access ... I release the provider, the connector checks if the connection is open, ... It then disposes of the connection, ... The database is an empty template database that is ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Explorer CPU Usage while accessing database
    ... Since Jet is a file-based database, the answer is: ... I suspect you are seeing the Jet delayed-write system in action. ... creates an idle period, during which Jet (and any other processes that are ... opening your connection before each insert and closing it immediately after ...
    (microsoft.public.scripting.vbscript)