Over 1 million tech questions and answers.

Solved: mysql connection using ODBC fails with error SQL_IM002

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

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/lib/libmyodbc5-5.1.5.so
./usr/local/lib/libmyodbc5.la
./usr/local/lib/libmyodbc5.so
./usr/local/mysql-5.1.39-osx10.5-x86_64/mysql-test/r/odbc.result
./usr/local/mysql-5.1.39-osx10.5-x86_64/mysql-test/t/odbc.test
./usr/local/mysql-5.1.39-osx10.5-x86_64/sql-bench/limits/access_odbc.cfg
./usr/local/share/mysql-connector-odbc-5
./usr/share/libiodbc
./usr/share/libiodbc/samples/iodbctest.c
./usr/share/man/man1/iodbc-config.1.gz
./usr/share/man/man1/iodbctest.1.gz
./usr/share/man/man1/iodbctestw.1

One by one I added the following "use" statments to the test script:
use DBI;
use lib "/Library/ODBC";
use lib "/usr/bin";
use lib "/usr/lib";
use lib "/usr/lib/pkgconfig";
use lib "/usr/local/bin";
use lib "/usr/local/lib";
use lib "/Users/andynic/Library/ODBC";
use lib "/usr/local/share";

All produced the error shown above.

Don't know where to turn next.
Would appreciate any ideas anyone can offer.

Thanks for your help.
Andynic
PS:
The full test script:
#!/usr/local/ActivePerl-5.8/bin/perl

use strict;
use DBI;
use lib "/Library/ODBC";
use lib "/usr/bin";
use lib "/usr/lib";
use lib "/usr/lib/pkgconfig";
use lib "/usr/local/bin";
use lib "/usr/local/lib";
use lib "/Users/andynic/Library/ODBC";
use lib "/usr/local/share";

# use DBD::ODBC;
# use DBD::mysql;
our $GCdbUn = "gfr";
our $GCdbPw = "gfr";
our $GCdbSchemaName = "gfr";

my $dbHandle = "";

print join "\n", @INC;
print "\n\n";
$dbHandle = DBI->connect("DBI:ODBC:gfr:localhost", "gfr", "gfr");
# $dbHandle = DBI->connect("DSN=mysql;UID=gfr;PWD=gfr;DATABASE=gfr");
# $dbHandle = DBI->connect("DBI:ODBC:$GCdbSchemaName", $GCdbUn, $GCdbPw);

print "error = ".DBI->errstr."\n";

RELEVANCY SCORE 200
Preferred Solution: Solved: mysql connection using ODBC fails with error SQL_IM002

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

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 72

Hello and thank you for reading my post.

My software creates MySQL ODBC System DSNs...
... except it doesn't work with Windows 7.
It used to work with the previous Windows OSes including XP, Vista.
I've been struggling the whole day trying to find a solution.

*** I believe UAC (User Account Control) has something to do with this.
But I can't disable it as my customers have it usually enabled.
How can my application be allowed to create MySQL ODBC System DSNs and as a "normal" user?

*** The MySQL ODBC connector I have installed is:
mysql-connector-odbc-3.51.30-win32
and I have installed it logged as "Administrator".
(I also installed my application logged as "Administrator").

*** The MySQL server is on localhost for now... (that is to say on the same host as the application).

*** I've already updated the "Target" in the "Shortcut" tab in "Data Sources (ODBC) Properties" to "%windir%\syswow64\odbcad32.exe"
so that the "Drivers" tab is properly populated, including "MySQL ODBC 3.51 Driver".

