Over 1 million tech questions and answers.

Access & ODBC connection issue on W7 Home, State 11

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

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

RELEVANCY SCORE 200
Preferred Solution: Access & ODBC connection issue on W7 Home, State 11

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

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

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

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 71.2

When I try and link tables, using ODBC nothing happens; I know ODBC works because I can import data in Excel so the setup of source is working. I have tried re-installing MS Office 2003 and I have installed all of the service packs but I still get the same result. I think it is something wrong with my registry. Any help would be appreciated.
Thanks,
Tom
 

A:MS Access 2003-ODBC Issue

Read other 7 answers
RELEVANCY SCORE 64

Hello :
I am very new to ODBC connectivity, but i know sql fairly well:

What can generate a Native State Error: Native State S1T00: timeout expired on a SQL 2000 database; NT4 OS Server??

I am running sql database dependent applications on this server: 3 to be exact.

e.g. I have an application which transports data that was entered to the SQL database located on this Server via a LAN user. This application then dynamically takes this data and transports it to another device located on the same sub-net as the Server for data recognition and other functionalities. This is performed in milliseconds hence it may be utilizing the (winmm.dll) file to accomplish this. But the error message:

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

causes this process to fail along with other ODBC and SQL dependent applictions.

Can someone please help/ inform me what can cause this and how to prevent this??

Can a modem dial-in access cause this?? though it was running fine with modem access in the past, and no change in its configs.??

Thank you in advance

Adigga
 

A:ODBC Native State S1T00: timeout expired

ODBC connections do have a set timout I believe and ODBC connections from your connection string in the web page can also expire if the returned data doesn't get back to the browser in time. IIS also has a set timeout for scripts of 60 seconds I believe and can also cause errors. There are 3 likely places these errors are being generated from but I would suspect the connection string on your web page first and then IIS's timout for scripts....if you are using ASP and IIS
 

Read other 2 answers
RELEVANCY SCORE 64

Hello Again:
I am very new to ODBC connectivity, but i know sql fairly well:

What can generate a Native State Error: Native State S1T00: timeout expired on a SQL 2000 database; NT4 OS Server??

I am running sql database dependent applications on this server: 3 to be exact.

e.g. I have an application which transports data that was entered to the SQL database located on this Server via a LAN user. This application then dynamically takes this data and transports it to another device located on the same sub-net as the Server for data recognition and other functionalities. This is performed in milliseconds hence it may be utilizing the (winmm.dll) file to accomplish this. But the error message:

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

causes this process to fail along with other ODBC and SQL dependent applictions.

Can someone please help/ inform me what can cause this and how to prevent this??

Can a modem dial-in access cause this?? though it was running fine with modem access in the past, and no change in its configs.??

Thank you in advance

Adigga
 

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

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

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 55.6

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

Hi All

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

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

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

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

Thanks!
 

Read other answers
RELEVANCY SCORE 54.8

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?

Thanks,

Todd
 

A:Access ODBC Password

Read other 7 answers
RELEVANCY SCORE 54.8

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

ODBC Driver Manager
The ODBC resource DLL(C:\WINDOWS\SYSTEM\ODBCINT.DLL)
is a different version than the ODBC driver manager
(C:\WINDOWS\SYSTEM\ODBC32.DLL)
You need to reinstall the ODBC components to ensure proper operation

How do I reinstal the ODBC components?
 

A:Access 97 ODBC manager

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

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

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

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

.

.. hello helpful people ...
.. I am trying to install MS Access 97 on to my machine at work .. and it won't install because of an ODBC problem. There is a problem at the end of the installation .. -- The config. of the ODBC Microsoft Access Driver (*.mdb) driver failed.

.. I've tried to configure the ODBC settings myself and can't even create new ones .. it says,

-=-=-=-
-- The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to system error code 1157.
-=-=-=-

.. after clicking the above warning .. it says,

-=-=-=-
-- could not load the setup or translator library
-=-=-=-
.. I've tried so much already ... installing most recent MDAC files from Microsoft .. I've used several different copies of MS Access.

.. installed MDAC (v.2.6) ... and tried installing MS Access 97 again .. same error :

-- configuration of ODBC driver failed.

.--.--.--.--.--.--.--.

.. my settings for Microsoft Access Driver (*.mdb) seem to be correct (files that are stated are in correct location).

