Search Result

Run-time error ‘3146’:
ODBC—call failed.
[Microsoft][ODBC SQL SERVER Driver][SQL Server]The ORDER BY position number 0 is out of range of the number of items in the select list.(#108)

The text above is the error that I am getting when I try to sort a column in my form.I am not able to understand what this error is supposed to mean.

Here is the code that I am using to sort the column,in case required....

Hi,
I am getting an error 3146 odbc on rs.update. I have a form (form1) based on table motion_imagery. In form1, using VBA I'm trying to load two fields from form1 into table 2, File_Books.

...

Hi All,

I have a web application built using ASP.Net and communicates with a Web services which uses oracle rdb odbc driver to connect to RDB server, but after a while I started getting this error when executing simple statements like insert or update against the database:
Data : System.Collecti ons.ListDiction aryInternal
Source : SQRDB3.DLL
Message : ERROR [08S01] [Oracle][ODBC][Rdb] send() Ret -1 Err#10038 WSAENOTSOCK...

My Scenario on Windows VISTA, MySQL 5.5:

In cmd line I am able to enter 'mysql -u root -p' to enter MySQL shell after entering the correct password.
'USE myDB' or SHOW DATABASES' or 'SHOW TABLES' etc works here

Entering in 'mysqladmin -u root -h 'localhost' version variables -p'
I get the following error message:
'mysqladmin: connect to server at ''localhost'' failed'
'error: 'Unknown MySQL...

I have a MS Access 2007 database that contains a union query that merges 5 different odbc connections. If one connection is down I receive an 'ODBC--call failed' error and the query is unusable. Is there a way to have the database verify connection and if it cannot connect to one or more odbc, to simply by-pass the odbc(s) and use the others?

I am a website designer with a little bit of knowledge in PHP and MySQL database. I am installing an opensource shopping cart to sell only a few products, about 4, adding much more later on. I am needing to get the MySQL database to communicate with the company database AS/400. I need to know how to automatically set up the MySQL database to export the data such as product purchased, name, shipping address, shipping carier, email etc.. to my companies...

I am using Microsoft Access 2010 and attempting to use a query to pull select data from a linked database. The link is via ODBC.

My connection with the database is fine, I have successfully pulled data from smaller tables. The table I am querying contains approx 50k records. When I write a query to pull all records, Access crashes.

I have attempted to use criteria to pull smaller chunks of data (i.e. by date) but...

Hi,

I am currently trying to link a ODBC database from a server into my MS Visual Studio 2010 asp.net web application. I have the ODBC connection set up on my workstation and all data on the SQL Server. My problem is this: Whenever I access the page it comes up fine, but when I enter a search into the text box and click "submit" I get this error:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name...

Hi,
I have designed an application in Access and I'm linked to existing tables via ODBC connection. It is likely that the users of this application will not have the ODBC connection set up on their computers, it is also likely would not have the rights to do so.

Is there a way I could embed the connection setting in my .mdb file or any other file for that matter?

Let me know if any extra information is requir...

I keep installing MDAC - some kind of database driver so I can connect with me Access db - but I can't see it in my ODBC. I'm fairly new to all of this but I'm not going anywhere at this rate. I have scoured the net and it's very unclear what's going on and how to get past this one.

anyone have any ideas?

I have a database in access that I am trying to pull in and add 1 hour to a specific column [datetime field]. here is what i have so far...

Data1.RecordSou rce = "Select * from [table] where[column]+ #01:00:00 AM#"
Data1.Refresh

error says "date + date not allowed"

any ideas...?

thanks

Newbie to SQL Sever here.

In access it is very easy to set up linked tables using ODBC, the behavior of which is needed to replicate in sql server.

In SQL Server (2008 in this case), I found it easy to import using OBDC using the import wizard. What is not straightforward is either: 1. automating the actions if the import wizard or 2. creating linked tables similar to access. We need auto-refresh of the data rather...

I have a table that is being imported from Sybase that contains > 255 fields.

We only need a small subset of these fields, however, so the desired stored table is something Access can handle (~ 20 columns).

The connection setup is ODBC, and of course, an openrecordset command just gives the first 256 fields. When I do a SELECT on a fields not in the first 255, of course, there is an error.

Is there...

As a lot of my projects involve using an odbc linked backend data source I have found this piece of code to be very useful. I usually trigger it to run on system startup like in AutoExec macro. It avoids any difficulties down the road with broken links and if the DSN name or database server changes then the only edit that needs to be made is to the connection string.

...

Hi everyone...

I need to write a VB procedure for an Excel PivotTable that will change its cached ODBC connection to a new Postgres ODBC connection. I have part of the procedure written but I do not know all the arguements needed for the Postgres connection.

Can anyone help with a VB procedure that would switch from an existing ODBC Oracle connection to a Postgres ODBC connection?

Thanks!!!