Over 1 million tech questions and answers.

Solved: ODBC Connection

Q: Solved: ODBC Connection


I'm not sure if i'm posting this in the correct area, but please let me know and I will move to appropriate forum.

I have a application I use that connects to a default ODBC connection "Connection1" which is the production enviroment. I want to create a shortcut on my desktop to point to the TEST enviroment so I don't have to go through and change odbc settings all the time. I added a SQL Server connection under System DSN "Connection2" which point to test database. In the shortcut properties I added to the end of the Target location "-oConnection2" so it looks like this:

C:\programfiles\app\app.exe -o"Connection2"

I saw this setup at another location and trying to set it up on my workstation. I know it's something simple i'm missing. Any help or direction would be great.

Read other answers
Preferred Solution: Solved: ODBC Connection

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)


Hello everyone
Ok, So here is the deal. I have a My SQL database that is being used with a Access 2003 front end. Its using the MY SQL ODBC driver and a User DSN. I have to deploy this front end to about 200 people and don't want to visit each computer to do so. I need to install the drive which i have built a script to do, and i need to create a DSN. How do i create a User DSN or a system DSN with a batch file with a script. I tried to use a File DSN,Which would have made my life easy as i could just have copied that file to all the computers, But it promoted the user to log into the database when a form is open. Which is no good. Can anyone help me?

A:Solved: Create a ODBC connection with a script

I found a code that will work, Thanks

Const HKEY_LOCAL_MACHINE = &H80000002

strComputer = "."

Set objReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _
strComputer & "\root\default:StdRegProv")

strKeyPath = "SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources"
strValueName = "Script Repository"
strValue = "SQL Server"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strKeyPath = "SOFTWARE\ODBC\ODBC.INI\Script Repository"

objReg.CreateKey HKEY_LOCAL_MACHINE,strKeyPath

strKeyPath = "SOFTWARE\ODBC\ODBC.INI\Script Repository"

strValueName = "Database"
strValue = "Script Center"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strValueName = "Driver"
strValue = "C:\WINDOWS\System32\SQLSRV32.dll"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strValueName = "Server"
strValue = "atl-sql-01"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

strValueName = "Trusted_Connection"
strValue = "Yes"
objReg.SetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

Read other 1 answers

Mac OS X 10.6.1
perl 5.8
mysql 5.1
Installed ODBC connector: http://dev.mysql.com/downloads/connector/odbc/5.1.html#macosx-dmg
I am trying to connect to a mysql DB using the perl API.

The connect command looks like this:
$dbHandle = DBI->connect("DBI:ODBC:gfr:localhost", "gfr", "gfr");

It produces the error:
DBI connect('gfr:localhost','gfr',...) failed: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002) at x.pl line 30
error = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (SQL-IM002)

I'v done hours of rummaging around the web to find a solution but to now avail.

In desperation I executed the following "find" command:
cd /
sudo find . -name "*odbc*" -print

It produced the following output (only relevant part shown):
./usr/local/li... Read more

A:Solved: mysql connection using ODBC fails with error SQL_IM002

