All rights reserved. E-mail: [email protected] Stefan Goebel
Matthew Les Prigmore wrote in message <[email protected]>... >Dear colleagues, > >I've been looking around in several news groups for the answer to the >following question. Set dbsWarehouseServer = OpenDatabase(ODBCDSName, _ dbDriverNoPrompt, False, _ "DSN=" & ODBCDSName) Set rstRailSet = dbsWarehouseServer.OpenRecordset("Select Store_date, SLN From " & TBName & " where Rail_set_ID = '" & RailID & "'", May 10, 2007 Our program report the error like this:[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.I used VC++ and ADO. I would like to create an ODBC DSN which would be available to all users so that I don't have to create a DSN on each machine.
HELP!, Sybase System 11 & Delphi 1.x 12. What I plan to do is have the trigger retrieve a >message from >an error table and send it to the error handler for formatting and >presentation to the user. > ct_connect(): directory service layer: internal directory control layer error: Requested server name not found. (BDE Error : 13059) Does anyone know how to solve this problem or where to start ?
The connections use Windowsauthenication and the users are set up in SQL Server security loginswith public and db_owner selected.Has anyone seen or heard of this problem and does anyone have anyideas I asked the IT to check the network and they say its fine. When I have done additions or corrections, how can I test the original recipe in a formula? Sybase & Delphi 6.
What would be causing the SQL Native Client to not show up in the list of available ODBC data sources? General SQL error. [Sybase][ODBC driver][Adaptive Server Anywhere] Syntax error or access violation: Request to start/stop database Error BDE: Database not connected. I cannot understand why this is happening because I have included the correct server instance in the DSN settings i.e. Using Native Driver with BDE2.5/Sybase SQL Anywhere 10.
in module RBRCL66.bpl ... When I'm trying to connect using BDE Admin and double clicking on the + sign of the alias I created usind ODBC admin I get the message I listed above. SYBASE & Delphi Connection Problems 8. We thought it might bean ODBC issue at first but we can connect to a MySQL server using thesame programs/services just fine.Checking the SQL Server setup, we do have both Windows
Thanks for any assistance. Also, is there a way to upgrade or downgrade ODBC drivers on W2K3 machines? Steps to Reproduce: 1. When I schedule a package to run every night which has excel data transformation, it fails.
I will reciprocate by responding with the solution that I find most usefull. this content Please check your setu I have done a user query in Dyelots but the result is always empty. All rights reserved. -- Select Language -- English (USA) French (France) Spanish (Traditional Sort Italian (Italy) German (Germany) Portuguese (Brazil) Powered by PHPKB Knowledge Base Software There are no corresponding events in Window Event Log or in the SQL Server Logs other than standard informational messages about the regular operation of the server.I am connecting to a
Within SQL Server 2000 Enterprise ManagerError: SQL Server connection openII. menu I get error message that says can not find >dbserver:
with the delphi i get a error: sql-error. Error code: 0x80040154. additional information:ERROR[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.ERROR[SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to
unable to determine Net-Library error. Workarounds Didn't find any till now, except creating the user without the special character. I did so, > but got no answer - I really wonder whether > I am the only developer using ASE as > database and Delphi for client applications ... > As mentioned above the Test Connection succeeds in the ODBC Administrator so logic would dictate that it's setup correctly.Any help would be appreciated.
On one particular client installation on application server, I started getting this exception while SQL Server was up and running (on a different machine). delphi & sybase 11. HELP! check over here However when my application tries to use the DSN to connect to the database I recieve the following error.IM002 - Data source name not found and no default driver specified.The data
IsAutoClose on all the databases is false. Code snippets that help explain your approach to the solution of this problem are welcome. So, I installed SQL Server 2005 Standard Edition on our Server hoping that they operate identically. Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your
Auxiliaries : ARO-BLN--> 1 Inventory Operations ... The package execution fa... When generating a dyelot, I get the following error: Constraint violation: Column Amount Reserved in table Products cannot be null Temporary files appear on the desktop during ITMProcess utilisation. Show me some lines.
Why? Daimon View 1 Replies View Related ODBC Connection To SQL Server DB Mar 4, 2005 I'm writing a VB app to read and write data to an SQL server database.I have The package execution fa... A column / field is missing in one ITMProcess window.
Need help with Stored Procs using Sybase & Delphi 2 C/S 6. There must be a way to enter a server name directly, I tried : "TCP, 192.168.1.2, 7100", "192.168.1.2, 7100" and so on, but nothing worked. Thanks View 4 Replies View Related [Microsoft][ODBC SQL Server Driver]Connection Is Busy With Results For Another Hstmt??? I get the following error after about 1 minute: BDE Error: 13059 Server error :-80 unable to connect to database server: unable to start database engine....
Why? The standard installation is a 3 machine web/app/sql setup. Create an user on Oracle, with special characters, like "userwithgcharacter". 3. TCP/IP is enabled, remote connections are allowed and there is no firewall blocking.
Programmatically deleting the user name in Configuration\Drivers\Native\MSSQL 6. 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 Technical Articles