Hide connection string in SQL pass through

Hi,

We are using MS access front end to a Oracle back end database. A
number of the forms use pass-through queries. We are using a global
user name and password to create the pass-throughs so that all users
can access the data. However that user name and password is visible in
the pass-through. Is there any way to hide login information in the
connection string ? Any help will be appreciated.

Thanks
Thangam

0
Tangz
5/7/2007 9:48:30 PM
access.queries 6343 articles. 1 followers. Follow

0 Replies
1726 Views

Similar Articles

[PageSpeed] 18

Reply:

Similar Artilces:

NO INTERNET CONNECTION
this is very frustrating: i am unable to connect to the internet - heres the story: my system runs xp sp2 with an msi motherboard (ms 7093, ati radeon xpress 200, athlon 64 bit, rs480m2 (socket 939)), realtek alc658c audio that uses a realtek ac'97 driver and a creative sb x-fi soundcard, a siemens speedstream 4100 modem, a realtek 8139 family pci fast ethernet nic and a d-link g510 wireless pci adapter. my device mgr indicates that under network adapters, i have working a 1394 net adapter, d-link adapter, and a rtl8139. under "other devices," i only see a yel...

Hide divo error
I have the following formula in cells for future months. I would like to hide he divo result for months wihout data. my formula is =F37/SUM(F37:F38) I tried to enter this as =IF(ERROR(F37/SUM(F37:38)),"-",F37/SUM(F37:38) as I found in online help. This formula does not work either. Can anyone give me the correct formula to hide the divo error message for my formula? -- Cassie Try this one: =IF(ISERR(F37/SUM(F37:F38)),"-",F37/SUM(F37:F38)) Micky "Cassie Rodgers" wrote: > I have the following formula in cells for future months. I ...

How can I monitor open database connections?
I need to resolve some issues with a website which is leaving database connections open, according to the hosting company! The ASP code is quite extensive, and it's going to be quite a job trawling through it. Is is possible to see a count of the open database connections? That way I could monitor this while using the website, to pinpoint the pages that are leaving open connections. Would connection pooling leave open connections, even though they are closed in code? Thanks in advance. Doug You can query the database to see how many active connections there are. But ASP normally uses...

Install SQL 2008 express sp1
I download SQLEXPR_x86_ENU.exe (sql 2008 express sp1)from microsoft but do not know how to install sp1 from this exe file. Can someone help me? Is there any site can download sp1 only? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201007/1 aspfun via SQLMonster.com (u53138@uwe) writes: > I download SQLEXPR_x86_ENU.exe (sql 2008 express sp1)from microsoft but do > not know how to install sp1 from this exe file. > Can someone help me? Is there any site can download sp1 only? Have a look at http://www.google.se/#hl=sv&so...

Total Failure of CRM/SQL
I am (was) running CRM 1.2 and SQL 2000 SP3 on the same box when CRM started acting funny and finally i couldn't access the web interface anymore. The box was still running (W2K3)so I backed up the databases with NT backup. Now, i rebuilt the server and have tried unsuccessfully to restore the CRM data following the IG. Any thoughts? Thanks. Do you have a backup of the sql database? If you have a backup of the database you can restore and do a reinstall of CRM, dont try to restore the crm program as well. Just restore the database, install CRM and point it to the database. >-...

Running CRM client as normal user. Getting SQL errors (offline mode)
Hi there, I'm at a company where they have a policy to not make users administrator. Also I have administrator rights, but no access to CRM, so I can install the client, but that's about it. Several of the users have gotten an offline installation but now get the message 'Action microsoft.crm.config.common.install databaseAction create database permission denied in database master'. Any idea how to solve this? Also have 1 or 2 with a 'SQLDumper library failed initialization. Your installation is either corrupt or has been tampered'. Please uninstall then re-run set...

String TO xml (xml string)
I am trying to take a string and convert it to a data source. The string is Xml that I am pulling out of sharepoint and looks like this: <Field FromBaseType="TRUE" Type="Choice" Name="Status" ColName="nvarchar1" DisplayName="Status"> <CHOICES> <CHOICE>Active</CHOICE> <CHOICE>Resolved</CHOICE> <CHOICE>Closed</CHOICE> </CHOICES> <Default>Active</Default></Field> This is about all I have come up with but of course it doesn't work: String xmlData1 = oList.Fields.Get...

Hiding exchange alias in adress list OWA
H we are using exchange 2003 and I need to hide or remove the alias from the adress list I have removed it from the template, but when searching in adress list in OWA alias is still there Someone has any ideas on how to remove alias from OWA aswell thanks in advanc Joakim Larsson I suggest you change the Alias to something unclassified. There is no requirement that it have any relevance. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Joakim Larsson" <anonymous@discussions.microsoft.com> wrote in message news:E1E41BF2-5A97-4BD8...

Get ID control value from string
I need to get the ID value for a lot of controls in orde to modify caption for each one. those controls are not in continius order, so I can use ID number from resourde and add x value. so, how can I get resourde number from an ID in string form. CString str1 = "ID_STATIC_V1" /* = 1095 */ int value = ????? should be 1095 but how to get this value from ID_STATIC_V1 ... V10 /* 1095, 1098, 1112, 1115.... */ thanks in advance for your help. Eduardo "Eduardo" <a@a.com> wrote in message news:00c501c37a22$867ea7b0$a401280a@phx.gbl... > I need to get the ID val...

Subquery help for the sql defficient
Looking for a little help with what is probably a simple problem. I am looking to create a subquery that returns all columns in a table but for only a subset of the total records. If I run a simple query and return two fields [s duns#] and [add_1] I return all records in the dataset 2400ish. the [s duns#] represents a specific company site. I would like to return a single combination of [s duns#] and [add_1] for each unique [s duns#], but since there are multiple formats for each address I don't have uniqueness. Which address is picked doesn't really matter, I simply want to return one...

Problem connecting Win XP SP2 to exchange server
I am trying to connect outlook 2003 on Windows XP SP2 (rtm) computer to an Exchange 2003 server. The computer is not part of the domain so I get a login screen when I am trying to connect to the server via Outlook. The problem is that I am using the correct user/pass but it still does not connect. When I am trying to access a shared drive on the exchange server from this computer I am using the same user/pass and it allows me to access the drive. Any idea how to solve it ? Thanks for your time ra294@hotmail.com "ra294" <ra294@hotmail.com> wrote: >I am trying to connect...

In Access, How do I hide records, but include them in the total
I'm running a report where I have work orders. They are grouped by appr and comp. I need to create a report that will show all the appr tickets, but give me a total count of appr and comp. I have the report generated the way I want, with total count, but how do i hide just the comp tickets. xeoimom wrote: >I'm running a report where I have work orders. They are grouped by appr and >comp. I need to create a report that will show all the appr tickets, but >give me a total count of appr and comp. I have the report generated the way >I want, with total count, but ...

Calling Javascript from Server Side
I have the following lines of code in the GridView.RowDataBound event to call some Javascript code when the user clicks on a GridView row. If any of the strings I am passing to the Javascript code contain a single quote this Javascript error occurs: Error: Expected ')'. How do I fix the first line of code below to allow for single quotes? seldata = "userSelected('" + strCustName + "','" + strCustCompany + "', '" + strAddress + "')" e.Row.Attributes.Add("onclick", seldata) 'test the code above by s...

IE6
I inadvertently checked the "Do not show me this message again" box, but, as I like to know when I am being re-directed to or from a secure site, I would like to re-enable it. Is is possible, please? Kate Kate wrote: > I inadvertently checked the "Do not show me this message again" box, > but, as I like to know when I am being re-directed to or from a secure > site, I would like to re-enable it. Is is possible, please? Have you looked at the settings for the security zone (probably the Internet security zone) under which the unidentified web...

Linq to sql - object designer
Hi. I have a winform and a few texteditfields. These are bound to the result from a linq query: var person = ProjectGlobal.rd.ER_Persons.Single(c => c.LogonId == ALogonId.ToUpper()); The query gets the person of the entered logon-id. Next, the persons departments are feched: var sections = from s in ProjectGlobal.rd.ER_Person_Sections where s.Person_Id == person.Person_Id select s; The results from this query is databinded to a DataGridView. The result columns is Person_Id and Section_Code. And these two columns are then shown in t...

SQL Error Help
I have the following SQL: strSQL = "INSERT INTO taDEFENDANTS(TrusteeDefendantID)" & _ "VALUES(lngTrusteeDefendantID)" & _ "WHERE DefendantID=" & lngDefendantID & ";" The Problem: I get the following error: Run-time error 3137: Missing semicolon (;) at end of SQL statement What am I missing that prevents the code from seeing the semicolon that is there? Sorry if this is double posted. My system crashed right after I clicked post and never saw the first posted. What you are missing is ...

Unable to connect to server #2
I can receive messages but when I try to send I get "unable to connect to server"?? ...

CRM Laptop Client Connection Issue
Recently we registered ASP.Net2 on IIS in order to install a custom ASP.Net2 application on a CRM machine... Afterwards all sorts of problems occured of which we couldn't connect to CRM anymore. So we figured out that it could be an ASPNet version issue because we found that the main Web Site and sub sites like Microsoft CRM 3.0 now were using ASP.Net v2, so we changed these from properties, and we changed the master Web Site from the Properties > Virtual Directory Configuration to point to the Framework 1.4 rather than 2.0. Now, we managed to get CRM back to work and we are a...

hide a statusbar pane
Hi, How do I hide a CStatusBar pane? I'm trying to show a progress bar on a pane of the status bar, which is a snap. I'd like to make it the same way as it is in Internet Explorer: they show/hide the pane whenever they need that. I tried to set the pane's width to '0' in SetPaneInfo. It made the pane approx. 5 pixels wide. That was as close as I could get to it. Any ideas would be appreciated. Thanks, Peter Hey Peter, Create a sample CView based SDI app. This feature already comes via the menu handler I will demo how to add your own code. 1) Add...

Showing/Hiding Columns by clicking a button
Hi, I would like to write some smarter code to - (a) initially hide columns C-I on Worksheets 1-3, then (b) show only the columns selected by check boxes on each of those Worksheets after pressing a button named 'SIB'. What I am doing at the moment for is the following: Private Sub SIB_Click() Worksheets("Sheet2").Columns("A:A").Hidden = False Worksheets("Sheet2").Columns("B:B").Hidden = False Worksheets("Sheet3").Columns("A:A").Hidden = False Worksheets("Sheet3").Columns("B:B").Hidden = False Worksheet...

extract data from middle / right of string
I have a column in a spreadsheet containing the following type of string: 330189149967 Ideal - Series 2 (DVD) 3 12.99 GBP 38.97 GBP I would like to extract the number after the (DVD) in this string. However, the set of characters (DVD) does not always appear in the string. The only thing that is always constant is the number of spaces before the 3 on the right of the string. So I think the best way to extract the number is count 4 spaces from the right and return the number after the 4th space. This number could also be more than 1 character which might make things difficult. Any ideas? Tha...

Re: limit numbers of connections to one server
hi there :-) my pop3 server is limited to 10 query per sec. and per ip. i have abou 16 mail-accounts on this server. the last 6 allways error with timeou or something. is there a way to limit the number of connections to one server i outlook 2002 on windows xp pro? thanks a lo - jazzy_ ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message674073.htm Set your send/receive settings to consecutive mail checks, rather than conc...

The remote server did not respond to a connection attempt #2
Hi When sending an email to an external email account, the email gets stuck with the above error. The domain name is inchltd.co.uk. I can send ok to it via hotmail, but just not from my server. I have tried to telnet onto it, but I cant. I am running SBS2003. Hope you can help. Scott It must be a network connection issue. You can start with checking your DNS server first and see if the it can resolve the remote domain correctly. If yes, you will need to check your outbound/proxy server to see if there's any problem. "Scott Reading" <ScottReading@discussions.microsoft...

Change Pivot Table Data-Source Connection
I have a fairly huge Pivot Table which source's its data from a SQL Server ODBC connection. I need to change this connection but keep the pivot table - I can't seem to do this. When I click on Pivot table, then the back button to show the list of tables, it won't allow me to go back another time to re-choose the actual ODBC connection? Is this possible? My last resport is to re-create the whole Pivot table again, but I'm trying to avoid this...... Thanks Ben ...

Passing Param to GP Forms with VB.net
Hello, I am writting a form that when you click on a grid, you open up another form with more detail (This form is a gp form.) and am trying to figure out how to pass the info that need the for to open up with. Matt -- Matthew Heinrich Casino Queen Inc. Development Team ...