By using a combination of the information at
and the link within that page under "these simple instructions" (http://www.truerwords.net/articles/osx/install_dbd_mysql.html)
I managed to get DBD working instead of ODBC. That is sufficient for me.
I did the above with one difference. I used a later version of the latest non-beta DBD module.

Read other 1 answers

I am trying to connect to access 2007 but in my odbc there is only a driver for SQL I have 64 bit. I have read some fixes here but still have figured it out can anyone help.

Read other answers

I have connected to a Access DataBase through AutoCAD for 3 years. Recently I get a error SQL client unable to establish SQL connection.
Microsoft ODBC Microsoft Access Driver System Resource exceeded.

Database record is small.
Have looked at other postings on this problem and none seems to be relative. Also most I do not understand how to do what is recommened.
Windows XP
AutoCAD 2013
Access 2007 database.
All help would be appreciated but include steps for trouble shooting.
Thank you in advance

Read other answers

I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would be successful, for several tests, then fail and you would have to reboot the workstation. I have both SQL server and Native Client. Now I am unable to create a connection with either. I've uninstalled the updates which hasn't helped. It seems like the update changed a security setting somewhere. Creating a new connection now fails with SQL state 08001 and server error 10060

Regards Hakit

I have the system working now with both Win 7 and XP Pro but not really happy with the fix. The SQL passwords seem to be stored in a different encryption for these 2 OS's If I change the password on the SQL server then let Win 7 rebuild it the system works ,, but you can't use that login on XP Pro without doing the same thing over again.

A:ODBC connection problem

Hakit, does your workaround work for users with windows authentication?
IF so can you step me through your method for resetting ?

Read other 3 answers

I've developed a site www.kitkrazy.com using PHP, Access and an ODBC connection. It works very well ... most of the time.

Every now and again -- say every three months -- the site crashes, and I get the error message ...

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.,

Most recently I got ...

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded., SQL state S1001 in SQLExecDirect in E:\home\Default\kitkrazy.com\htdocs\include\topthree.php on line 15
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

When I challenge the hosting company on this they always advise me to use a DSN-less connection. Well, it's got to the point where I'm thinking to myself, why don't I just go DSN-less and the hell with it.

So I took a look. And it seems that I'm going to have to rewrite all my SQL queries and database calls. Unless you know different ...

Is there a simple way to convert all my code from ODBC to DSN-less?


A:PHP: Converting from ODBC to DSN-less connection

You should probably convert to MySQL or a real database if you are having trouble with too many users accessing the database. You may also want to check all of your code to see that it is clean and you are closing all open object when the program is done with them. You will have the exact same problem with with a DSN-less connection and it will actually slow your site down. Rewriting the connection string is the only change you will need to make and if you use an include file for the DB connection string all you need to do is change one file.

Read other 2 answers

how I can create a ODBC Connection in windows 8.1 
I am use SQl server Express 2008

Read other answers

I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows :
ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=MS Access Database;DBQ=D:\Acces7dat\STOCKS.mdb;DefaultDir=D:\Acces7dat;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTim" _
), Array("eout=5;")), Destination:=Range("A1")) ... etc , transferring data from MS Access file stocks.mdb to an Excel spreadsheet for proccessing etc . All this works fine for the last three years until I have installed Windows 7 64 bit . Googling the problem found that I have to run the Windows/SysWOW64/obdcad32.exe file . Doing this appears the ODBC Data Source Admiinstrator with the tabs :
User DSN , System DSN , File DSN , Drivers , Tracing , Connection Pooling and About , and I can't configure all this in order to create a ODBC connection . First , is this the correct way to solve the problem and second how to setup the ODBC Data Source Admiinstrator under all these tabs ? Any help ? thanks in advance.
PS : I have reinstall Ms office 2003 in order to add missing items etc but no luck .

A:how to establish a ODBC connection in Windows 7 64 bit ?

the problem was solved by ODBC Data Source Admiinstrator , pressing the button " Add " and afterwards writing " MS Access 2003 " just right the DSN ( = Data Source Name ) label and OK , no matter should understand all of this .

thanks anyway

Read other 1 answers

" the setup routines for the oracle odbc driver could not be loaded due to system error code 998"

Trying to create ODBC connection and then get this error message

also getting same error when trying to remove or edit connection ..

please advice ..URGENT

A:Cant create ODBC connection data resources

You may have the wrong driver as the error suggests.

Try Informix:


Read other 2 answers


We are moving an old Access project from XP too Windows 7 32 and .Net.

However there is something wrong with Windows 7! When I try and create an ODBC link via ODBC Administrator to allow the software to access data tables on SQL Server on the Windows 2003 Server it just keeps producing a message saying the TCP/IP port does not exist or access is denied.

Having tried the same experiment with an XP computer it worked fine, no issues, but Windows 7 strangely doesn't???

The SQL Server is on standard port 1433, I tried turning the firewall off in Windows 7 but that made no difference, when installing Windows 7 and connecting it too the network it complained it needed a DNS address so I put one on the server and set that in the Windows 7 client.