*** Logged as "Administrator" (which shouldn't be of course: this account is disabled by default, I enabled it for testing reasons), MySQL ODBC DSNs are created but they are empty:
- only the "Data Source Name" field is not;
- the "TCP/IP Server", "User", "Password" and "Database" fields are empty.

*** In my application it results in th... Read more

A:Windows 7 - MySQL ODBC System DSN creation

Most likely yes, UAC is the cause of the problem. Changing system DSNs naturally requires administrator privileges and therefore CANNOT be done by normal users, UAC or not (UAC makes this worse by converting admins to normal users under the covers). But it's the normal, expected behavior, as regular applications aren't supposed to messing with global DSNs, and only elevated ones are allowed. Respecting that is the whole point of the admin/regular user distinction. You app seems to be abusing its administrative rights on pre-UAC systems.

First, as a side note, I think using DSNs is a bad programming practice, as it ties the database access to something not entirely manageable by the app itself. I would store the server/database/user/password somewhere else, where you know, and build a connection string from it at runtime and use that to connect, therefore forgetting the problems of DSNs. Such refactoring may be easy or complicated, depending how is the program made, but in the long run I think it's the best solution.

If you want to continue use DSNs, then at some point you must elevate the app to allow such change. I guess that the DSN is changed from a configuration screen somewhere where the user chooses the database, then the whole program simply uses that.
The idea is to create a second executable program and manifest it as "require administrator" and make that program make the changes, after UAC prompt. The main one can call that second passing the data t... Read more

Read other 2 answers
RELEVANCY SCORE 72

Hi,

I have a server running linux with Apache and MySQL. now I am trying to create an ODBC link through my XP machine. I have installed the ODBC driver and everything.

i am trying to create a system DSN connector. At the stage where it asks me about servername password, user, etc... I just cant figure out what to type in server. Should it be the IP address or anything else behind it. Because when I used the IP it says

[MySQL][ODBC 3.51 Driver]#HY000Host '88-106-153-88.dynamic.dsl.as9105.com' is not allowed to connect to this MySQL server

any ideas? Thanks
 

A:Connecting through ODBC from Win XP to Linux MySQL Server

Well all I know about is MS SQL server and its on the domain but I usually use this type of method -

www.fontstuff.com/ebooks/free/fsLinkingToSQLServer.pdf

With linux I would think you should just need to type in the machine name.

Also with this setup is this all local or is this across the internet?
 

Read other 1 answers
RELEVANCY SCORE 66.4

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 64.8

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 63.2

I'm setting up a local DB and trying to connect with ASP. I getting the error:

Microsoft OLE DB Provider for ODBC Drivers

error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified/BasicSite/WoWDB.asp, line 29

Line 29 is:
Connection.Open ConnString

ConnString is declared on Line 22 as:
ConnString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=wowdb;USER=root;PASSWORD=password;OPTION=3"

Running Windows 7 Enterprise, IIS 7, MySQL 5.1
The database is working. I can get a SELECT * statment to work. I think I just don't have the connection string correct.
Any Ideas?
 

A:Solved: ASP MySQL database connection

Take a look at this link, sounds like a similar problem...

Danny
 

Read other 3 answers
RELEVANCY SCORE 62

I've installed and configured Apache 2.0.49 and mysql 4.0.18, configured for php, and configured the database using phpmyadmin 4.3.77 on Windows Server 2003 Enterprise. I'm using a linksys DL-604 on a lan.

When I connect to phpmyadmin on the server, there's no problem. When I connect to phpmyadmin from my work machine with xp pro, either with Mozilla, or IE, I can log in, but can't do anything once there. I also get access denied when I'm trying to set up the mysql database connection in Dreamweaver. Passwords are set, and I'm using them. I've made certain that the passwords match. I can only see the default test database connection as available in Dreamweaver. It's StudioMX I'm using, but not StudioMX 2004. Even though I've created the database, the user, and password, I'm denied access, but as I said, the test database is accessible. That seems to narrow it down to being a mysql problem.
Has anyone experienced this before?
Thanks.
 

A:[Solved] mysql/phpmyadmin database connection problems

there are pemissions not only as to who can connect, but where they can connect from. Look into the mysql permissions for the host setting. That tells you what IPs a user can connect from. My guess is that you don't have permissions to connect from any machine other than the one that works.
 

Read other 2 answers
RELEVANCY SCORE 60.8

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:

CAUSE
The Global.asa file is not located in the root directory of the application.
WORKAROUND
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.

http://www.macromedia.com/support/ultradev/ts/documents/8004005_cannot_open_unknown.htm

http://www.webthang.co.uk/tuts/tuts_dmx/dmxf_2/dmx2_10.asp

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=80004005+asp+dreamweaver&btnG=Google+Search
 

Read other 3 answers
RELEVANCY SCORE 59.2

You guessed it I am trying to get your attention. Until recently I have done quite well solving business problem using Excel, However my next project is to replace a paper based quality control system with a software solution that I can run off a Palm Pilot or similar device. Let me explain:

1) the receiver has to receive ingredients and log vital statistics on a form, - how much, what it was, the lot number, the carrier, etc

