Re: Oracle connection string in .dqy file

Update, we just moved our server from 9i to 10g and the connection
string works fine. Must be something with 10g that it understands the
string?

jim.brown1@xxxxxxxxx wrote:
I'm attempting to embed Oracle connectivity in a MS Query file (*.dqy).
The purpose for creating a dqy file, is so that it can be distributed
to other users. My goal is to create the file, without having to rely
on the tnsnames.ora file. As an example, I'm able to create a *.dqy
file and have it function correctly, when the contents of the file, is:

XLODBC
1
DRIVER={Microsoft ODBC for
Oracle};UID=<username>;PWD=<password>;SERVER=<server name in the
tsnames.ora file>;
...
But this relies on a tsnmaes.ora file.

Alternatively, I would like for this to work:
XLODBC
1
DRIVER={Microsoft ODBC for Oracle};UID=<username>;PWD=password>;
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=<sid>)));
...

Unfortunately, it doesn't - a dialog titled "Microsoft ODBC for Oracle
Connect" pops up - the username and password is populated correctly,
but the server contains the completed string listed above
(SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=<sid>)))

What if anything, am I do wrong? Thank your for your help.

.

Relevant Pages

  • SQL Connection Problem
    ... An error has occurred while establishing a connection to the server. ... database location within the applications App_Data directory. ... Boolean& failoverDemandDone, String host, String failoverPartner, String ... user, String password, Boolean trusted, String connectionString) +68 ...
    (microsoft.public.dotnet.framework.aspnet)
  • server-side JavaScript: Prototypes of built-in classes, objects and functins
    ... Session object (disk-based session variables for data persistence ... File class (manipulation of files on server, ie. open, close, read, ... //Methods Cgi.queryCgi.postCgi.anyby default return an empty string if requested var not found ...
    (comp.lang.javascript)
  • Re: App_data - ASPNETDB.MDF
    ... is only because I want my site work, without exception. ... Server Error in '/' Application. ... serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SSP backup
    ... 2)MOSS_SETUP_FARM is a dbo on the config database. ... Application Server Administration job failed for service instance ... name, ApplicationPoolIdentityType identityType, String userName, SecureString ... password, TimeSpan idleTimeout, TimeSpan periodicRestartTime) at ...
    (microsoft.public.sharepoint.windowsservices)
  • Web Part and Access database
    ... Server Error in '/Webparts' Application. ... SQLExpress database file auto-creation error: ... The connection string specifies a local Sql Server Express instance ... String user, String password, Boolean trusted, String connectionString) ...
    (microsoft.public.sharepoint.portalserver.development)
Loading