help - cannot connect to ODBC source

help - cannot connect to ODBC source

Post by David Leisne » Sat, 06 May 2000 04:00:00

I've got a web application that uses ASP pages, functions compiled into a VB
DLL, and an Access 2000 database.  This DB has a number of local tables, and
one external table linked via ODBC (the other RDBMS is called Synergy).

Here is the problem: after the DLL is compiled and registered, I receive the
message "ODBC - connection to 'Synergy Driver' failed", when one of the
functions attempts to SELECT from the linked Synergy table.

However, everything works fine if the DLL is in run mode.

Any suggestions?



--------to reply, remove _nospam from email address----------------


1. Cannot connect to Oracle-ODBC source from VBA!

Hi Folks!

Following problem, i try to accessa an oracle-odbc data
source from VBA.

Here is my code sample:

Dim rs As DAO.Recordset
Dim db As DAO.Database
Dim fld As DAO.Field

Dim ODBCConnectionString As String

SQLUser = "plm"
SQLPassword = "plm"
SQLDatabase = "plmdb"

ODBCConnectionString = "ODBC;DSN=" + SQLDatabase
+ ";UID=" + SQLUser + ";PWD=" + SQLPassword + ";"
Set db = OpenDatabase(SQLDatabase, False, False,
Set rs = db.OpenRecordset(" select sysdate from dual ",
dbOpenDynaset, dbReadOnly)

I fail everytime with runtime error 3078, "Microsoft Jet-
Database modul could not find entrytable or query"

The ODBC Source is set up correctly with ODBC Config
Assitent an tested!

Someone any ideas?


2. help:error '80004005'

3. cannot add MSAccess 97 data source in ODBC Data Source Admin

4. Support for QNX6, POSIX IPC and PTHREAD-style

5. BCP cannot connect to the Source Server.

6. JDBC DB/2 statement delimiter problem

7. Data Source: Programmatically Configuring an ODBC Data Source - HELP PLEASE

8. Help:ODBC Data Source Admin doesn't show Names of new Data Sources

9. Cannot configure Oracle ODBC data source

10. Cannot set up ODBC Data Source.

11. Connect to ODBC-source

12. Problem using a DLL to connect to ODBC Data Source