I have two issues both related to (I believe) my SQL Server setup. I have installed SQL Server (the full thing) from MSDN downloads of the x64 version on my Vista 64 Home Premium box. After running into multiple issues I finally got it working. This is a new box so I ported over a database that I need to work on from another server. ...
I have a database that has four columns like this level_1, level_2, level_3, level_4 There are also id, name, etc., but only these four are the ones that matter to me at the moment. I need to know which column, by columnname, has the value 'BOSS'. For example, level_2 may have the value BOSS. I need to know that one of the four colu...
Having just called Update() on an MFC CRecordset (ODBC/Dynaset) what can I do to pull the auto-generated ID without hitting the database again? Ideally whatever it is would work in both SQL Server and MS Access (so querying for the last identity might not work...) ...
I have a stored procedure and if the stored procedure does this: SELECT 0 As Ret DELETE FROM table where value1 = 1 Returns 1 row result with its value of 0 and column name Ret But if I do this: DELETE FROM table where value1 = 1 SELECT 0 As Ret I get no returned results. My question is, how do I get the second variation to retu...
Hi, I am new to ADO.net. I actually created a sample database and a sample stored procedure. I am very new to this concept. I am not sure of how to make the connection to the database from a C# windows application. Please guide me with some help or sample to do the same. ...
I am using C to write a DLL that provides basic database connection functionality to a couple of different applications, using ODBC. When I use this DLL to connect to an Oracle database (Oracle 10g Express Edition, specifically) I get the following error message: Specified driver could not be loaded due to system error 1114 (Oracle in X...
I'm using MySQL 5 on shared hosting, connecting from ASP.NET 3.5 using the MySQL 5.1 ODBC driver. I'd like to store UTF8 strings. My tables used to be all in "latin1_swedish_ci", but I converted the the database, table, and column to UTF8 using: ALTER DATABASE `my_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `my_...
Is it possible to access an HSQLDB database that is running in server mode from a .net application located on the same computer? There do not seem to be any odbc drivers for hsqldb (freely available). Am I missing it? Sun's jdbc odbc bridge seems to allow connecting to an odbc datasource through a jdbc connection, but I would need the...
Scenario: Our install package used to add User DSN. We changed this to install System DSNs due to Terminal Servers and Citrix. The problem is that some of these old User DSNs are floating around, and our application automatically chooses the User before the System and the connection info has changed as we upgraded server software. I g...
I've got a program that exports data using a user-made .csv or .txt Microsoft Text Driver ODBC datasource. I create this datasource brand new in the ODBC Data Source Administrator, with a path to a directory shared by both the program and the DS. Then in the program I give it my datasource and it apparently wants the datasource to have a...
I'm using C++ to query a SQL Server 2005 database using ODBC. The queries contain parameters that I set using SQLSetParam(). I run the queries by calling SQLExecute(). Occasionally a query will fail, and I need to log the context of the failure. I am calling SQLError() to get the error information, but I would also like to log the raw q...
I'm trying to read a Paradox 7.x .db file in a .Net 3.5 app and I'm not being successful on that. First of all, when I'm registering the odbc, as a user or system dsn, the Microsoft Paradox ODBC Driver only display versions up to 5.x, so it looks like that it does not support Paradox version 7.x. At connectionsstrings.com I've found th...
I'm looking for a properly abstract way to get a list of ODBC data sources from the system in C#. I've tried the "Poking-around-in-the-registry" trick, which I've found works fine in English: RegistryKey reg = (Registry.CurrentUser).OpenSubKey("Software"); reg = reg.OpenSubKey("ODBC"); reg = reg.OpenSubKey("ODBC....
I can create an Access mdb and add a linked table to an Sql Server database via ODBC. If I change the Sql Server that the ODBC is connecting to with the ODBC control panel applet the mdb still connects to the original Sql Server until Access is restarted. Is there a way to relink these linked server tables without restarting Access? ED...
Is it possible to use the users windows authentication (setting in iis) for database connections in PHP? This is possible in the .NET world through a technique called "impersonation". Does this also exist in the PHP/IIS world? EDIT: The Database I am using is MS SQL Server 2005. ...
We are using the jdbc-odbc bridge to connect to an MS SQL database. When perform inserts or updates, strings are put into the database padded to the length of the database field. Is there any way to turn off this behavior (strings should go into the table without padding)? For reference, we are able to insert field values that don't c...
I have a CRecordSet (Visual C++ 6.0) and I'm using ODBC to connect to postgresql 8.0.8. __ The problem: I insert a row into a table with a serial id (autoincrement), and I would like to retrieve the id after my insert. I can't use the RETURNING keyword, not supported on this version of PGsql, but I can use currval('sequence'). Howeve...
[edit] We're collecting credit application data from users on a web form. I have not tied my web form directly into QB. I have no idea what the QB table structure is for this collection of data - nor of how it displays it to the user because I've never actually worked directly with QB. Others in my office do however. I would still ...
I have heard that excel-based ODBC connections can cause high server load (repeatedly warned at least). Is this a catch-all disclaimer, or is there a serious issue here? I plan to have 5-8 excel sheets that would be open all day updating one table (with about 65 cells) every minute. ...
My Company uses SAI heavily and in order to create reports from this system we use ODBC to connect to the DB. Are setup at the moment is regional and thus we have seperate environments for each region. When trying to access these environments using MS ACCESS I am finding that I cannot link to tables in different environments and retrei...