Database Driver Name; SQL Native Client Press OK." Follow my above instructions and you will find out what's going on. I've seen Borland gt really tweaky on SBS2003 for a couple of reasons. 1. Click Here to join Tek-Tips and talk with other members! Michael 2. navigate here
e. Fact table and Dimension table from distinct database??? 9. Can change default database if desired.
On the server side I'm using W2003 EE ,MS SQL 2000 Standard with SP4, BDE5.11. If not what is meant by "connect the BDE database to SQL" 0 Message Author Comment by:Duncan0072008-08-08 The SBS2003 server hosts the BDE in which the databases are stored as Covered by US Patent. So the problem is that i can't connect to SQL Server but i can connect via ODBC.
Solved "Database Engine Error" Cannot Locate or Connect to SQL Database Posted on 2008-08-08 MS SQL Server SBS 1 Verified Solution 10 Comments 4,399 Views Last Modified: 2008-08-25 Why is my BDE error 13059 on SELECT statement - BDE Bug?? Already a member? navigate to this website Here is what I get for options for "New Database Alias" Standard MSaccess Informix Interbase MSSQL Oracle Sybase SQL Server MS Acces Driver MS Text Driver MS DBase Driver MS Paradox
Sys error 1157 BDE error 13059 9. b. Any suggestions ? Are there any BDE updates that need to applied due to changes in MDAC etc. 0 Message Author Comment by:Duncan0072008-08-09 Ok I recieved another error that might help but I
Check perform translation for character data. https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.em.doc/errors.html After erasing the keys from the registry and having reinstalled the BDE everything worked fine. You're proably aware what mysterious problems that can cause 2. d.
You said, "BDE connections are MSSQL Types all connecting to the "SBSSERVER" SQL Server. check over here i. Hope that helps. General SQL Error with ACCESS and BDE 13.
perhaps a reload of my XP Software.. The below function in SQL Server can do the job for you, returning a quick table with the parsed data. Thanks Costas Reply With Quote 06-14-16,20:29 #6 Anpadilo View Profile View Forum Posts Registered User Join Date Jun 2016 Posts 1 Hi Costas, Some solution to your problem? his comment is here Michael Other Threads 1.
SQL query 7. 13059 ERROR 8. When you say "connect the BDE database to SQL " do you mean connecting to the server from client machines? 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
Gerenal SQL error 13059 (SQL Server v 7) 10. am I missing? Watson Product Search Search None of the above, continue with my search How to fix Informix error -951 when clients try to connect Technote (FAQ) This document applies only to the DBlookupcombo ? 3.
Every time (cringe) I have to connect BDE to SQL I connect through ODBC. Several symptoms can cause such behaviour: SQLHOSTS file mispelled entries; DBSERVERNAME or DBSERVERALIASES onconfig parameters have no related entries in the SQLHOSTS file; NIS or LDAP servers misconfiguration or maintenance; INFORMIXDIR I am logged in as a member of Administrators. weblink Answer Here's a list of things to check when facing such a problem: 1) Double-check the SQLHOSTS file for missing or mispelled entries regarding the DBSERVERNAME and DBSERVERALIASES onconfig parameter values;
My first error of this... 0 LVL 9 Overall: Level 9 SBS 1 MS SQL Server 1 Message Accepted Solution by:michaelaknight2008-08-09 If you are able to create a BDE<->SQL connection Test the connection and call SQL good. I have already installed DAO and the latest version MDAC after it failed. The same version of SQL clients networking tools (it comes with MSSQL7 and is also Windows NT compatible) are installed on all computer. 3).
Database Driver Name; SQL Native Client Press OK. Cause You see errors like this in the online.log file: 13:14:57 Get Shadow Password for user [username] failed! 13:14:57 Check for password aging/account lock-out. 13:14:57 listener-thread: err = -951: oserr = j.