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
I am unable to import my video's onto my macbook with this camera. I realize I need a new camera that is compatible with my Mac, but in the interim I need to get my video's onto my mac so I can get them transferred onto a normal size DVD disc and mak [More]
Is there an online bug database for the Sun ONE Studio 8 Compiler Collection, like there is for all of the Java related tools? I know we have product support, but I don't want to go through the overhead of 4 or 5 layers of people to report a minor pr [More]
Greetings, We have a process that's used to send email messages using the NotificationService adapter. Currently this process works when all recipients listed have valid mailboxes. However, if any one of the addresses is (for example the address poin [More]
My usb & speaker cables don't fit w/my bumbercase. It's annoying i have to remove it to play music in my car or on my speakers.jcampeg wrote: My usb & speaker cables don't fit w/my bumbercase. It's annoying i have to remove it to play music in my [More]
Friends, Difficult situation for me...... OS: RHEL AS 3.0 DB: Oracle 9i R2 I was taking table inventory..... i saw many tables starting with SMP..... and EVT.....Nearly 50 tables. some are... EVT_HISTORY EVT_DEST_PROFILE EVT_CARRIER_CONFIGURATION SMP [More]
Hi all, I created a WebTemplate with a single query and four DropDown Box for allowing the user navigation. The WebTemplates works fine in Bex Web and the user may apply the filters in the dropdowns. We configured this WebTemplate on Reporting Agent [More]
HI, i have an inbound xml strucutre which should be mapped into an xml file (but only the filled values: <HEADER> <FIELD1>xxx</FIELD1> <FIELD2></FIELD2> <FIELD3>zzz</FIELD3> </HEADER> I need only the <FIE [More]
Hi, I have a Chart that shows monthly values. Now, I would like to add a fixed line that shows the average of all values. How can I do that? Thanks, JohannesHello Johannes! Please have a look into Kai Gutenkunst's blog: [/people/kai.gutenkunst/blog/2 [More]
What's the best practice for preparing the file structure? I've made all the files with the suffix - "_h" Do I need to have all the files as "_v" and in the opposite orientation? What about Links? Can I just have them as a standard fol [More]
Comcast wants us to use 587. But that created some problems for me. Mail prefers 995. My email boxes were always offline and refused to go online when I am using 587 but 995 they love it. Do I have to open port 587 somewhere? Thanks in advance.I find [More]