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, Recently my External HD "wesern digital My Book Studio Edition II" does not come up in my GX740 notebook. I have tried all usb connections. As far as I understand the HD uses windows-drivers, (not from cd) The Harddrive works fine on my othe [More]
Hi, I've noticed in APEX 4 there is a default option (through Action Menu -> Download Formats: email) to send an email with report in HTML format... may I know how to accomplish it using a Button... seems like APEX is using javascript:gReport.email.s [More]
I want to install an update from Sony, that is apperently written for 32 inetad of 64 kernel machines. I won't delve deeper in this, bought a Mac not to be borhered with such things. Apple prescribes that is start up pressing the 3 and 2 numericals. [More]
I have an application working in LabVIEW version 7.1 and 8.5. This application is used to gather data from a remote computer using TCP/IP. When the application is built as an executable, using an installer, the executable just returns failed to conne [More]
I have a white macbook 2.2 GHz Intel Core 2 Duo with Mac OS X 10.5.6. The SystemUIServer application keeps repeatedly crashing and restarting which is making it impossible to do anything else on the machine. I haven't installed any new HW or SW recen [More]
Sorry for reposting this topic, but it didn't appear on the forum. Hey there. I use skype from two computers. Last week i blocked a contanct from computer1 and yesterday i unblocked it from the same computer. So i noticed that after i unblocked this [More]
It seems like the SONY small photo printer is one of the best. Typically, the box says "PS compatible. The Epson and HP seem so cheap. The SONY is dye sub. Which of these kinds of printers will work with a Mac? Thanks rmI am using a SD card to read t [More]
i read in [this article|http://www.pcworld.com/article/149297-2/11things_we_hate_aboutitunes.html] that you can have an iTunes toolbar in the taskbar. i wanted to enable it to see what it was like, so i right-clicked on my taskbar, moused-over "toolb [More]
Hallo erst mal an alle. Hab mir Photoshop Elements 9 gekauft und mich jetzt schon ne ganze weile damit beschäftigt. Leider habe ich das Problem, dass jedesmal wenn ich etwas mit dem Lasso-Tool ausschneiden will, nach ein paar Sekunden oben am Photosh [More]
Je n'arrive pas a convertir un pdf en excel. Comment faire?Hi, To export your PDF files to Excel files: Using Web UI: Log into https://exportpdf.acrobat.com/signin.html with your Adobe ID and password Select "Export from PDF" Click "Select [More]