Over 1 million tech questions and answers.

PHP: Converting from ODBC to DSN-less connection

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

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?


Preferred Solution: PHP: Converting from ODBC to DSN-less connection

I recommend downloading and running DAP. It can help sort out any driver and firmware related issues on your system

It's worked out well for many of us in the past.

You can download it direct from this link http://downloaddap.org. (This link will open the download page of DAP so you can save a copy to your computer.)

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

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 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

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 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

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

Read other 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

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

" 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

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

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 bought a chunk of SilenX fans, and all was easy for finding spots--since they all come with a 3-pin to 4-pin Molex adapter. However, the 120mm fan has a 2-pin connection. The problem: The adapter that it comes with is for 3-pins... not 2. So now I'm wondering what to do for it.

I found this site that simply shaves the one piece down, but since I haven't tested out the fan, I'm a bit skeptical. I don't want to trim anything off that'll screw over any chance of me being able to get a new one if fo some reason this one is messed.

Any ideas?

A:Converting a fan's connection.

Can't you just plug it onto the two pins and leave the extra one for the tach flapping in the breeze?

Read other 3 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

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

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
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

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 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

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

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

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

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

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

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

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'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

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

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

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

Is this something that I should worry about?

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?

A:Does ODBC facilitate Malware?

Before ODBC, it used to be that you have to have specific database client software on a client machine to talk to each particular brand of database server. ODBC is now the standard middleman, so any application that uses ODBC can talk to most database servers. I use to be a database programmer.

Read other 1 answers

Hi Support,
We are using Windows 7 Professional operating system of 64 bit.The MS-office application is 2013.
The issue is that we are not able to install the Microsoft ODBC Administrator.
I have shared the screenshot for your reference.
Please guide us how to install it and also request your support to give the link for downloading the same.
Thank you in advance.

Read other answers

hiwe have installed 3 more windows 2000 Pro machines in a network with sp4 & all necessary security updates are in place. we have configured microsoft access database (ODBC) from admin templates and provide database location. But in one machine the odbc the odbc setting is disappear automatically once we restart the machine. the remaining working well.What kind of error it could be? How to troubleshoot this issue?pls help me out.

A:ODBC settings disappear

Read other 6 answers

i try to install Goldmine ver 9x today on new Win 7 Pro 32 bit PC
When I select SQL as my connection type i get the errror 

"the setup routines for SQL server ODBC driver could not be accessed. Please reinstall the driver"

I have tried to re register the dll  by running " regsvr32 odbcconf.dll "
I have also checked the registry and the values for SQL connection are corrent.
Any idea?

A:ODBC Driver Error

to resolve the case.
Send user copy of
sqlsrv32.dll file
The registry entries a slightly different as those stated in the document.  (http://support.microsoft.com/default.aspx?scid=kb;en-us;260558)
However I was able to match them up with those on a working windows 7 PC.  This seemed to do the trick


Read other 5 answers

I have Win 7 Ultimate 64 bit. I have the following problem..
when I try to install an ODBC connection (*mdb),
Data sources ODBC > SYSTEM DSN > ADD > (here only sql server is listd, not .mdb) and also
I get the following fault message:
"The Microsoft Access Driver (.mdb) ODBC driver could not be found. Please reinstall the driver". i have ms access 2003.
I need this for database connectivity with webpages. i need to solve this issue urgently...

A:ODBC Setup Problem

please anyone help me ...

Read other 9 answers

Hi everybody,

Good day,,,

I have an issue with the Above mentioned title,

We have developed an in house application with VB & Oracle 10 G as backend & Crystal reports 8.1.5 for Repoting.

This works for me windows XP Prof. when i am trying to install in Vista O/S am getting an error when i try to open ODBC Control pannel " CR SQL BASE " invalid operation

Can Anyone help me in this.


Read other answers

In making the ODBC connection to my external database while linking the table to Access 2010, I forgot to check the Save Password checkbox when I was choosing the tables to link to. Is there any way to do that now (save the password) without redoing the whole project from scratch?



A:Access ODBC Password

Read other 7 answers

where from can i get the ODBC drivers for MS Access? the drivers which are used in system DSN in ODBC section???

A:ODBC Drivers for Vista 64 bit

hi try here http://msmvps.com/blogs/spywaresucks...11/897398.aspx hope it is what your looking for

Read other 2 answers

I'm not quite sure where to put this, so please feel free to move it if there is a more appropriate area.

I have a Microsoft Access database which has linked tables; the tables are from my organization's data repository so I access them over the network. I have a maketable query which is supposed to pull information from those linked tables and create a new table which has just the info I need.

I'm able to open up all of the linked tables just fine, but whenever I run the maketable query I get "ODBC call failed Timeout expired (#0)". I tried deleting the linked tables and re-linking, but I get the same error when I run the maketable query. I tried closing down Access and restarting, but I still get that error on the maketable query.

Any thoughts on that error? The maketable query was working two weeks ago. If the ODBC call was really failing, I wouldn't be able to open the linked tables, would I? Especially after deleting the previous links and re-linking?


A:ODBC call failing?

Never mind -- I answered my own question. I had to set the ODBC timeout to 0; it was set to 60 and since these tables are massive, it kept timing out.

Read other 2 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

I use Windows 98 with Internet Explorer 6. When I go online I get a small moveable window marked C:/WINDOWS/odbc.hta which comes up usually when I shut a window. I can remove it by clicking on the time in the bottom right hand corner of the screen, but I would like to stop it appearing at all. It seemed to start soon after a virus attack which I think I've cleared. McAfee scans suggest no infection. I'd be very grateful for any suggestions for stopping this?

A:Malicious C:/WINDOWS/odbc.hta

Read other 6 answers