.. but I have another folder in ODBCINST.INI .. and it is the only one that has files in a different location.

-- Client Access ODBC Driver (32-bit):

DRIVER = "C:\sqllib\bin\db2cli.dll"
SETUP = "C:\sqllib\bin\db2odbc.dll"

* neither of these files exist on my machine .. neither do the folders for that matter ... thinking I should create such files and folders .. or change the path of.

(feelin... Read more

A:.. MS Access 97 .. ODBC inst. probs.

A search for that error message came up with a few answers on on Google, though (predictably) zero on MS. At least you can know that you are not alone.

You might go and make sure you have the "right" version of MDAC. (There are many to choose from, god bless 'em.)

Several of the other sites mention using 2.5SP1 to resolve the problem, for what it's worth. I'd just keep trying MDAC versions until something clicks.

Or wait for someone who's seen this baby before to come around.
 

Read other 1 answers
RELEVANCY SCORE 54.4

Operating System - Windows XP Professional Version 2002 Service Pack 2
Office version - Office Professional Edition 2003
I am trying to link an Access application to a SQL Server table via ODBC link. However, when selecting "ODBC" under Files of Type on the Link dialog, the Link dialog box closes and nothing happens.

SQL Server is installed on my computer as are the database tables that I am trying to connect to.

To see if it was an issue, I set the macro security level to low, but still no luck.

Is there anything else that needs to be adjusted to enable the ODBC link?
 

A:MS Access 2003 - Cannot Link To ODBC

Here is the resolution along with the disclaimer.

http://support.microsoft.com/kb/329820/en-us
 

Read other 2 answers
RELEVANCY SCORE 54.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.

Any help would be appreciated.
 

A:ODBC Access 2003 two problems

I have never worked with ODBC but can I offer the suggestion that as you can do some things on some computers but not on others that you compare the Access settings on the 2 computers to see if there are any differences.
In particular the VB Editor>References to libraries settings.
Maybe also the Add-ins manager as well.
 

Read other 3 answers
RELEVANCY SCORE 54.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 54.4

Ok, here's the breakdown: Computer OS is NT4 SP6a, Office 97 full install, MDAC 6.1 SP1, and I have checked the components w/ ComCheck to see if they were Ok and they were. The problem is: Whenever trying to access part of the the database it comes up with 'ODBC--call failed' and then does not proceed any further w/ the database. I have reinstalled Acces, installed the newest MDAC (which is 6.1 SP1) and re-applied the service pack. No application errors in the event log even pertain to the error. See if you can crack this one. Thanks.

Joe Dyer
 

A:Access 97 + ODBC call failed

Read other 6 answers
RELEVANCY SCORE 54.4

I have an application that uses a MS Access database. In Vista it I cannot open multiple ODBC connections to the database. No error is given. As soon as I close the first application the second one opens. What do I tweak in Vista to allow multiple connections to the database?

Read other answers
RELEVANCY SCORE 54

Hi, It sounds like the same problem I am having. I did all the things they told you to do. Still not working, have you found out anything else it could be???

Help if you can!!Thanks

Justme16
 

A:Connection issue with XP-Home

Even though it appears you're having the same problem, please start a new thread when you have a new issue. It's very difficult to keep two problems straight and who's working on what in a single thread.

I've created a new thread for your issue here.

Note: You will need to post complete details of your configuration and your specific issue in this new thread for us to help you.

Thanks for your cooperation.
 

Read other 1 answers
RELEVANCY SCORE 54

Create a batch script for Oracle ODBC connection
 

Read other answers
RELEVANCY SCORE 53.6

I am working with MS Access 2003 and am trying to import or link odbc data. I am running XP sp2, have the latest updates on office 2003, have Jet 4.0 sp8. I have updated ODBC drivers and have several DSNs set up - both in system and user.

When I try to import external data - I change the file type to ODBC and the dialog box disappears.

Anyone have any ideas - Dell has never seen this before
_________________
New Info - the query can access ODBC databases - it seems that only the select data source wizard is having a problem
 

A:MS Access ODBC Data Source problem

Read other 16 answers
RELEVANCY SCORE 53.6

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 53.6

Where can I find the 32-Bit drivers for Access so I can connect to MyODBC?

Read other answers
RELEVANCY SCORE 53.6

I'm visiting my daughter who has a home network with multiple computers all using wireless connection. While here, I connect to it and enjoy the high speed connection (I'm on dial-up at my home ).

Here is my question... When I enable the wireless connection on my Dell Inspiron 1501 laptop, the connection works just fine, but the status stays at "Acquiring network address" (see screen shot 1). Just fooling around, I found if I enable the LAN connection, the wireless connection immediately switches to "Connected" (see screen shot 2). I can then disable the LAN connection and the wireless connection stays connected. The Gateway (Router) status is "Connected" in either case.

If anyone has any advice or insight regarding how to get the wireless to complete the acquisition process without activating the LAN connection, I'd like to know it.

BTW... Wireless connection is via Dell WLAN card. Router is a Belkin 802.11. Signal strength is 4 bars (high).

Raybro
 

A:Home Network Connection Issue

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

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

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

Read other 9 answers
RELEVANCY SCORE 52.8

I leave my computer on all day. I use my computer just before work and dinner to sleep. All the program works fine. Everything works normal.

When I get home from work or wake up in the morning, I get the following error.
"Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item."

I can not log off. I can't access any file on Desktop, Start or icon. I can not access task manager I have to cold boot my computer. Everything back to normal. The problem just started 2 days ago. I only installed Windows Media Player 11 and Quicktime in last two days! What causing this suddenly? Something has changed or happen during inactivity while I was away from keyboard.

I use Windows XP SP2. I have HP a1642x 6300 CPU. I have Zone Alarm Internet Suite 6.5.

I ran following programs last night. AVG 7.5, ZoneAlarm Antivirus/AntiSpyware, Spybot, and Spyware Doctor, nothing unique or unusual.

Here is my Hijaak Log:
Logfile of HijackThis v1.99.1
Scan saved at 7:15:08 PM, on 1/24/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.5730.0011)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\csrss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\syst... Read more

