Sometimes when I start toad it does not start at all, it just hangs, I don't get the logo even after restarting the PC. What could be wrong? I am using toad 7.2.0 under window 2000.

Speed - We had an app that used the ODBC bridge to write data to an Access database. When we switched it over to use Jackcess, it was 5 times faster.

That depends whether you generally use your towed vehicle a lot when RVing, or not. There's also the extra insurance cost to consider. You will have to unhook almost every night to park. A towed car with very low ground clearance or towed on a dolly is a considerable negative. However, most of our guests who leave the toad at home end up regretting it.

The test button works fine, but I cannot login. I turned on "Show Reason in Access Denied Message" and it just says "Bad Password" :-( How to setup SQL database on a different machine, not on the webserver itself. (Can also help with a W2K3 SP2 permissions issue)

For some reason you get an 'OleInitialize' error if you open an OLE application first and then open an ODBC connection to the Access ODBC driver. If you do it the other way around, there is no problem with this. It looks like the Access ODBC driver calls OleInitialize(). This fails when Win32::OLE already initialized the COM subsystem as "apartment threaded".

I am trying to use an SQL database which uses trusted (or mixed) security. The Test button works but it doesn't let me in. however I am getting 31, ODBC error with statement, error number is: 3704 The operation requested by the application is not allowed if the object is closed. I've moved on from the Standard and Custom ODBC Select statement and I am in the process of setting up with the "Advanced" ODBC string. Tell me more about this.

It is necessary to include the following line before first connect: SrvApiDLLs[stOracle] := 'ORA73.DLL'; // for Oracle 7.3.x or SrvApiDLLs[stOracle] := 'ORA72.DLL'; // for Oracle 7.2.x After that you can use a connect string '2:ORCL' for TSDDatabase.RemoteDatabase property for login without TNS.

As of VB ELF 2.0, we now support SQL Server 7.0 T-SQL as well as Oracle's PL/SQL dialect. Every feature available in the earlier Jet-only version of the software has been extended to these new dialects -- whether or not they are natively supported by the language. In other words, you can ask pivot table questions, like: "Show the average order subtotal, giving the customer down and month of order date across during 1999." -- VB ELF will create SQL for either SQL Server 7.

I have a bunch of users in the internal database, and I want to convert to using an SQL database. (Convert to SQL). ODBC return error -51 rows. This is AUTHX_ODBC_NO_CONNECT, and means that the software cannot connect to the database. When I protect a subdirectory of a frontpage directory, I cannot edit it with Frontpage (or Visual Interdev)!

ASP-db hooks up to the data sources via ODBC, OleDB, SQLClient and OracleClient drivers supplied by either Microsoft or the database vendor directly. The difference in database operation syntax have been resolved internally in ASP-db such that user can switch from one datasource to the other just by changing the DBType property.

If you don’t have a database entry specified in your Oracle TNSNAMES.ora, you can make a connection using easy connect naming. This lets you connect to an Oracle database using only a TCP/IP connect string made up of a host name, port, and service name. You can run a test of OCI8 using Easy Connect Naming as follows (substituting the appropriate values for your password, server, port, and database): ruby -r oci8 -e "OCI8.new('hr', 'hr_password', '//server.company.com:1521/orcl').

well as reading the Subversion FAQs, if you're here looking for Subversion help, you should read the Subversion Good Practice Guide before doing anything else.

Answer: There are two ways you can connect to an Oracle database. The first way is to go through ODBC (see TechNote 8167 for details on how to create a datasource). The second way is a direct connection to Oracle. Connections to Oracle 8.0.4 and Oracle 8.1.6 (or 7) are supported. Oracle 9i is supported with the updated MicroStation Oracle server files available from Web Downloads. See FAQ 6228 for more information.

The Oracle server for class work has been pundit.bus.utexas.edu. We are retiring this machine in favor of a machine that has a less costly maintenance plan. Also, we are upgrading from Oracle 8.0 to Oracle 8i. The new Oracle machine is prophet.bus.utexas.edu. This machine is now running Oracle 8i and the OS is RedHat Linux. For security purposes, telnet has been disabled on this machine.

Open DataBase Connectivity (ODBC) is a standard database access method that allows access and modification of data from any application, regardless of which database management system is handling the data. ODBC connection establishes a link between your database, the ODBC drivers, and your application. You create a database using the database program of your choice and then use the driver (corresponding to the application) to create a data source name (DSN).