general error invalid file dsn West Kennebunk Maine

Address 280 Perry Oliver Rd, Wells, ME 04090
Phone (207) 646-9119
Website Link

general error invalid file dsn West Kennebunk, Maine

Hurricane766 (IS/IT--Management) (OP) 19 Aug 05 17:39 Hi,I'm using Sybase ASA 9 and I can't get file DSNs to connect to my database. Tuesday, April 20, 2010 3:22 AM Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. 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 Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: How to use relative DSN filename for connection (in Design mode)

Marked as answer by Harry Zhu Friday, April 23, 2010 1:41 AM Saturday, April 17, 2010 11:34 AM All replies 1 Sign in to vote Yes it does. in ODBC data source administrator click that particular driver and press configure fill all the details and check your databse dropbox is showing all the database present in Mysql, try this, I think this may be related to problems I've encountered with setting up a database connection. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [30 May 2013 7:06] Bogdan Degtyariov

as i have installed mysql in mypc and so its a local host.Test connection also successful. I do think you're better off using DSN-less connections.

Oliver. If the ODBC server is not available when the File DSN is being created, then the Advanced tab must be utilized. Reply With Quote 11-16-200508:22 AM #3 AndrewSQLDBA View Profile View Forum Posts Senior Member Join Date Dec 1969 Posts 2,435 RE: Don't use DSN Like Oliver stated
Not a good idea at

But whatever I typed, it reports the same error message - or nothing happens. When creating the DSN, it must be SQL compliant (no spaces, dashes, plus signs and so on). Can you try the version 5.2 from here? Click the File DSN tab.

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. Problem 2: If you try to edit a DSN that has any of the boxes on the connection tab checked, you immediately get the error message “General error: Invalid file dsn…”. All rights reserved. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016, Inc.

Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. remember Home New Posts Community Groups Albums Forum Actions Mark Forums Read Quick Links Today's Posts My Reported Posts Advanced Search Server Files Subscribe Advertise MMO News Advanced Search Forum Then try to Configure I get "General Error: Invalid file dsn 'C:\audit\audit.dsn' Other information: I can link to an MySQL ODBC table in Access fine using Get External Data -> link from control pannel,odbc connection..then user dsn filled in the computer name,username,pwd and db name Connect option and advanced option(the next two tabs) i havent filled anything.

Problem 1: All attempts to create MySQL file DSNs end with displaying “File Data Source was not saved” *if* you fill out enough information so that the connection could be verified. be sure to check your paths very carefully... ;) Red Flag This Post Please let us know here why this post is inappropriate. after all, He's not a tame lion..." 2 Kudos Message 2 of 9 (3,155 Views) Reply 2 Kudos Re: Error while connecting to MySQL database using DSN user_1 Active Participant ‎06-28-2007 The error message was "General Error: Invalid file dsn 'C:\program Files\Common Files\ODBC\Data Sources\audit.dsn'" [19 Oct 2006 8:25] Tonci Grgin Hi Andy and thanks for your problem report.

I will check the Driver installation is proper as told by u,once again.And if not if possible can u send me the working one pls? The File Data Source is not updated by the ODBC Data Source Administrator. Again, I saw none of these behaviors with the Win XP machines. I believe I've got your point - in the Set datasource location window, I expanded Properties node, and edited the File DSN field.

Thanks, Harry Please remember to mark the replies as answers if they help and unmark them if they provide no help. It doesn't matter what is written in DM, just check file versions for winsys32\myodbc3*.* files. Put ..\'Folder Name'\DSN.dsn and it will work. Thank you so much 0 Kudos Message 3 of 9 (3,146 Views) Reply 0 Kudos Re: Error while connecting to MySQL database using DSN Kodeeswaran Member ‎06-29-2007 03:33 AM Options

Friday, April 16, 2010 11:00 AM Answers 0 Sign in to vote Thank you for the reply. sometimes it does, othertimes it does not and I have no idea why it is this way. I am sure i chose the "File DSN" tab under OBDC Data Source Administrator. Error -2147467259 occurred at DB Tools Open Connec (String).vi->DB Tools Open Connec (Path).vi-> Possible reason(s):Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'localhost'

Save non-verified file DSN?". I am trying to start up L2 server on 64bit windows and i am getting the exact same error when i run CacheD..: "HY000 General error: Invalid file dsn ''". Use just a connection string and place it into an Include file that you can use over and over. Besides, ODBC is very slow and cannot do alot of things that OLEDB can.

Andrew SQLDBA Reply With Quote Quick Navigation Database (ADO/SQL/Access) Top Site Areas Settings Private Messages Subscriptions Who's Online

Friday, April 16, 2010 4:56 PM 0 Sign in to vote Thank you for the reply. edit: Thanks Nullvalue. For a new File Data Source, the Microsoft ODBC Data Source Administrator will display the message "A connection could not be made using the file data source parameters entered. I have to achieve this in other way.

Error -2147467259 occurred at DB Tools Open Connec (String).vi->DB Tools Open Connec (Path).vi->Untitled 1Possible reason(s):Exception occured in Microsoft OLE DB Provider for ODBC Drivers: General error: Invalid file dsn 'dmu.dsn' in Any changes made to the connection parameters are discarded.Deleting a data sourceComplete these instructions to delete a data source.Related topicsODBC data source administrationWorking with a user or system DSN Login / 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 ); Please ask if you need any other information or clarification.

the error is... Results 1 to 3 of 3 Thread: Error as invalid file DSN Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid i strongly feels that this is one driver and configuration issues, we will solve easyly. 2 Kudos Message 6 of 9 (3,114 Views) Reply 2 Kudos Re: Error while connecting to Andy How to repeat: To reproduce: 1.