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?

max

RELEVANCY SCORE 200
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
RELEVANCY SCORE 56.4

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
RELEVANCY SCORE 56.4

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
RELEVANCY SCORE 56

Hi,

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
RELEVANCY SCORE 56

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
RELEVANCY SCORE 55.2

Hello,
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
RELEVANCY SCORE 55.2

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

Read other answers
RELEVANCY SCORE 54.4

Bonjour!

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
RELEVANCY SCORE 54.4

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.

T.
 

Read other 2 answers
RELEVANCY SCORE 54.4

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

http://publib.boulder.ibm.com/infoce...doc/odbc20.htm

Read other 2 answers
RELEVANCY SCORE 54.4

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
RELEVANCY SCORE 54

Create a batch script for Oracle ODBC connection
 

Read other answers
RELEVANCY SCORE 54

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

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
RELEVANCY SCORE 53.6

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):
./Library/ODBC/odbc.ini
./Library/ODBC/odbcinst.ini
./Users/andynic/Library/ODBC/odbc.ini
./Users/andynic/Library/ODBC/odbcinst.ini
./usr/bin/iodbc-config
./usr/bin/iodbctest
./usr/bin/iodbctestw
./usr/lib/libiodbc.2.1.18.dylib
./usr/lib/libiodbc.2.dylib
./usr/lib/libiodbc.dylib
./usr/lib/libiodbcinst.2.1.18.dylib
./usr/lib/libiodbcinst.2.dylib
./usr/lib/libiodbcinst.dylib
./usr/lib/pkgconfig/libiodbc.pc
./usr/local/bin/myodbc-installer
./usr/local/lib/libmyodbc3S-5.1.5.so
./usr/local/lib/libmyodbc3S.la
./usr/local/lib/libmyodbc3S.so
./usr/local/li... Read more

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

Solution:
By using a combination of the information at
http://www.gyford.com/phil/writing/2004/06/07/installing_dbi_a.php
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.
Andynic
 

Read other 1 answers
RELEVANCY SCORE 47.2

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
RELEVANCY SCORE 38.8

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
RELEVANCY SCORE 38.8
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.

A:Odbc

Try doing a restart and logging in as administrator.

Read other 15 answers
RELEVANCY SCORE 38.8
Q: Odbc?

Hi,

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.

A:Odbc?

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
RELEVANCY SCORE 38.8

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.

Thanks,

Belwar
"BIVRIP!"
 

Read other answers
RELEVANCY SCORE 38.8
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?

A:odbc

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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

http://www.microsoft.com/Data/download.htm
 

Read other 1 answers
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

Can someone help me to reinstall my ODBC drivers. thanks
 

A:ODBC drivers

http://www.roth.net/perl/odbc/faq/
Take a look at that, may be it would help
 

Read other 1 answers
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38.4

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,

Curt
 

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
RELEVANCY SCORE 38.4

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).
http://msdn2.microsoft.com/en-us/data/aa937695.aspx

Check this article out for additional info
http://support.microsoft.com/kb/170769
 

Read other 1 answers
RELEVANCY SCORE 38.4

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
RELEVANCY SCORE 38

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
RELEVANCY SCORE 38

Hi All,
Does anybody know where the ODBC User DSN is stored in user profile (e.g. C:\Users\UserName\AppData\...)? I'd like to enable user roaming profile or folder redirection to store user's ODBC DSN information in a shared folder instead of user local computers.
Thanks,
???

Read other answers
RELEVANCY SCORE 38

I have ODBC set up to query data using an INI file, but when I connect remotely it errors out. What kinds of things should I check to see where the problem is.

I have edited the Host file to include the server ip

The setup uses an INI file for the definition file, the TCIP port and also a prefix, but I am not sure if any of those are an issue..maybe the Port ?

I would not normally use a password and one is not saved
 

Read other answers
RELEVANCY SCORE 38