Read other answers
RELEVANCY SCORE 52

Hi Guys,
Really starting to get frustrated with this issue. Own a dell with Vista home edition, wireless dlink network adapter card installed. Last year after i moved in to my new apartment complex, tried connecting to the network and intitially, wireless signal was weak, so i tried ethernet/cat5 connection and it would not allow me to get on (Local Access only). My computer was communicating with the router, but i could not get internet access beyond that. Then several weeks later, i disabled my wireless adapter, and magically my ethernet connection appeared and was uninterrupted for over 6months. But last weekend, my landlord switched routers from his old d-link to a new cisco router, and again i've had issues with local access only connection but this time its affecting my wireless connection as well. My wireless is intermittent, it will connect upon startup for about 10minutes to 2 hours of internet connection with a weak signal, then timeout, and automically try to connect to a nearby hotspot unsecured network, which i dont want it to do. I have to disable and re-enable the wireless network connection to get another hour or so of intermittent internet service, but my cat5 connection still will not work, it identifies the network, but it wont actually connect to the internet and still says Local access only. I've tried installing all my recent service pack updates, disabling all non-essential startup service, resetting routers, cleaning up registry. Could it be ... Read more

A:Vista Home Local Access ethernet connection

It's impossible to sort through that amorphous blob of text, a little formatting would be very useful. With what I see, the information we'll really need isn't there anyway.

Please supply the following info, exact make and models of the equipment please.

Name of your ISP (Internet Service Provider).
Make and exact model of the broadband modem.
Make and exact model and hardware version of the router (if a separate unit).
Make and exact model and hardware version of any other network equipment, like a repeater, a booster, hi-gain antenna, etc.
Model numbers can usually be obtained from the label on the device.
Connection type, wired or wireless.
If wireless, encryption used, (none, WEP, WPA, or WPA2)
Version and patch level of Windows on all affected machines, i.e. XP (Home or Pro), SP1-SP2-SP3, Vista (Home, Business, Ultimate), etc.
The Internet Browser in use, IE, Firefox, Opera, etc.


Please give an exact description of your problem symptoms, including the exact text of any error messages.


If you're using a wireless connection, have you tried a direct connection with a cable to see if that changes the symptoms?
For wireless issues, have you disabled all encryption on the router to see if you can connect that way?
Have you connected directly to the broadband modem to see if this is a router or modem/ISP issue?
If there are other computers on the same network, are they experiencing the same issue, or do they function normally?


On any affect... Read more

Read other 1 answers
RELEVANCY SCORE 52