2) the formulator has to select certain ingredients and make a product, here again a paper record tracks, lot numbers, ingredient names, etc

3) the QC person has to check the product during manufacture and record vitals such a lot Number, temperature, colour. Texture, etc
4) if something does wrong and we have to recall a product we need to know - what was produced, where it went to, quantities, how many products are impacted, etc.

I want to build a database with the appropriate forms, report generation capability and product traceability (product recall) capability.

I am told Excel is not the product to use and the name MySQL and Access has been mentioned. Problem is, at this time I do not want to use the web; I simply want an internal system that is fast, effective and reliable.

Maybe you understand the essence of my application (food quality control) and can offer some ideas.
 

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

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 56

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
 

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 55.6

Hello, since the other day, my DSL connection continues to fail on my desktop PC but it is working on my netbook which I'm using right now, hooked towards my monitor.

I have tried everything I could to fix it. I ran the troubleshooter, unplugged my network cable, reset the adapter, deleted and recreated my connection and it fails. It would show up ERROR 638. I even reformatted my PC and the network continues to fail. It did manage to connect for a few minutes earlier today and would just automatically disconnect a few moments later. It continues to fail in connecting right now. Could it be a physical hardware problem with my built-in LAN adapter?

I have a screenshot to help explain the situation and also a zipped diagnostic log which I have initiated after running the "diagnostics" link on the ERROR 638 message. Any ideas?

A:DSL Connection fails, Error 638

When this connection fails, the first thing that I would do is to go into Device Manager, expand Network Adapters, right-click on your LAN adapter, and check its status.

Is it still Installed? Working? Disabled? Any error condition? It does sound to me as if the motherboard's LAN adapter itself is intermittent or failing, as you suggest, or perhaps the cable is faulty.

I would also check the rear panel LAN socket indicator lights to see if they're lit and flashing like they should be, according to your mobo manual.

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

i want to know how to make a connection to MYSQL using php code

please send suggessions

thanks.

http://www.maxyourhits.com
 

A:connection to MySQL

If your not sure on how to connect to a mysql database then dont do it, learn a bit of PHP and sql....

Also make sure your server has php and mysql enabled...
 

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

Create a batch script for Oracle ODBC connection
 

Read other answers
RELEVANCY SCORE 53.2

I'm using the Microsoft RDP app for android, trying to connect to a Windows 8.1 Pro 64bit.  I've enabled require network authentication.  I have McAfee Internet Security, and the firewall is configured to allow RDP connections on port 3389.  With
the firewall ON, I get Error 0x204.  With the firewall OFF, I get Error 0x207, although the first time I was prompted with an unknown certificate warning before RDP tried to authenticate.  I switched from using a specific username/password to Ask
Every time.  After that the 0x207 error popped up.
Ideas?

Read other answers
RELEVANCY SCORE 53.2

My PC Info:
Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft® Windows Vista™ Home Premium , Service Pack 1, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU T5850 @ 2.16GHz, x64 Family 6 Model 15 Stepping 13
Processor Count: 2
RAM: 3069 Mb
Graphics Card: ATI Mobility Radeon HD 3450 , 256 Mb
Hard Drives: C: Total - 305242 MB, Free - 252510 MB;
Motherboard: Dell Inc., 0F700C, , .8QQVVG1.CN4864388L1948.
Antivirus: Norton Security Suite, Disabled

