This is a small component that will help your server make a connection to the SQL Server's DB. The File Data Source is not updated by the ODBC Data Source Administrator. hth matt 0 Message Author Comment by:Muratti2003-09-12 mnye, when I do that, it says to me "the database it up to date". Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! http://auctusdev.com/invalid-file/invalid-file-name-error-loading-crystal-report-file.html
I am sure i chose the "File DSN" tab under OBDC Data Source Administrator. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. mlmcc 0 Message Author Comment by:Muratti2003-09-17 mlmcc, I think I am getting closer to solve my problem. This code works fine with Access and SQL server: SQLHENV hEnv = SetupSiteDbApp::GetApp()->GetOdbcSession().GetEnvHandle(); // // Create a connection // SQLHDBC hConn = NULL; SQLRETURN nStatus = SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hConn ); http://www3.rocketsoftware.com/rocketd3/support/documentation/odbc/203/userguide/Working_with_a_file_DSN.htm
The reports are originally using File DSN ODBC connection to a bunch of text files . Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. File data sources are an alternative, which are stored as files.
The server not opened yet is generally a missing dll or lack of permissions http://support.crystaldecisions.com/library/kbase/articles/c2012191.asp There ar etoo many for me too search through Here is the result of my search You can change the dsn to that in the Set datasource location. If you established that in the report file, you shouldnt have to use SetLogOnInfo. The driver file size is approx. 1.5 MB myodbc3.dll dated 15/10/2005.
I have no idea about this. 0 LVL 3 Overall: Level 3 Crystal Reports 1 Message Expert Comment by:kathmacmahon2003-09-15 Hmm, never heard of this error, but a quick search implies Invalid File Dsn 556 Moreover, I cannot rely on something which works only sometimes. It uses an Access (*.mdb)-File to save these Successstories. https://social.msdn.microsoft.com/Forums/en-US/dcd6c31f-79de-49c9-87cd-76885547d321/how-to-use-relative-dsn-filename-for-connection-in-design-mode?forum=vscrystalreports ODBC error while connecting to the database: S1000 -> General error: Invalid file dsn ''Event Xml:
I had this problem, by doing the following I was able to solve the issue: Run as Administrator. Visit Website Or you did and messed somthing up when you made your DSN's 26-01-05 #3 spectralpulse View Profile View Forum Posts Gift Subscription Account Inactive InactiveRank Jan 2005 Join Date Salt Lake General Error Invalid File Dsn Odbc If the ODBC server is not available when the File DSN is being created, then the Advanced tab must be utilized. Error Hy000 General Error Invalid File Dsn How do I do that? 0 LVL 8 Overall: Level 8 Crystal Reports 7 Message Accepted Solution by:mnye2003-09-16 when you use a system dsn, you dont have to specify location.
Opening the page somtimes produces "Microsoft OLE DB Provider for ODBC Drivers error '80004005' General error: Invalid file dsn '..... http://auctusdev.com/invalid-file/invalid-file-handle-error-is-3.html If you have any feedback, please tell us. I checked if there was any mapping, but there is none. I think you should follow mlmcc's advice and follow the links he offered, you're going to have to follow Crystal's troubleshooting techniques. 0 Write Comment First Name Please enter a first
Any thoughts? 0 LVL 100 Overall: Level 100 Crystal Reports 94 Message Active today Assisted Solution by:mlmcc2003-09-17 As added in your other question Could very well be. Details: HY000: General Error: Invalid File dsn "DSN name" Then when i change the code to m_objCRReport.Database.Tables(1).SetLogOnInfo "Location and name of File DSN.dsn", "", "", "" Then I do get blank We have on the company I work for an application built in Delphi V with Crystal Reports 8. http://auctusdev.com/invalid-file/invalid-file-error-in-qtp.html Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud
If you change the DSN then the report is lost because it doesn't know which database in the DSN to use. Note Use File Data Sources to distribute the file to users and simplify the management of multiple user connections. Xenapp 6.5 : Unable to create DATASTORE ODBC Error S1000 Started by Laurent BOUMEDDANE , 22 November 2011 - 10:46 PM Login to Reply 15 replies to this topic Laurent BOUMEDDANE
Solved Invalid File DSN - VB6 Crystal Viewer Application Posted on 2003-09-11 Crystal Reports 3 Verified Solutions 37 Comments 4,570 Views Last Modified: 2012-06-27 I am trying to connect my reports Make sure your windows account has privileges to read/write in that place (C:\Program Files\Common Files\ODBC...). 2) Create paswordless root account for MySQL server (remember to remove it later) and try again. Here are the details of "set location" of a sample report. Cheers.
I believe I've got your point - in the Set datasource location window, I expanded Properties node, and edited the File DSN field. The reports themselves and the dsn file they are looking at and the text files the odbc is pointing at, they all are in the server. You may have to register before you can post: click the register link above to proceed. his comment is here Join & Ask a Question Need Help in Real-Time?
Could it have gotten corrupted with all your testing. 0 LVL 8 Overall: Level 8 Crystal Reports 7 Message Expert Comment by:mnye2003-09-16 haveyou tried creating a System DSN instead of did you test it with the old dsn after you ran the "Verify database" task? 0 Message Author Comment by:Muratti2003-09-12 yes, when I created the new dsn, I gave it Also, make sure that you clean up the Application object when you shut down your exe or you may get GPF's on close. 0 Message Author Comment by:Muratti2003-09-16 ok I Last edited by spectralpulse; 26-01-05 at 05:22 AM. MentaL_BOT View Profile View Forum Posts Gift Subscription Visit Homepage Check out our sponsor 26-01-05 #2 Nullvalue View Profile View Forum Posts
If the D3 ODBC Server is not running or the connection fails then the error ‘General error: Invalid File dsn…’ is displayed. But could not get past this error. 0 Message Author Comment by:Muratti2003-09-11 What I don't understand is, once I open a report, why can't the report find its source without Sometimes it occurs... I programmed an ASP-Site to show the successtories of my firm.
Make a suggestion Dev centers Windows Office Visual Studio Microsoft Azure More... Without a successful connection, the data source information will not be saved. Any Idea? 0 LVL 8 Overall: Level 8 Crystal Reports 7 Message Expert Comment by:mnye2003-09-12 ahh yeah are using the RDC. when I take out setlogoninfo, no matter what (if the report points to the old or new dsn) I still get the Invalid file dsn error.
Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! using MySQL 5.7.12-enterprise-commercial-advanced-log Content reproduced on this site is the property of the respective copyright holders.It is not reviewed in advance by Oracle and does not necessarily represent the opinion of I have found that it does not work all the time... But "server has not yet been opened" error still exists on the client side.
Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Data Access, Manipulation & Batch Languages ASP Invalid File DSN If this is If myodbc3.dll says 3.51.06, than it's 3.51.06 How big is your driver (in bytes)? I dont think you need it. Join the community of 500,000 technology professionals and ask your questions.
Should I completely remove the setlogoninfo function? 0 LVL 8 Overall: Level 8 Crystal Reports 7 Message Expert Comment by:mnye2003-09-12 >Should I completely remove the setlogoninfo function? Learn how to create a query and then a grouped report using the wizard. Where is it available? 0 LVL 3 Overall: Level 3 Crystal Reports 1 Message Expert Comment by:kathmacmahon2003-09-18 So you are still using a File DSN?