I have Win7 and Office 2010 both 64 bit. I also have a 32 bit application running where I need a 32 bit *.accdb
 (MS Access) ODBC driver. Using the 64-bit version of the Odbcad32.exe is returning “The specified DSN contains an architecture mismatch between the Driver and Application”. So I need a
32 bit ODBC *.accdb driver for my application.
My problem:
When I open c:\windows\SysWOW64\odbcsys32.exe and try to ADD a new dsn there is only a *.mdb driver available for MS Access. Does anyone know how to
add a 32 bit MS Access *.accdb driver to c:\windows\SysWOW64\odbcsys32.exe? Maybe I missed something obvious but this is giving me headache after browsing through the Internet for a solution. 

 
Thanks
 

A:32 bit ODBC driver for MS Access 2010 (*.accdb) is missing in Win7 64bit

Carl, I just figured out a solution... If you are running a 64-bit Computer and Running Access 2010, you will first need to download the AccessDatabaseEngine.exe from Microsoft.
http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

After the download finishes, and installs, You will need to create an ODBC connection. Instead of creating an ODBC connection through your Administrative Tools, Data Sources (ODBC) interface, you will need to run the 64-bit instance of Data Sources (ODBC).
To do this, you will need to click your "Windows" + "R" buttons on the keyboard, and then paste "c:\windows\sysWOW64\odbcad32.exe" -- without quotes into the dialog. Then create the connection to the database as you would on a 32 bit machine.
 
I had the same issues with the *.accdb not showing up in my 64 bit ODBC connections. It then showed up after performing the above steps.
 
Hope this Helps,
 
Alex Mahrou

Read other 12 answers
RELEVANCY SCORE 51.2

Reloaded xp on dell Latitude d610 - reloaded all drivers. Network connection states excellent connection however browsers state no connectivity.
 

A:Network connection states excellent connection but browsers state no connectivity

Read other 16 answers
RELEVANCY SCORE 50.8

I seem to be having a couple issues regarding Outlook.

First, when I get to the home page to log in I get a message that says "There has been an error removing certificates from this workstation. Error (0X80070005): Access is denied.

Once I've logged in, I try to reply to my email and Explorer shuts down, then restarts.

Any suggestions?
 

A:Vista Home Premium & Outlook Web Access 2003 Issue

How are you trying to access Outlook from IE?
 

Read other 3 answers
RELEVANCY SCORE 50

Hi, i have one bothersome problem with Windows 7 and also Vista

ok, i have 2 laptops one running Windows 7 64-bit and the other Vista 64-bit, for some reason out of the blue both machines stopped getting access to the net and i have this ongoing message saying "Limited Access, No Connection" and/or "Unidentified Network" with the wireless connections.
the strainge thing is, both laptop sees my router but it would not connect...NOW, i have 2 other laptops my old Compaq Presario V5000 and a Dell Insparion D600 both Running Windows XP Pro and they connect to the router and my mom's Dell Mini (running Windows 7 32-bit) that too connects to the router.

i've tried every method possible even googled solutions to find a way to fix the problem but to no avail since i have yet to a straight answer to fix it.

BTW: i dont know if it has to do with teh fact that the 2 laptops are running a 64-bit operating system and theres some incompatibility somewhere...i mean im bout on the verge of giving up on fixing this and just wipe em both out and do a full re-installation as a last resort.

any pointers of how to "properly" fix this network issue?
 

A:Unidentified Network/Limited Access or No Connection issue with Windows 7

Hi Shadow,
I had a very similar issue when reinstalling xp pro onto a oldish laptop, again as with you my laptop could see my router but not connect, (a yellow triangle icon)

This is what I had to do perhaps/ I hope, it will work for you.

First I found a bit of free software that does not install but when run will give you all the info you need to know about your laptop, sorry was a while ago just google there is more than one.

This will let you know the exact wireless card you have in your system, then and it took me a bit of time to google and find the right one, download the latest driver for the wireless card.

Now I could connect by plugging a cable in and downloaded the update directly to the laptop in mention, however after running it it still did not work, so for some strange reason I re-downloaded it from another computer, copied it onto a pen drive and ran it from there and it worked.

Finding the correct driver can be a little tireless wading through the oh download and pay for my brilliant driver updater software, but somewhere in the middle of all that crap will be a genuine driver you need.

another option is go direct to the laptop manufacturers website and check if they have the driver's.

Worth a try.
 

Read other 1 answers
RELEVANCY SCORE 48

