To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51768 Issue #:|51768 Summary:|Access to PervasiveSQL 9.1 not possible via ODBC/ADO Component:|Database access Version:|680m113 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|mjcoder
------- Additional comments from [EMAIL PROTECTED] Sat Jul 9 18:16:28 -0700 2005 ------- Hi, I'm unable to make a connection to a PervasiveSQL 9.1 database. Here is what I did: 1. Install PervasiveSQL 9.1 Let it create all the DSN's it wants to create. Let it make all the tests it wants to make. -> Now you should have three additional system DSNs: - DefaultDB (Pervasive ODBC Engine Interface) - DEMODATA (Pervasive ODBC Engine Interface) - test (Pervasive ODBC Engine Interface) 2. Select "Database" from the Quick-Start 3. Select "Connect to an existing database" 4. Set "Database type" to "ODBC" 5. Click "Next" 6. Click "Browse" 7. Doubleclick on "DEMODATA" 8. Click "Next" 9. Click "Test Connection" Error message title: Pervasive ODBC Engine Interface Error message text: Connect failed because you attempted a DSN less connection. Please, retry your connection with a DSN. If you already attempted the connection using a DSN, please retry after recreating the DSN. After clicking OK, I get the following error code: "1114 (Pervasive ODBC Engine Interface)" I already tried to recreate the DSN but the error is the same. When I use the "Microsoft ODBC-Administrator" (ODBC data sources) and select the "System-DSN" tab, and make a double-click on "DEMODATA", I can test the connection by clicking on "Test" and this succeeds. Now I tried to use the ADO interface: 1. to 3. same as above 4. Set "Database type" to "ADO" 5. Click "Browse" It's interesting that Pervasive OLE DB provider isn't selectable here. Is this normal? 6. Select Microsoft OLE DB Provider for ODBC Drivers 7. Select tab "Connection" 8. Enter the DSN 9. Test the connection I get the same error as above. Any idea what might go wrong? I also tried to create a new DSN with the "Pervasive ODBC Client Interface" driver but the result is almost the same. I don't get the ODBC error message any more but the error code shown is the same. Kind regards, Mark --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