So I am having issues connecting to the internet. I can connect during safe mode but not on normal boot. I ran a diagnostic and it said that the IP Gateway failed. I read a previous post and did the command promp "ipconfig/all" and this is what it said:

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:\Users\Ebony>ipconfig/all
Windows IP Configuration
Host Name . . . . . . . . . . . . : Ebony-PC
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : paws.uga.edu
Wireless LAN adapter Wireless Network Connection:
Connection-specific DNS Suffix . : paws.uga.edu
Description . . . . . . . . . . . : Dell Wireless 1510 Wireless-N WLAN Mini-C
ard
Physical Address. . . . . . . . . : 00-22-69-66-6E-52
DHCP Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
Link-local IPv6 Address . . . . . : fe80::... Read more

A:Solved: Connection Fails

Read other 8 answers
RELEVANCY SCORE 52.8

Is there a way to have MS Word automatically write the document pathname and filename with date to a MySQL database, a macro or something similar?

Thanks for your help.
Andynic
 

Read other answers
RELEVANCY SCORE 52.8

I have a linksys router WRT54G2 V1 and a Netgear USB adapter WG111v2 but can't connect to the internet.
I'm running Windows XP. I noticed that the autoconfiguration IP address is 169.254.43.49 and was told that XP assigns the 169 to an unknown IP address, or something like that.
Also, error message when I input the Network key it gives me an error that it's too long, only 13 characters allowed.
Last time I used this Netgear USB adapter it was connecting to a different router, Verizon's and maybe it needs to be re-configured?
Sorry, but I'm lost and need help to connect wireless.
Netgear icon shows "excellent" signal strength but can't connect, why?
My routers settings are fine and I connect my laptop running Windows 7 with no problem.
So, what am I doing wrong?
 

A:Solved: Wireless connection fails

Read other 12 answers
RELEVANCY SCORE 52

My problem is simple. I can connect to the internet directly through my modem. I cannot however connect to the internet through my wireless router and then to my modem.

This is a new problem after about a year of running the following configuration. A desktop that is wired directly to both the modem and wireless router and two other computers that had wireless adapters.

Here is my setup:
Connection: Wired
ISP: Time Warner Cable - Roadrunner high speed
Make/Model of modem: Toshiba PCX2600 - external, Intel (R) PRO1100 VE - internal
Make/Model of router: Netgear WGT624 v3
Make/Model of computer: Dell Dimension 9100
Version and patch level of windows: XP-Home SP2

Here is what came up when i did a ipconfig /all

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Matt>ipconfig /all

Windows IP Configuration

Host Name . . . . . . . . . . . . : mike
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : Intel(R) PRO/100 VE Network Connecti
on
Physical Address. . . . . . . . . : 00-12-3F-70-A6-84
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 192.168.1.2
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.... Read more

A:Solved: Router fails to establish connection

Read other 12 answers
RELEVANCY SCORE 51.6

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 51.2

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 51.2

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 51.2

Hello everyone,
I desparately need your help in this issue:

Problem:
I am running Sql server 2000 on an NT4 machine, but on Tuesday i got an error message:-

Warning State: S1T00,Native:0, Origin: [Microsoft][ODBC
SQL Server Driver] timeout error

What may cause this sort of error and how t prevent it??
The developers of this product said that a modem dial-in may have caused it. I do not believe this claim, but i needto know what caused and how to prevent re-occurances

thank you

A..
 

A:Sql Server 2g Odbc Error

check your odbc settings and event viewer.
 

Read other 3 answers
RELEVANCY SCORE 51.2

I installed Windows 7 Ultimate on a PC and I am trying to set up the ODBC drivers to use with Crystal Reports. I ran CR on my XP machine and have the ODBC settings EXACTLY the same on both PCs. When I click 'Apply & Test Connection' in the ODBC Driver Setup window, it gives me the following error message:

Unspecified System Error = -11333
Unspecified System Error = -11356.[Informix][Informix ODBC
Driver][Informix]Unspecified system Error = -931. sqlerrm(idsgtne)

I have already tried to Disable User Account Access and turned off the Windows Firewall and my Anti-virus with no luck.

Any help would be greatly appreciated.

Thanks, Rich

A:ODBC Error in Windows 7

