Sitemap

Amicuk Programming Answers

ODBC (RDO) Connection Information : DataBase Server ID Greyed out

2015-10-11   Views:3

Advertisement

Post Author: Eany CA Forum: Data Connectivity and SQL When I select the refresh option (Crystal XI) for a report which previously worked fine, I get sent to the ODBC (RDO) connection Information screen. The first box for Server ID is greyed out. When

Post Author: Eany
CA Forum: Data Connectivity and SQL
When I select the refresh option (Crystal XI) for a report which previously worked fine, I get sent to the ODBC (RDO) connection Information screen.
The first box for Server ID is greyed out.
When I go to enter the password, I get
Login Failed
HY000 General Error : Invalid file dsn  Database Vendor Error 556.
But If I then create a new report, selecting the same dsn as was used for the report above, there is no problem.

The replay answer
Advertisement
Hi Thib,
It won't work, WEB servers do not allow you to "Browse" their folder structures directly. You could how ever create a WEB Service to do this, it does the querying for you and then passes the data back. You'll have to search the WEB for more info on how to create a WEB Service and then check with your security guys if this is something you want to do.
Bottom line is ODBC or native or OLE DB is not going to work. And if you do open it up so you could it would be a major security hole for anyone to get to.
Other options are to create a VPN server so you can remotely connect to the server and get direct access to the table.
There are other options also, what you want to do is not doable.
You did not say why you want to do this? Add more info and someone may have a suggestion for you.
Major DB's like Oracle, MS SQL Server and others allow this to work through their clients so you may want to look at that option also.
Thank you
Don

Go to See the other 5 answers

ODBC (RDO) Connection Information : DataBase Server ID Greyed out

Category:DefaultRelease time:2015-10-11Views:130

Post Author: Eany CA Forum: Data Connectivity and SQL When I select the refresh option (Crystal XI) for a report which previously worked fine, I get sent to the ODBC (RDO) connection Information screen. The first box for Server ID is greyed out. When[More]

Crystal Reports and ODBC (RDO) connection

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm using SQL Server 2005 and Crystal Reports 2008. I connected my Crystal Report to the SQL database using an ODBC (RDO) connection. In the past I was able to add a field to a table in the database, and I was able to see the new field immediatel[More]

What's wrong with this MySQL connection? "Could not create connection to database server"

Category:DefaultRelease time:-0001-11-30Views:130

I'm able to connect to other MySQL databases but this one particular remote MySQL connection isn't working and I cannot figure it out.  It probably has something to do with the remote server, not CF, but I thought I'd post it here if anyone had an id[More]

(Cisco Historical Reporting / HRC ) All available connections to database server are in use by other client machines. Please try again later and check the log file for error 5054

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am getting an error message "All available connections to database server are in use by other client machines. Please try again later and check the log file for error 5054"  when trying to log into HRC (This user has the reporting capa[More]

MDM 71 - mdm console and clix - unable to connect to database server

Category:DefaultRelease time:-0001-11-30Views:130

Hi, environment, MDM 7.1, AIX 6, Oracle 10.2.0.4 (installed as part of a standalone java AS) i've an issue. I have installed MDM 71 via sapinst, before that I installed a standalone java application server. During the installation, i gave the 'oracle[More]

DSN for ODBC (RDO) connection ?

Category:DefaultRelease time:-0001-11-30Views:130

Hello ! I have an ACCESS database on a webserver and I wish to connect Crystal Report 2008 to it. Till now I have always used connection with DB on the same computer as CR so "Access/Excel (DAO)" was the way I connected to my *.mdb file. This ti[More]

DSN syntax for ODBC (RDO) connection

Category:DefaultRelease time:-0001-11-30Views:130

Hello ! I have an ACCESS database on a webserver and I wish to connect Crystal Report 2008 to it. Till now I have always used connection with DB on the same computer as CR so "Access/Excel (DAO)" was the way I connected to my *.mdb file. This ti[More]

'Unable to connect to database server' on local test server (CS4)

Category:DefaultRelease time:2015-10-11Views:130

I am a php/MySql newb. Have designed static sites in DW since Macromedia DW 4 days. I have set up a testing server on my Mac running OSX 10.6.7 using MAMP 1.9.5 and Dreamweaver CS4 to  test my osCommerce store (I like to see what's happening visually[More]

How to connect several database server

Category:DefaultRelease time:2015-10-11Views:130

I want to build a web site using jsp servlet for my university course purpose. In the background i will have three servers one is database server like server A another is certificate authority server like server B and the other one is Bank server lik[More]

Can't connect to database server

Category:DefaultRelease time:-0001-11-30Views:130

I've been using oracle db 8.0 since one year ago. Since about 3 months ago, i can't connect to my server database, even i do nothing which can change oracle settings. Why this thing happen ? and what should I do to solve this problem ? Note : When i[More]

Create connection multiple database server connection with sinle client

Category:DefaultRelease time:-0001-11-30Views:130

My problem is like this. I have 3 database servers like server A,server B,Server C. First Client will communicate with server A and Server B at the same time. Then if the connection is done then i need communicate with server C. Is there anybody who[More]

Hot
Hello, I have a list of data which I would like format the header to look as below: | - Quater 1---- | - Quater 2 - | - Quater 3---- | - Quater 4---- |  <--- header 1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | <--- hea [More]
Can i use iCloud or siri without updating to ios 5 in ipad 2?No to Siri It is possible to get some access to iCloud by setting up Mail, Calendar and Addess Book accounts manually There's a method here: http://www.bwhli.com/post/8065551136/icloud-for- [More]
I searched for solutions and they all said to delete everything and anything that has to do with my iTunes off my computer and to reinstall iTunes. They all also saud that my backups will still be intacked but im still not sure. Help?!Put a copy of t [More]
Dear All, In standard SAP,it is possible to confirm for single line item only by using confirmation tab. We want to confirm Mass PO Confirmation. Is there any BAPI for Mass Purchase Order Confirmation? Regards, RameshHi Sumant, I have tried with TC:M [More]
Hello, I am using EAS 9.3.1. On the Business Rules component, I selected Export Business Rules, and it invited me to export all business rules, variables, macros, and projects into one xml file. Now I cannot figure out how to load that xml file. I am [More]
Hey everyone, I'm using a Mac Pro and was wondering an affordable brown out & surge protector that will protect my computer well without breaking the wallet. I'm not worried about the bells and whistles I just need something that will keep my compute [More]
I have HP TouchSmart 600 pc, but touch screen it wasn't work ... how I'm gonna fixed this problem ?Hello hellsdonji:            Welcome to HP forum. Can you please tell us more about the problem. So we can get you up and running and wipe those tears [More]
I have a 6509 with a Sup2/MSFC2 running in hybrid mode and I'm trying to use TACACS for authentication/accounting on both the SP and MSFC. For some reason, the MSFC and the ACS don't talk, but the SP works just fine. The MSFC config is as follows: aa [More]
Are there any good online articles that could give you a step-by-step hint on ways in coming up with the perfect tables design and relationship from a business requirement...Be very careful about the word "perfect" ... Perfection may be possible [More]
hI,   This is madhavi. can any body explain abt BW statistics& indexes. in real time how do we use these.. on what based we make decision on these. Regards, MadhaviHi, in rsa1->environment->bw statistics for infoprovider BW Statistics is useful [More]