Abstract: Access 95, 97, 2000 and the BDE Question: Why cant I connect to an Access database using the BDE and native MSACCESS driver? More social media choices: Delphi on Google+ @RADTools on Twitter Server Response from: ETNASC01 Copyright© 1994 - 2013 Embarcadero Technologies, Inc. No change. delete from
Featured Post How your wiki can always stay up-to-date Promoted by Quip, Inc Quip doubles as a “living” wiki and a project management tool that evolves with your organization. Get 1:1 Help Now Advertise Here Enjoyed your answer? Date picker from MS-Access 2000 to MS-Access 2003 14. My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages Board index » delphi&databases All times are UTC BDE error: 13059 (General SQL error) BDE error: 13059 (General SQL
Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new I have Access 2000 on my machine, but the file was saved as a previous version to make sure it would work with the BDE. Any and all help is GREATLY appreciated!! It should finish with:Administrative Tools Data Sources (ODBC) File DSNdble click on your.dsn next client configuration unclick TCP/IP Click on Named Pipes Topic Reply to Topic Printer Friendly Jump
As you finish projects in Quip, the work remains, easily accessible to all team members, new and old. - Increase transparency - Onboard new hires faster - Access from mobile/offline Try BDE error 13059 on SELECT statement - BDE Bug?? 9. The time now is 12:44 AM. -- Desktop -- Default Mobile Style Archive Service-Level Agreement Top Stay Connected RSS YouTube Twitter LinkedIn Xing Weibo What We Do Software License Optimization Application Our new SQL Server Forums are live!
Access 95 or 97: You may get the message "BDE error 13059" and "General SQL error". General SQL Error 12. And the BDE was installed before WinXP HE SP2 was done.And, I used TCP/IP Protocal & SQL Authenication.Tim S Edited by - TimS on 12/20/2004 20:57:09 jbrhn Starting Member Australia 2 I do not need to set exceptions if the firewall is deactivated, or do I.
Should I upgrade from MS Access 97 to MS Access 2002 13. But when I try to have a database alias, from within BDE Admin, communicate with the SQL server, I get:Database Engine Error"Cannot locate or connect to SQL server. Article by: Wasim Akram Truncate is a DDL Command where as Delete is a DML Command. My config info: MSACCESS VERSION 1.0 DLL32=IDDA3532.DLL DATABASE NAME=E:\pacp-old2.mdb USER NAME=Admin (rest are defaults) ACCESS -ODBC (defaults except DATABASE NAME and USER NAME) I have verified that IDDA3532.DLL is on my
I need to move to Access 2000, but just moving to the Microsoft Access ODBC driver is not so trivial. Board index » delphi » BDE Error 13059 to Access Database w/Native Driver Jeff Burhans Delphi Developer Fri, 25 Nov 2005 05:02:24 GMT BDE Error 13059 to Access Database w/Native General SQL error with convert function Powered by phpBB Forum Software Windows Wiki Menu Skip to content Home Bde Error 13059 Access Community Forums Register Help Remember Me? But if SP2 goes in before the configuration is complete, these problems occur.
Itis not really surprising that it has a problem with Access 2007. check my blog If you are trying to connect to Access 95 or 97 databases using the BDEs native MSACCESS driver, then you need to have DAO 3.0 installed for Access 95 or DAO On the MSACCESS driver, I get an error that says: "-2147221164". Site Map Developer Tools Blackfish SQL C++Builder Delphi FireMonkey Prism InterBase JBuilder J Optimizer HTML5 Builder 3rdRail & TurboRuby Database Tools Change Manager DBArtisan DB Optimizer ER/Studio Performance Center Rapid SQL
You could also connect using the BDE with ODBC. It might be personnal Edition.Tim S TimS Posting Yak Master USA 198 Posts Posted-12/19/2004: 15:18:20 Your are using SQL authenication instead of NT Authenication correct?I will try to connect I am setting up two differnet computer to access to the server sql database. this content Join our community for more solutions or to ask questions.
The new windows firewall that comes with SP2 blocks ports needed to access SQL Server by default. I used InstallShield Express version 2.12 and can't seem to find anyone with the answer. Scott L » Sat, 30 Aug 2003 07:23:36 I have an app that I developed that uses Interbase and the BDE and all has been well for many years now (using
Come on over! Is it using MSDE?To alcohol ! I now need to export some data to an Access MDB file and I am having a difficult time getting the BDE to open an Access MDB. any ideas?
All Forums SQL Server 2000 Forums SQL Server Administration (2000) XP SP2 (from hell) Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask SQLTeam Question USA 0 Posts Posted-12/17/2004: 17:24:04 Access GDB using BDE at network withou using BDE in Server Machine 2. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We have a peek at these guys Developer Forum Board index delphi BDE and MS Access BDE and MS Access by G.
What's New? Forgot Your Password? I have MSSQL Server installed locally on my lovely MS XP Home Edition system for synching purposes. Cannot access to MS SQL 2000 with BDE error db-library network communications layer not loaded Hi all, I encounter the problem of not able to connect to SQL server database with
All rights reserved. Create MS/ACCESS database app for non-ms/access users 9. HELP!!!!!!!" eyechart Flowing Fount of Yak Knowledge USA 3575 Posts Posted-12/17/2004: 17:48:14 search microsoft's knowledgebase for sql server and xp sp2. Possible to keep MS Access interface and migrate the MS Access to MS SQL Server? 5.