So far out of my area of expertise that I can't even read the documents.
Have a look at this Google search: http://www.google.com/search?q=infor...ient=firefox-a
If that doesn't help, I'd check the support functions at IBM: http://www-01.ibm.com/software/data/informix/

Read other 2 answers
RELEVANCY SCORE 51.2

Hello, I have a Vista Home Premium SP2.

I have a problem with my Laptop, everytime I connect to my wireless internet (I use Belkin Wireless router) It gives me a messege "Unidentified Network" and that my computer has limited or no connectivity, that is impossible since I have 5 bars of signal. This is the first time it happened, I have been using this laptop daily to surf the web since I bought it (about 8 months ago). Could anyone help me? And also, here is the stuff from ipconfig /all

Windows IP Configuration

Host name: Compute-PC
Primary DNA Suffix:
IP routing Enabled: No
WINS Proxy Enabled: No

Ethernet adaptor Local Area Connection:

Media State: Media Disconnected
Connection-specific DNA Suffix:
Description: Marvell Yukon 88E8057 PCI-E Gigabit Ethernet Controller
Physical Address: 00-23-8B-50-7C-07
DCHP Enabled: Yes
Autoconfiguration Enabled: Yes

Wireless LAN adapter Wireless Network Connections:

Connection-specific DNS Suffix:
Description: Intel <R> WiFi Link 5100 AGN
Physical Address: 00-21-6B-07-93-F4
DHCP enabled: Yes
Autoconfiguration Enabled: Yes
Autoconfiguration IPv4 Address: 169.254.113.25(Preferred)
Subnet Mask: 255.255.0.0
Default Gateway:
NetBIOS over Tcpip: Enabled

Thank you for your time.
 

A:Solved: Internet Connection works for Desktop but fails for Laptop.

Read other 16 answers
RELEVANCY SCORE 50.4

I am getting this exact error message when I try to run any of the Office programs, IE, MS Project and probably some other programs.

"Error 1919. Error configuring ODBC data source:MS Access Database, ODBC error 6 component not found in this registry. Please verify that the MS Access database exists and that you can access it"

How do I verify and access the stupid thing? Nothing really triggered this, I just opened Project on time today, and ti all of a sudden asked me to insert the cd, and when I did, it loaded something, and then I got that error.

any ideas on what might have caused this, and how to fix it? Thanks
 

A:Error 1919 ODBC problems.

http://support.microsoft.com/default.aspx?kbid=818954&product=off2003
 

Read other 1 answers
RELEVANCY SCORE 50.4

The computer I am having an issue with is running Windows 7 32bit. It is up to date. When trying to turn queries in Excel 2010 it gets an ODBC License Unhanded Error. The same file works in Excel 2000. I will attach the screen shots of the errors. Other testing I have done is put excel 2010 on an XP computer, and it worked there. I put it on another windows 7 computer that has a fresh install, and it still doesn't work.

Not sure where to look now or what is going on with these errors searched online and couldn't find anything.

A:ODBC License Unhanded Error

When you installed the driver, did you remember to right-click and "Run As Administrator" to elevate your privileges?

Windows 7 uses the UAC (User Access Control) and user applications, including the Windows Shell, are then started with a restricted token, resulting in a reduced privilege environment even under an Administrator account. When an application requests higher privileges or "Run as administrator" is clicked, UAC will prompt for confirmation and, if consent is given, start the process using the unrestricted token.[5]

Running with restricted tokens can result in the registry not being properly updated during installation.

You might even try running Excel "As Administrator" and see if that works.

If it does, you probably need to re-install your driver.

Read other 1 answers
RELEVANCY SCORE 50.4

Hello All,

I've recently migrated servers (NT 4.0 sp6) to Win2k3 Standard, and I now have this error message on a webpage. The problem only occured after the server change. I'm not very well versed in ASP, so any help is greatly appreciated.
Thanks

Carlitosway

-ERROR MESSAGE-
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Qry'. Make sure it exists and that its name is spelled correctly.

