Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to use queryman to connect to Oracle Database
- Thread starter frankycat
- Start date
- Thread starter
- #3
Hi user3000
thanks for your reply. I have a doubt whether I should use ODBC driver for teradata or Microsoft ODBC driver for Oracle to connect.
When I have used Microsoft ODBC driver for Oracle, an error message "Invalid Connection String Attribute" apprear.
I can't use it to link the database in Access.
When I have used ODBC driver for teradata, an error message "10065 WSA E HostUnreah: The Teradata serve can't currently be reached over this network." appear.
Could you please show me the steps so that I can use queryman. Many Thanks
thanks for your reply. I have a doubt whether I should use ODBC driver for teradata or Microsoft ODBC driver for Oracle to connect.
When I have used Microsoft ODBC driver for Oracle, an error message "Invalid Connection String Attribute" apprear.
I can't use it to link the database in Access.
When I have used ODBC driver for teradata, an error message "10065 WSA E HostUnreah: The Teradata serve can't currently be reached over this network." appear.
Could you please show me the steps so that I can use queryman. Many Thanks
HI frankycat,
To connect to Oracle u need to create a DSN for Oracle.. You can create your DSN by
Control Panal->Data Source(ODBC)->System DSN->ADD-> Microsoft ODBC for Oracle. for this u need some component which we get during Oracle Instalation. Here I cant understand where the access database come. Do you want to connect to Access or Oracle. To access Queryman to u r Access database u would need a DSN for access.
User3000
To connect to Oracle u need to create a DSN for Oracle.. You can create your DSN by
Control Panal->Data Source(ODBC)->System DSN->ADD-> Microsoft ODBC for Oracle. for this u need some component which we get during Oracle Instalation. Here I cant understand where the access database come. Do you want to connect to Access or Oracle. To access Queryman to u r Access database u would need a DSN for access.
User3000
- Thread starter
- #5
hi user3000,
Sorry i make you confused. What i want to say is that When I use access to link to the oracle database by ODBC, I have used the "Microsoft ODBC Driver for Oracle" to build the linkage between Access and Oracle database. However, I can't use the same driver to build a linkage between Queryman and Oracle database. An error message appear "Invalid Connection String Attribute".
As I don't know which driver I should use, I have tried to use the driver "ODBC driver for teradata" to build a linkage between queryman and oracle database, however, an error message appear : "10065 WSA E HostUnreah: The Teradata serve can't currently be reached over this network."
I hope you could understand what I am talking about.
Sorry i make you confused. What i want to say is that When I use access to link to the oracle database by ODBC, I have used the "Microsoft ODBC Driver for Oracle" to build the linkage between Access and Oracle database. However, I can't use the same driver to build a linkage between Queryman and Oracle database. An error message appear "Invalid Connection String Attribute".
As I don't know which driver I should use, I have tried to use the driver "ODBC driver for teradata" to build a linkage between queryman and oracle database, however, an error message appear : "10065 WSA E HostUnreah: The Teradata serve can't currently be reached over this network."
I hope you could understand what I am talking about.
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question