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
Hi everyone, I have a problem (re)pairing my Apple mighty mouse with Windows 7 under Bootcamp. Initially I had my mouse working through updating the driver to the one from Apple as is described on various forums. After rebooting my laptop the mouse d [More]
I want to link text boxes back and forth between different Master Pages in InDesign. How can I do this?I'm interested to know what it is you're trying to achieve - can you explain what you want your text to do? Regards, MalcolmRead other 3 answers [More]
Here's the deal I created a mono strip for each mono L/R ¼ inch input. R panned 100% right L panned 100% left I attach my equipment that plays the audio I mute the Left or the Right channel and I can hear the full audio for that channel but when both [More]
Hi All, We have created a Project Structure (using CJ20N) Now, we want to create Material/Service PR under the Network . We have a flat file, which stores the Materials/Services details against Project/Network. There will be many such materials/Servi [More]
When I setup my new Mac, I created the same account name as my old Mac. This is creating problems during my migration.  How do I change the main account name?No need for response.  I was able to solve this through some trial and error.Read other 2 an [More]
I have recently been given a Laserjet4059N printer. Downloaded the printer drivers from the HP site. The problem is that the printer prints one page but when asked to print a second page it always jams. Haven't got past page 1 successfully The second [More]
Dear all experts, I have two CSSs 11150 and have configured them as following: CSS-1# circuit VLAN100   ip address 172.10.10.101 255.255.255.0     ip virtual-router 1 priority 105 preempt     ip redundant-vip 1 172.10.10.1     ip critical-service 1 u [More]
Hi, SDN Fellows. I have a requirement as stated below: Said, I have Role A, which have WorksetA , that contains Page1, Page2,Page3. The requirement is: User A was assigned to RoleA, he can see all the pages in the role hierarchy. But User B was assig [More]
I have a HP Officejet Pro L7680 & it has worked like a charm for the 3 or so years, Tonight I go to print, & the papers come out with Black ink on the Side & Back. I have cleaned the printheads, installed new black, but still the same thing. A [More]
To help save save battery life turn of apps. This can only be done on ios4 and i have a 3gs. When on the home page double click and all open apps will appear on bottom of screen. Hold finger on one of the apps for a few seconds and the open apps icon [More]