/mmsdata/get_block.asp, line 17
-ASP Script-
<!--METADATA TYPE="typelib" FILE="c:\program files\common files\system\ado\msado15.dll"-->
<%
Option Explicit

Dim oCmd, oParam, oRst, intAreaID

set oCmd = server.createObject("ADODB.Command")
oCmd.ActiveConnection = "MMSDB"
oCmd.CommandText = "Qry-Get_Block"
oCmd.CommandType = adCmdStoredProc

intAreaID = CInt(cstr(request.querystring("areaID")))

set oParam = oCmd.CreateParameter("The_Area", adInteger, adParamInput, , intAreaID)
'name of para, type, direction, size, value
oCmd.Parameters.Append oParam
set oRst = oCmd.Execute

%>

<HTML>
<HEAD>
<SCRIPT language ="javascript">

function GetStructureName(obj) {
i = obj.selectedIndex;
var strURL = new String;
if (i>1) {
parent.structure.ShowLoading();
strURL = "" + parent.pltdata.location;
strURL.toLowerCase(); ... Read more

A:ODBC Drivers error '80040e37'

I would check your stored procedure. The only reference to Qry I see is right here: oCmd.CommandText = "Qry-Get_Block" Is that supposed to be an underscore or a dash after Qry??
 

Read other 2 answers
RELEVANCY SCORE 50.4

We recently switched from Oracle 8 databases to Oracle 11g. I have an existing Access 2002 database with a report that runs off a schema in the Oracle database.

I created a new ODBC entry to link the tables in Access to the new Oracle DB, however I am getting an OBDC failure error when I try to link them in the link table manager.

Is there anything I need to do, download new drivers for example, to get the report to properly link to the tables?

Thanks!

Drew
 

A:Access - Oracle ODBC Error

Sorry, I have no idea, have you contacted the Oracle Support team or help?
 

Read other 1 answers
RELEVANCY SCORE 50.4

When I go to certain secure websites I get an error which reads.. "Microsoft OLE DB Provider for ODBC Drivers error "80040e57"[Microsoft][ODBC SQL Server Driver][SQL server] String or binary data would be truncated. /Includ/utils.asp. line 902"
 

A:ODBC SQL Driver Error 80040e57

It's an error in the data you're trying to insert, not your code (since it's a SQL server error). Odds are that one of the fields you're trying to insert is too long for its matching database column's size (for example, sending a 35-character value to a database column that will only accept 25 characters).

Your options are: 1) increase the size of the column that's giving you trouble, or 2) somehow shorten the data to fit in the column.

80040E57 error
 

Read other 2 answers
RELEVANCY SCORE 50

When an Access97 database was converted to Access2000, and error message:
ODBC- -call failed
[INTERSOL][ODBC SQL Server driver][S #102] was recieved. The action was "Transfer Database", Transfer type: "Export", Database type: "ODBC Database"

Has anyone seen this. I found nothing in TechNet (June 2000 edition).

TIA
 

A:Access 97 convert to 2000 ODBC error

You've obviously got a macro or other code in the database that saves the file through ODBC to an external file. If you have no idea what I'm talking about, go to the Macros tab and see if you have any. Open them in design view and see if there is a file name listed in any of them.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 1 answers
RELEVANCY SCORE 50

After upgrading from a Win98 to a Win2000 PC, I am unable to refresh data on an Excel file that is on stored on a file server. I get the following error: [Microsoft][ODBC driver manager]Data Source Name not found and no default driver specified I just cancel out or there after that. Funny thing is if I log in as Administrator, I have no problems. So, its pointing to a permissions thing, but don't know enough about this area.
Thank you for your help
 

A:ODBC Drive Manager error message?

I really have no idea, but I did find a couple of articles regarding this error, which might provide pointers:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306345

http://www.microsoft.com/mind/defau...htm&nav=/mind/1198/inthisissuecolumns1198.htm

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q136481

Good luck,
 

Read other 2 answers
RELEVANCY SCORE 49.2

I have a MS Word application which uses a DSN-less connection to access a remote SQL database and which runs properly under a 32 bit OS. However, on my Windows 7 x64 systems with Office 2010 (32 bit) I get the following error when running the application:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I have done a bunch of searching, and have found a number of suggested solutions. The one which seems most likely to work is to install the Office System Driver Data Connectivity Components 2010.

Is this the best approach for solving the problem? If so, should I install the 32 or 64 bit version? If this is not the best approach, what would you suggest?

Thank you.

A:Win7 x64 / Office 2010 - ODBC connect error

i don't try yet Ms office 2010.
but i think the work is same with the other Ms.office
i'm also run the excel and connected to the dbase using ODBC.
did you already add the dbase source in it?

Read other 8 answers
RELEVANCY SCORE 49.2

I have developed a problem on notebook regarding doing a mail merge with an Excel file. It says that it cannot establish a DDE Link (or something very similiar to that) and then it defaults out of the pages. I have tried to re-install MS Office 2000 twice now, and it still has not corrected itself. Can one of you Office gurus give me a hand here on this one. This is a feature that I constantly need for work.

Thanks so much in advance...

oontheroad247

[Edited by Dreamboat on 04-06-2001 at 12:04 AM]
 

A:Office 2000: Mailmerge w/Excel gives DDE Error. ODBC anyone?

Open your file and hit the Get data button. At the bottom of that dialog box should be a "select method" button. Click on that before picking your Excel file and then pick the Excel file.

If that does not help, you may have been on the right track reinstalling. I'm sure it's something with ODBC, but I don't know anybody who knows about this stuff (I'm going to reword your topic) and by the time we find out, you might as well have reinstalled it. So, if you don't want to wait, read on...

Also, never reinstall Office without first using Eraser. It's here:

http://support.microsoft.com/support/kb/articles/Q219/4/23.ASP
 

Read other 3 answers
RELEVANCY SCORE 49.2

Is there a fix? I checked microsoft and it sounded like changing server config. which I can't do its not mine.Any help? Thanks
 

A:I get this:Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

bump
 

Read other 1 answers
RELEVANCY SCORE 49.2

Hi i need help with this error

PRIMARY and INDEX keys should not both be set for column `session_id`
Please help. Thsi was error from phpbb board running on mysql

Thanks.
 

Read other answers
RELEVANCY SCORE 49.2

Hello,
I created a database where I can put news for my site. It has 4 fields, the nid which is auto increment, the headline, the body, and teams (baseball teams) to which it pertains. This way on the team pages I can have the latest news (or highest news id, nid). I have everything good so far except when I try to pick the latest news for only that team. Here is the code I am using:
<?
$hostname = "localhost";
$username = "******";
$password = "******";
$dbName = "*******";

mysql_connect($hostname, $username, $password) or die("DB connection unavailable");
mysql_select_db( "$dbName") or die( "Unable to select database");

$sql = "SELECT * FROM news WHERE teams LIKE '%Atl%' ";
$sql .= "ORDER BY nid ASC ";

$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$variable1=$row["nid"];
$variable2=$row["stitle"];
$variable4=$row["body"];
}
?>

When I try this I get this error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY nid ASC LIMIT 0, 30' at line 1. If I run the sql statement just how it is in phpmyadmin it works good. If I take that line out I get query is empy. Help is greatly appreciated. Oh and just so you know...the variables are all used later embedded in html.
 

A:php/mysql error

Read other 9 answers
RELEVANCY SCORE 49.2

i recently installed adobe creative suite, and about a week after doing so i am now begining to get an error message saying:

-------------------------------------------------------------------------------------------------
mysqladmin.exe - Application Error

The instruction at "0x1000a73f" referenced memory at "0x00000028". The memory could not be "read".

Click OK to terminate the program

"-----------------------------------------------------------------------------------------------
if i click okay it intantly opens itself again, and i really would like to be rid of it.
i tried reinstalling adobe creative suit, teh n taking it off completley, nothing
i even restored my computer t ofactory settings, then reinstalled it, and i get teh error.
please help, and thanks in advance 'cause i know sooner or later one of you smart folks will have some sort of answer

A:Mysql Error

you can close this topic, i figured out the problem

Read other 2 answers