Hello! Some time ago I installed VisualBasic 6.0 to work on a school project and after finishing It I decided to uninstall VB6.0, but I still have ODBC 32bit in Control Panel and it's not on the "Add/Remove" program list. I also uninstalled the ODBC data registry keys but to no avail. Any tips? Thanks in advance!

A:Uninstalling VB6.0 and ODBC-32bit.

You just want to remove it from Control Panel, correct? Navigate to C:\windows\System32, In search box type

*.cpl

Enter

It will likely be listed as Odbccp32.cpl

You can rename it to make sure it is the correct one. Delete it if it is. Suggest you make a System Restore point just in case.

You might also try the free Revo Uninstaller and see if it finds any traces of the actual installed program.

Download Revo Uninstaller Freeware - Free and Full Download - Uninstall software, remove programs, solve uninstall problems

A Guy

Read other 5 answers
RELEVANCY SCORE 38

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
RELEVANCY SCORE 38

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
RELEVANCY SCORE 38

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
RELEVANCY SCORE 38

I am trying to connect to my database from a company I use. However, I get this ODBC error 3151. They told me to look for the latest version of MDAC, make sure I am running a genuine version of windows, and check for any firewalls. I have done all of the above and still get the error. Any ideas?

A:ODBC Error 3151

Hello iakona55,

okay now , i need to ask some questions

do you ever go to the Windows Update site ?

if not do so and select the custome scan not the recommended

you will be given updates that are not installed thru the auto updater service / you will begiven other patches and updates that all work together with the (mdac)

now are you useing a 3rd party firewall / or the windows default ?

what is its name?

do you have SP 3 installed ?

do you have all the .net frameworks installed ?

please let me know

Read other 2 answers
RELEVANCY SCORE 38

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
RELEVANCY SCORE 38

I don't know if this message belongs here, so forgive me if I'm wrong. I am trying to install a graphic probram, Print ARtist, and after I answer the questions ragarding where to put it , etc it starts to install and gives me the ODBC library is locked andwill not proceed. I have accessed this in 2000 and I don't know what I am doing there so from expewrience, I have not done anything until I talked to someone smarter than I on this one. Any suggestions?
 

A:ODBC locked message

I have no personal experience with the error, but from what I can tell from a little Google research, the error is most likely to occur when some other open program has loaded mdac odbc dlls and is using them.

Try terminating all processes with a user name EXCEPT Explorer before the install and see how it goes.

There is also a rather detailed troubleshooting page here:

http://support.microsoft.com/?id=232060

One suggestion is to use a 3rd party application: System Internals Process Explorer to see if any associated dlls ( Odbc32.dll, Oledb32.dll, and Msado15.dll) are loaded in memory.
 

Read other 1 answers
RELEVANCY SCORE 38

The last few days my laptop has been freezing repeatedly, forcing me to hold down the power button to turn it off because it becomes totally unresponsive.
While running windows defender I noticed the computer would freeze when it got to the file odbcconf.dll.
I tried running another anti-spyware program and it would freeze when it got to the file odbcconf.rsp.
I ran a virus scan using AVG and it froze the computer when it reached the file odbcint.dll.
When I go onto control panel, administrative tools, and click on Data Sources (ODBC) that also freezes the computer.

I'm assuming ODBC is what is freezing my laptop. And that something keeps trying to use it even when I'm not running virus and spyware scans.

After reading on the internet that odbc is not essential, I deleted the odbcconf.rsp file, the odbcconf.dll file and the odbcconf.exe file to see if that would solve the problem, but it didn't help. My laptop froze while windows defender was scanning another file by odbc.
I started deleting all of the odbc files one by one and it froze again.

I did a system restore and everything is back where it was now.

Can you please help? I've tried to find solutions for this but I can't find any issues with ODBC like the one I have. I have no idea what caused this or how to fix it.
My laptop specs:

System: Toshiba Satellite L300
OS: Windows Vista Home Premium SP1
Type: 32-bit
RAM: 1GB
Processor: Intel CPU T1600 1.66GHz, 2 Core(s)
Graphics: Mobile Intel... Read more

A:ODBC is freezing my laptop. I need help...

Read other 16 answers