Threads Replies Last Post 5 Pages: 1  2  3  4  5   Problem Connecting to SQL Server via ODBC [TIME datatype related?] I have a System DSN setup on my development machine using the SQL Server Native Client 10.0 (Version - 2007.100.1600.22, Date - 7/10/2008, File - SQLNCLI10.DLL). I'm able to successfully connect to the server and retrieve data. However, when I try a SELECT that contains a COLUMN with a TIME(0) data type, I receive the error below. I thought that the issue my be related to the ODBC driver... 1 12/22/2008 5:51:00 AM connection objcet of VC#2.0 doesnt behave as desired In a testing application I need to monitor repeatedly the Oracle Database server for database connectivity. I am writing an application in C#.net. In a function I define this: OdbcConnection cn = new OdbcConnection("dsn=...;Pwd=...."); try { cn.Open(); } catch { } if (cn.State == System.Data.ConnectionState.Open) { cn.Close(); return true; } else { ... 1 11/26/2008 6:39:02 AM Moving from SQL connection to a DSN... Hi guys, I have a website that was working using a Microsoft SQL Server (SqlClient) and XSDs. Now it has to be moved to a DSN connection (that also points to a SQL Server). But I'm clueless about what should I change and where... Or even if is still going to work... Any help please? ... 2 6/28/2007 1:49:59 PM Diabetic Recipes and More... Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for diabetic's. The website is full of great links from our partners. We have links to free cookbooks and more. Please stop by and support us. Visit all our links and choose the best recipe for you or your family. We look forward t... 1 6/24/2007 8:26:53 AM Need help on access Hi, I've used Access database as the backend in my winforms.. I'm very new to access 2007 db.. I need help on Accesss db.. Ive used a field of datatype MEMO in one of my tables.... I wanted to make it as a unique through design wizard of access.. how can i acheive it?... 1 6/11/2007 1:52:00 PM is there a "last id" mechanism on an update? I have a gridview "new" command that insert a new row into a postgresql database.that uses the odbc driver. Newbie as I am i thought that iReturn would have the new index that was created. SqlDS1.InsertCommand = "INSERT INTO \"Algorithms\" (source_code_id, comment VALUES (69, 'haleys comet', 1)"; int iResult = SqlDS_Algorithms.Insert(); Ok, instead of getting back an id I got ba... 3 6/4/2007 8:57:30 AM Read (and Visualize) DB Schema from SQL Server Hi experts, which approaches would you suggest for: - Reading a database schema (tables, fields, relationships) from SQL Server 2005? - Visualizing the DB schema? For developing a DB tool the schema should be read from the server and then be visualized, e.g. like the SQL Server BI Development Studio does when importing the whole schema to a data source view. Any ideas and hints o... 9 5/21/2007 8:31:31 PM Crystal.net OLEDB refcursor Hi: I am using Crystal.Net supplied with .NET framework 2005 and receive an "unrecognzed type" error when calling an Oracle 10g procedure that returns a refcursor. I have tried both the Microsoft for Oracle and Oracle's OLEDB drivers with the same results. The Microsoft for Oralce driver works for VS 2003. Any help is appreciated. TIA ... 1 5/14/2007 3:35:02 PM IM002 Hi, im building a connection string for Odbc data provider, without DSN because i dont want to create a dsn in each client machine (there are a lot) the string is complete, but i get this exception below the text of mail. I think is a problem with DRIVER=IBM INFORMIX ODBC DRIVER but i dont understan putting the string via server explorer it connects ok, but building it comes the error.. ... 1 4/30/2007 6:49:27 PM can sequel db create a mdb file Like to know if we could create a access database file on a sequel database server... 1 4/25/2007 7:20:33 PM Help!!! Declare a varied-length array of structures and the use of marshalling? Hi, everyone, I'm writing a program to discover wireless network using Windows Native Wifi API & VB.net. I have to declare the windows API in my VB.net program. The original windows declaration is as below. The problem is in "struct _WLAN_AVAILABLE_NETWORK_LIST", it declared "WLAN_AVAILABLE_NETWORK Network[1];". I think which means a Network[] array of struct WLAN_AVAILABLE_NETWORK. ... 1 4/6/2007 8:25:47 AM MySQL Remote data access : Access Denied for user Hi Folks I am able to connect to my local MySQL DB from VB.NET application, but when it comes to remote data acess I have been facing the "ACCESS DENIED ERROR". The connection string I used is as below. DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.0.109;DATABASE=movedb;UID=test;PASSWORD=test;port=3306"; here the SERVER is IP of the system in the same network. Please find the at... 1 3/30/2007 6:22:36 AM Economic Terror Abuiltcomputer to go public soon Fundamentalist http://scotiabanksealsthedeal.blogspot.com/ Do you want money or love I got both. ... 1 3/6/2007 2:23:08 AM server2003 r2 (x64) I'm confused by the fact that you cannot administer odbc-dsn from odbcad32 when called from the "control panel" or the desktop : ends in error : "the setup routines could not be found * . please reinstall" But run from a "dos-prompt" there is no problem at all. Trying to change security-setups ... does no chage. Any solutions , ( how to reinstall ... anyhow ??? ). ... 1 2/24/2007 8:00:00 PM How to identify Oracle Client version used by web application? I have web server installed with multiple Oracle Client version. How am I to identify which oraclient that my application / server used to conned to the database?... 1 2/8/2007 2:41:00 AM OLEDB MsAccess Data from Accpac We would like to create an MsAccess.Mdb (or SBF or Sequel database) in office 2000 to obtain individual table details from Accpac Plus in Dos (an accounting program)? This Access data will be used for viewing and printing and not for accounting purposes. Can we receive any ideas or a sample database of how to do this? Thank you Mehran ... 1 1/6/2007 9:07:09 PM OLEDB MsAccess Data from Accpac We would like to create an MsAccess.Mdb in office 2000 to obtain individual table details from Accpac Plus in Dos (an accounting program)? This Access data will be used for viewing and printing and not for accounting purposes. Can we receive any ideas or a sample database of how to do this? Thank you Mehran ... 1 1/6/2007 8:17:04 PM ODBC problems Hi, I have a problem with ODBC that I have not been able to resolve. I am running Windows 2000 which is kept up to date. Recently I attempted to open a database in Access 200 and recieved the following error message: "The Dynamic Link Library msjet40.dll could not be located." Having established that the msjet40 dll is where it should be I tried deleting Office and reinstalling, onl... 1 11/19/2006 6:34:01 PM problem in using a C# dll in VC++ 6.0 Hi All I wish to use a C# dll in my VC++ 6.0 based application. Cud u help me plz. Thanks & Regards Puneet *** Sent via Developersdex http://www.developersdex.com ***... 1 11/15/2006 12:22:46 PM ODBC / Vista / Foxpro I have installed our .NET application on a system running Microsoft Windows Vista operating system. When I run our application, I receive the following error message whenever it tries to create a DBF file using VFPODBC: "ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function" I am using a connection string that I have used for many years with no problem... 8 11/9/2006 7:28:00 PM Update SqlDataSource with ODBC.NET Hi, I have an SqlDataSource on my ASP.NET page, UpdateCommand of which is set to "Update table set @f1=f1, @f2=f2 where @id=id". When bind to a grid and properly populated, it automatically gets to edit mode and updates data when using SqlClient as provider. However, when provider is changed to Odbc, I get error: "Must declare scalar variable @f1" I guess this is an ODBC specific problem, be... 1 11/8/2006 1:17:46 PM user requested cancel of current operation Hello, I posted this in the ODBC group too. I had originally meant to post it just here. Sorry for the duplicate. I have an application that uses an OdbcConnection connection and OdbcDataAdapter to fill a DataTable. The query I am running is pretty long and contains 5 unions. When I run it I get this error: {"ERROR [HYT00] [Oracle][ODBC][Ora]ORA-01013: user requested cancel of cur... 1 10/31/2006 9:20:01 PM Insert query parameters not working In my application (ASP.net) I use the following: MyDataSource.InsertParameters.Clear(); MyDataSource.InsertParameters.Add("AdvID", TypeCode.String, sAdvID); MyDataSource.InsertParameters.Add("Email", txtEmail.Text); MyDataSource.InsertParameters.Add("Name", txtName.Text); MyDataSource.InsertCommand = "INSERT INTO markt.advertizers " + "(AdvID, Email, Name) VALUES (@Advertise... 2 10/27/2006 12:45:54 PM How can I use MaxScanRows in C# source code to import the excel sh when i imported excel sheet to datagrid some of values are ignored.If i change the TypeGuessRows registry key value in path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines to 0 then its working fine .But it is not the right way to change the registry key.So I followed alternative way.I used MaxScanRows in my source code .But it has no effect.Can anyone please help me about this p... 4 10/13/2006 3:51:01 AM Accessing DBF DBASE II data via ODBC returns NULLs for some decimal fields I have a series of DBF files that I want to import into a SQL database. When I query a few of the files using ODBC (DBF driver), OLE.DB (Jet 4.0) the fields that are decimal and have values are returned as NULL. Looking at the internals, I can see no differences in the headers of the files (field types, indexes, etc.) and the non-decimal fields are returned ok. Loading them via other DBF vi... 2 10/11/2006 6:19:45 PM 5 Pages: 1  2  3  4  5