We are getting this message when accessing a search page on our SQL server. Any ideas anyone?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

/faxmachine_search2.asp, line 5

cheers,
Dan
 

Read other answers
RELEVANCY SCORE 46.4

The YOGA Home 900 uses  the G-Sensor to detect what state its in - standing or flat. My question is, is the G-Sensor exposed via the UWP Inclinometer sensor API? Thanks.

A:YOGA Home 900 Inclinometer (state sensor)

This would be a better question for the provider of the driver (STMicroelectronics).  The version of the driver looks to me like one that only runs under windows 10 (st_accel.sys v. 2.2.2.21).  I would guess that they would use the new API because it is much easier to code, but it is just a guess

Read other 1 answers
RELEVANCY SCORE 46.4

We had to create a new profile in Steady State after a power blip but we cannot fix the Home Page to default to our Website. THanks

A:IE Home Page in Steady State Profile

Hello and welcome to TSF

Please read this:

http://www.techsupportforum.com/f104...ng-215851.html

Read other 1 answers
RELEVANCY SCORE 46

I will try to explain this in a clear way:

I am a current student who has a Desktop and a Laptop. My Desktop was a fully functioning 7 Home Prem install using an upgrade from Windows XP. Windows xp was already on this used Desktop (custom build) with no CD Key or Media available to me. Windows 7 upgrade was valid and paid for by me.

I recently began school again and setup my Mac Laptop with Bootcamp, did a Fresh install with the original Win 7 academic HP. Yes, this is a upgrade only version.

I purchased Windows Professional and applied the FULL product key to Windows Anytime Upgrade to my DESKTOP. This upgraded the 7 Home Premium to Pro and took over the "Upgrade Home Prem spot" and freed up my license.

I hadn't used my Laptop in a while (With the fresh HPrem install on it) and it expired. When I went to use my Laptop, it had expired. Foolishly, I tried to use my friends full key because I didn't know how to get the fresh install fixed on the Laptop and I thought "Well, I did pay for this product, lets jut get it working" After I updated the key to a new key, it will not let me change the 7 key BACK to the original paid for Home Premium.

Let me be clear here. All of my products are paid for, I just want to get the Home Premium key back on my Laptop so I can call Microsoft and explain the situation and maybe they will allow me to activate Win7.

Here are 2 scenarios I can think of:
---1. UNupgrade my Desktop with a System Restore back down to Home Pr... Read more

Read other answers
RELEVANCY SCORE 45.6

I am running Windows XP and outlook 2002. I work in Outlook both on line and off line. My problem is when I want to change states I can not get outlook to ask the manual connection question without restarting the computer. I have followed the Microsoft instructions under the more settings/General options for my exchange account and selected Manually control connection state/Choose the connection type when starting and I have tried both default connection states. I would like to be able to go from offline to online and sometimes back again just by closing outlook, but usually I have to shut down the computer to get the manual connection prompt. If I don't shut down my computer it just opens up Outlook in the same connection state as when I exited Outlook previously. I have suffered with this problem on previous versions of windows and outlook with IBM and Dell computers.
 

Read other answers
RELEVANCY SCORE 45.6

We're implementing 802.1x authentication for wired connections in our Windows 7 environment, and we are trying to find a way to determine programatically if the computer has successfully authenticated. Unfortunately, the only ways that we can find to check
on the computer is in the GUI, or using NETSH.
PS C:\> netsh lan show interfacesThere is 1 interface on the system:    Name             : Local Area Connection    Description      : Intel(R) 82566DM Gigabit Network Connection    GUID             : 5ec1ab9b-b8ae-4ce0-9c4a-ff3e9c842958    Physical Address : 00-90-FB-1A-90-C2    State            : Connected. Authentication failed.
Alternative messages are:
Connected
Connected. Authentication succeeded.
Connected. Authentication not supported.
I would just parse the output, but some systems have multiple adapters, VPN adapters that show up, and different languages of Windows.  In theory, you can WMI query the win32_networkadapter class for the NetConnectionStatus, which does have those states.
 Unfortunately those states only seem to work on Wireless connections, not the wired connections I'm looking at.
Get-WmiObject -Class win32_networkadapter | Select-Object NetConnectionID,Name,NetConnectionStatus
I can query the event logs of the Wired AutoConfig service, but then I'd have to know every possible ... Read more

Read other answers