The XP client never needed one, could that be linked to this odd issue?

My first experience of Windows 7 this is and it seems like Microsoft have struck again by taking something that works and making it unnecessarily difficult...

Of course I could be wrong

Read other answers

I have recently updated my ODBC connection settings to my sql database, however when I open a word 2003 document to mailmerge it still tries to connect to the old database settings.
Is there a way to refresh the settings in the word document so that it acknowledges the changes?
Any help is much appreciated

A:ODBC Connection doesn't update when trying to mailmerge.

Hi Gortini. Welcome to the TSG Forums

I suggest that you ask a Moderator to move your post to "Software & Hardware, Business Applications" as you are more likely to get a reply there than in the Windows XP Forum.

Please do NOT post again. You must ask a Moderator to move the post.


Read other 2 answers

I have two laptops at my company that have Windows 7 Home - thus cannot login to AD/Domain as a specific user. They in-turn use a local administrative account setup on those laptops. We have a database setup with linked connections to our SQL Server 2005.

Whenever we're trying to access those linked tables we get the following error message:
We can bypass this issue by manually typing in the Login/Password within this error prompt.
What's strange is that we have ODBC setup to use the SQL Server Authentication:
That SHOULD allow us to not use Windows Authentication (as you can see it's trying to use the 'Guest' account on Windows 7. I've tried making this change through both x32 and x64 versions of ODBC (located in wow64). I've searched all over the internet concerning this issue but no one seems to have anything similar. This used to work a few weeks ago and I don't know of anything we changed other than a few system updates.

The SQL Server's Security is setup to use both authentication methods:
Our SQL Server gives us an Error: 18456, Severity: 14, State: 11
A quick Google search explains that State 11 means, "Valid login but server access failure".

Any help please? The only solution I have right now is to install W7 Pro...

A:Access & ODBC connection issue on W7 Home, State 11

Sound like a Windows permissions issue to see the SQL server.

You could also map a network drive using other credentials. This will authenticate the computer onto the domain.

Read other 4 answers

Create a batch script for Oracle ODBC connection

Read other answers

I friend of mine uses windows 2000 and needs ODBC for a school project.

Thing is, it doesn't seem to exist in her control panel.

Do you have any ideas what may be the cause of that?

A:[Solved] ODBC missing

Read other 7 answers

Hi all. Does anyone know where a file is on a computer that stores data for ODBC connections. There has got to be a way to migrate these settings. I have looked at .dsn files, as well as the ODBC.ini file.

A:Solved: ODBC connections

Read other 7 answers

Hello again,

I am trying to creat a ODBC Data Source for my Access Database, so that I can see it in Open Office. I can't find the ODBC icon under the Control Panel however. Does anyone know where I can find it? I'm running Windows XP Professional SP2.


A:Solved: ODBC icon in Windows XP?

Found it. Sorry about the post.

Read other 2 answers

When I am testing an ASP page by Dreamwaever, I encountered an error about my IIS or PWS:

OLE DB Provider error for ODBC Drivers error 80004005
[Microsoft] [ODBC Driver Manager] Data Source Name not found and no default driver specified.

I went to the Knowledge Base at Microsoft site and pull out an article (190006).

My question is that my os happens to be Window 98II and their suggestion seem to be for WindowNT.

How to resolve this. Any help will be appreciated!!!

The following is an excerpt from the article:

The Global.asa file is not located in the root directory of the application.
To determine if a directory is designated as an application root and verify that it also contains the Global.asa file, perform the following steps:
1. In the Internet Service Manager (ISM), verify that the node is configured as an application.

To do this, verify that the node displays the package icon in the ISM. To further verify, view the property sheet for that node. On the Virtual Directory tab, under Application Settings, an active name should be listed for the application. If the name is "Default Application" and it appears dimmed, the node is NOT an application.
2. Verify that the Global.asa file is located in the root directory of the application.

To determine the root directory of the application, view the property sheet for the application. Check the Local Path setting on the Virtual Directory tab.

A:(Solved) ODBC 80004005 error

I would check out the info on Macromedia's site.




Read other 3 answers

I have an Access table linked to MSSQL. The table has a primary key with no additional indices. I receive write conflict errors when I attempt to update some records (not all) while in an access form or directly in the table via Access. Changes in SQL work fine. Very strange - some records can be changed, while others cannot, seemingly without any pattern related to position in the table or data contents. NO triggers exist in the DB. What is going on?

A:Solved: Access w/ ODBC MSSQL - Write Conflict

Read other 9 answers
Q: odbc

could the odbc be used to tell windows how to surf the internet safely? to look for scripts in media/images/controls that could be malicious or cause unwanted or unintended behavior of hardware?


No, here is a definition of ODBC What is ODBC? - A Word Definition From the Webopedia Computer Dictionary

Install Firefox and get the AdBlock Plus and NOScript addons. Thats the safest way.

Read other 8 answers

My friend and coworker has a Windows 98 system. He has an OSD error showing up at boot that is linked the odbc.hta. What is the fix for this? Also, he as a Click Me! link on his desktop and in the start menu that upon deletion, are back the next time he boots his computer. Any ideas will help greatly.



Read other answers

While creating user DSN through ODBC for Personal Oracle 8 for Win95, it is giving error as ODBC Driver could not be coded due to system error code 1157. I've already installed Oracle for 2 times. Still problem is there.

Can anybody help ?

Read other answers
Q: Odbc?


I have a question about ODBC and I'm hoping that someone can help. Is this something that comes routinely with Windows XP Home edition, or is it something that had to have been installed? I have just recently noticed it on my computer.

I am asking because I am wondering if this was placed on my machine by someone.

Thank you.


It is the Control Panel Applet that controls your access to Database files both locally (on your computer) and on a network. It is installed when you install Office. Don't worry about it. It will not hurt a thing. If you would like to read more about ODBC, check out the following links: Whatis.com for ODBC Includes many other links. http://searchoracle.techtarget.com/sDefini...i214133,00.html Description of Control Panel (.cpl) Files (Q149648) Microsoft KB article describing the default Control panel applets and their names. http://support.microsoft.com/default.aspx?...b;EN-US;q149648 Microsoft Developer Network (MSDN) writeup on ODBChttp://msdn.microsoft.com/library/default....dbcoverview.asp

Read other 4 answers
Q: Odbc

I am trying to make some changes in the odbc system but I keep getting this error. Here is a link to a snap shot.

Untitled Document

Can't find the place to make a change I am logged on as an administrator.


Try doing a restart and logging in as administrator.

Read other 15 answers

I administer a Windows server running Exchange 2003. We have specialized business application (basically the AR side of the business) that has captured names, addresses, phone numbers, etc. for all our members. It is based on Pervasive SQL.

I'd like to find a way to connect Outlook to that member data. I can do it now via export to csv and import to a Contacts folder. That means Outlook does not have live data.

I'd like to find a way to implement an LDAP connection to the data (probably via ODBC). A short search of the web did not turn up anything I could see to be useful.

Suggestions please....

Read other answers

Hi everyone,
i'm trying to connect to a database shared on the network. My problem is that the server name is not recognized by my PC using a wireless connection. In this case i have to use the IP address 192.168...
In all the other PC, cabled, i can use the literal name.
What can i do to fix the problem? 
i tried to map a drive using G:\[path] but i can't succeed

Read other answers

I'm using Access 97 on a Windows 2000 machine. Monthly, I get a Cognos Powerplay cube file (.mdc), with which I run reports using the Cognos Powerplay application.

I would like to use Access on this file to automate what I do manually in Powerplay. I am proficient in Access VB but I have not used DAO or ODBC. I've read the on-line help and I believe I need ODBC drivers but that is about as much as I get out of it.

Can someone tell me how to get started with this?

Thanks in advance,


A:MS Access and ODBC

You need to contact them for the driver. I didn't see anything on their web site, but they may have one.

Read other 1 answers

Hi All,

I have two issues with Access 2003 on two different machines running XP. Both users are members of the administrators group on the local machine.

1. On the first machine when I try to link to an external data source I get "Registry Error" in the drop down box "Files of type". There are a few data sources there like Excel, dBase etc but ODBC is missing. I have uninstalled and reinstalled Office 2003 and have even tried repairing it. I have also gone to the c:\windows\system32 dir and registered all the ms*40.dll's. I have also reinstalled XP albeit just the upgrade option as opposed to a full reinstall. None of the above has worked.

2. On the other machine I am trying to link to a Foxpro 2.6 for dos (don't ask why it is a very long story!) free table ODBC connection. I get the the ODBC connection and am able to choose the Foxpro connection (Visual Foxpro Driver 6.01.8629.01) but then it throws the error

[Microsoft][ODBC Visual FoxPro Driver]Function sequence error (#0)

The annoying thing is that if I link a table on another machine and copy the database I can open the table and edit the data. Also if I log in as administrator locally I can use the ODBC connection to connect to the tables but not as my username on the domain. Again my domain account is a member of the local administrators. I have done all the reinstals as described in the first point and reregistered the dll's.

I have also reinstalled MDAC on both machines by goi... Read more

Read other answers

I have a vista 64 bit and there are not any drivers for access how do I install the odbc drivers so that I can use access. The only drivers there are for sql

A:ODBC drivers

Go to C:\Windows\syswow64 and execute odbcad32.exe in order to work with your MS office databases.
Alternatively you can also run the file from C:\Windows\System32 which has the same odbcad32.exe file.
Hope this helps !

Read other 5 answers

Background: We run this program at work called "Surgisource", it is a medical billing program of sorts. Most of our computers here run Windows XP 32bit and the software runs without fail. We have aproximately 10 Windows 7 machines of which only a few are running Surgisource. Of these few only 2 are x64. Of these 2, Surgisource runs perfectly fine on one, and has issues on the other. Since in all likelihood no one will understand the nature of the software discussed here I will speak in generalities; one user is trying to generate reports and gets a "534" error on 2 of these specific reports when she adjusts the date renge beyond one month. I called Surgisource and they don't support x64 (the software is x32) but they seemed absolutely certain that the error had to do with the ODBC configuration. I am fully aware that there is a 32bit ODBC config utility which is what I used.

Now for my question: Does the ODBC config "embed" itself somewhere on Windows 7 outside of the actual config utility? Like somewhere in the registry, or in an .ini file?

At this point I suspect the problem has something to do with the ODBC config not correcting itself (upon being altered via the utility) at the location/file where the actual ODBC info is written. Here is my evidence:

In order for this software to work you have to have the ODBC configured because the data source is located on a server and by default the software does not know where this is. It is critica... Read more

A:ODBC Configuration

Man, I loathe wrestling with ODBC sources (hello IBM DB2). You say one of the x64 machines runs fine, while the problem is only present on the other one?

You could root arount the registry and compare their settings to see if there's any difference. Apply standard registry editing precautions here (make backups, don't touch anything you don't understand, etc).

Main system DSN info should be in HKLM\Software\Wow6432Node\ODBC\ODBC.INI
ODBC driver info should be in HKLM\Software\Wow6432Node\ODBC\ODBCINST.INI
Some 32-bit driver info may be in HKLM\Software\ODBC\ODBCINST.INI
User DSN info should be in HKCU\Software\ODBC\ODBC.INI

You could also fire up Process Monitor (a free download app now owned by Microsoft) and check the registry access records for C:\Windows\SysWOW64\odbcad32.exe (the ODBC Data Source Administrator), to find out what registry keys to search for DSN info. This is something of a last resort though, the info you need should be in the keys above.

Compare the settings in the working installation with the settings in the one where it's not working and see.

Read other 1 answers

Can someone help me to reinstall my ODBC drivers. thanks

A:ODBC drivers

Take a look at that, may be it would help

Read other 1 answers

Hi guys, I installed a bank application on my windows xp machine, that application has a server which loads the templates/data to be used on that application. However, after installing the app. I encounterred an error on most of the pc (except mine) error shows that "Source: Microsoft OLE DB Provider for ODBC Drivers [ODBC Driver Manager] Driver does not support this function"

The installation procedure of this application in XP was just a typical installation setup except that after completely installing it, I have to change the .ini file and path it to the server.

Its also a mystery to me that my error is on ODBC since I am not using any odbc connection for this one.

I hope anyone can help me on this one. Thanks

Read other answers

Not sure if this is in the right section, I don't know a lot about this just trying to configure every last thing that matters, Windows sucks enough yeah and some things are just visual tweaks but not something you'd think about doing automatically, or re-arraging folders.

So the first thing I notice is in this control panel there seem to be Spanish ODBC drivers... how do I uninstall them, or are they needed for something when you don't speak spanish? (I install all language packs I can find so I dont' get squares and ?s on internet pages, other then that I have no use for most languages.) As well is there some easy way to update the rest of the ODBC drivers without intense Googling? Do I need the ones that seem to be for programs that I will never use (such as "Microsoft Fox")? If so how do I uninstall them?

Posted in this section because everything other then SQL seems to have something to do with a business application.

A:ODBC drivers?

You can ignore the extra ODBCs (Open Database Connections). There would be not much value gained from deleting them. Why are you messing around with the ODBCs anyhow, are you doing development or setting up connections to a database on the backend of another database?

My Aunt, Uncle and cousins used to live in Schaumberg.

Read other 3 answers

Sometimes when I try to start an application I get the following popup usually after many moments of being hung up...

Please advise on how to reinstall ODBC drivers to resolve this problem

Thanks for a great resource

A:ODBC Errors

Download and install the latest version of the Microsoft Data Access Components (MDAC).

Check this article out for additional info

Read other 1 answers

microsoft odbc driver setup for nt 4.0? i'm having trouble installing a tape backup apparatus, and it's asking for updated odbc drivers.

A:odbc drivers--where can i get the


Read other 1 answers

I want to connect my access database to an ODBC connection. Basicallt, we have this system that we use with a lot of information so basically, I created a field in my access database and what I want it to do is that I will have one field that will be the indentifier meaning when I enter a name there, I want all other info associated with that name to show up on my form. Problem is I dont know how to do that. Can you help me?

A:Access with ODBC

Read other 15 answers

I have mediamonkey on my desktop pc and love it So decided to install it on my laptop too
But it wont open at all
a message comes up saying I need ODBC DSN whateve that is lol
Went to the microsoft site as it said and downloaded the file But it said I have a later version of it already installed
Have real player installed no prob
Help please - and make it very simple please.

Read other answers

I have following problem:

I was running Application under Visual Studion 2005 that connects to MDB file when it threw an error that I don't have OLEDB driver installed on my machine.

I checked in "Administrative Tools - > Data Sources (ODBC)" in "User DSN" tab. There I have list of three: dBASE Files, Excel Files, MS Access Database. I selected each of them and clicked "Configer...". It threw an error: "The setup routines for the ...... ODBC driver could not be found. Please reinstall the driver."

I was looking on how to reinstall MDAC in "Control Panel -> Programms -> Turn Windows features on or off" and was unssuccefull.

I'll apprishiate any help. Thanks.

A:ODBC crashed

Problem solved. Solution was found on the Web. Needs to change the Application target in the Project Setting for 32bit.

Read other 1 answers

I am using Vb6, ADO, and Ms Access as Database, I have an multiuser application which runs on 3 machines. I use OBDC DSN for connecting.
Whenever I update particular table in Windows Xp Version as O/s I get an message record locked by another user on machine. ODBC Error
but if the same application is running with WIN98 SE the records get updated perfectly fine. MS Access version depends on end user choice may be from 97,2000,xp

A:Xp Odbc Problem

Are you using optimistic locking for your odbc?

Read other 3 answers

I have several Windows 7 32-bit PC?s I need to connect to SQL 2008r2 64bit. I have tried to configure 32-bit ODBC native clients 10, 11 and 13. None will connect. Upgrading the PC?s to 64-bit
PC?s is not possible at this time. Anyone have the same problem or solutions?

Read other answers

Keep on getting errors while using ColdFusion
I reinstalled MS Access 97 but keep getting this dialog box
when I turn on ColdFusion Server 4.0.1

ODBC Driver Manager
is a different version than the ODBC driver manager
You need to reinstall the ODBC components to ensure proper operation

How do I reinstal the ODBC components?

A:Access 97 ODBC manager

Go to the setup again and select options and select Data Access Components

Read other 1 answers

Hi All

After installing the drivers for V5R2, I reboot and then once logged in I get this warning:

"Your service source directory (\\servername\path\V5r1\Express\Install\Image), has ISeries Access for Windows version V5R1MO. Your compuer has ISeries Access for Windows version V5R2MO.

Service Pack (SP) cannot be installed because your computer's version is newer than your service source directory's.
My goal is to have Client Access ODBC driver (32-bit) version 9.00.08 (cwbodbc.dll).

Does installing the service pack get me to version 9.00.08 ? Right now I'm at version 9.00.00. And futhermore, how can I get past this warning/error


Read other answers

Is this something that I can delete?

Abbreviation of Open DataBase Connectivity, a standard database access method developed by Microsoft Corporation.

The aim of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver, between an application and the DBMS.

The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them.
http://www.gordano.com/kb.htm?q=267Click to expand...

This sounds "sketchy" as hell. Does anyone know anything about this software key?

other sketcy programs:
Lake+dolbyhph? DELETED
LEAD Technologies? DELETED
intermute adsubtract DELETED
softshape http://www.softshape.com/ DELETED LOL
sunssystems+staroffice: http://www.sun.com/software/staroffice DELETED
MCCI:http://www.answers.com/topic/motive-inc-1 any info here?
http://www.mcci.com/mcci-v5/index.html DELETED. might be my samsung usb drivers..:Z ill just reinstall if thats that case
Metastream3; dangerous? dunno but it makes those cool 3d views possible.
Pctools http://www.pctools.com/spyware-doctor/?ref=google& Dgclid=CJ_dn7TBypcCFQOeFQodlSAhTA DR PHIL? LOL Deleted.
support... Read more

A:Does ODBC facilitate Malware?

ODBC is Open Data Base Connectivity. After reading in Wikipedia,I don't believe I would remove it.

Read other 2 answers

MS Access 2003 Pro:

I am trying to link to external data via ODBC. When I select "Link Tables",
the dialog opens and I drop the file type box down to ODBC. As soon as I
click on the ODBC file type, the dialog closes and I am returned to the
Access main window - nothing happens! If I open a database that already has
tables linked to it via ODBC, I AM able to access those ODBC tables (DB2 UDB,
iSeries AS/400). I just cannot link or import a NEW ODBC table on THIS

I can link to ODBC sources from other applications on this machine (like
Crystal Reports) just not from MS Access. Is there something I need to do to
this machine so that Access can connect via ODBC. Is there some .ini setting that has gotten corrupted? Please help. This used to work fine. Thanks.

A:Cannot link via ODBC from this machine

Read other 9 answers

I just reformatted my hdd and installed win 2k. I am trying to install Print artist and it goes through the preporatory steps then when it starts the installation, it show ODBC library is locked. ODBC will not continue. IO have all my processes shut down in the background, virus checkers, popup stoppers etc. What els can I doe and how do I get around this. Thanks

A:ODBC locked message

Boot to safe mode and try the installation.

Read other 2 answers

i atempted to launch a program today and recieved this error message "failure to connect to datasource:[microsoft][odbc driver manager] data source name not found and no default driver specified" i reinstalled the program and still get the same message any help would be greatly appreciated

A:head scratcher about odbc

What program are you trying to install?
What OS you are using?

Read other 2 answers