Over 1 million tech questions and answers.

Cant create ODBC connection data resources

Q: Cant create ODBC connection data resources

" 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

RELEVANCY SCORE 200
Preferred Solution: Cant create ODBC connection data resources

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

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

Read other answers
RELEVANCY SCORE 78.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 77.6

Create a batch script for Oracle ODBC connection
 

Read other answers
RELEVANCY SCORE 61.2

Hi all,
I have a strange problem that occur on lots of our machine,
We deploy a fresh Windows 7 32Bit OS from SCCM.
I created a script that adds a "Microsoft ODBC for Oracle" DSN on all of our workstation (part of the task sequence).
I tested the script and its work great, but...
Some users have problem that the DSN is not showing on the "ODBC Data Source Administrator"

Now, when I try to manually add the DSN, the moment I select "Microsoft ODBC for Oracle" i get the following error -

I'm googling the web for few days now and cant find a solution...
Please help...

A:Microsoft ODBC for Oracle - Fail to create

Correct, I based my opinion on the error about the components apparently missing. Here is a Knowledge base article about troubleshooting this very issue:
How To Troubleshoot an ASP-to-Oracle Connectivity Problem
There is a similar thread on the Oracle forums which contains some solutions you can attempt to fix your problem:
Thread: Oracle client and networking components were not found


Do those steps resolve your issue?

Read other 10 answers
RELEVANCY SCORE 58.4

I have a new HP 6200 small form factor that came pre-installed with Windows 7 64bit. I installed our corporate copy of MS Office Pro 2003 and then installed UPS Worldship 2011, which requires an ODBC to connect to our Access database.

When I go into the ODBC to set up the connection under System DSN, it's completely blank. No Access DSN, no Excel DSN, completely blank. If I try to ADD a DSN the only options shown are SQL DSNs which I can not use.

Initially, I called UPS Worldship Support. They referred me to Microsoft. After nearly 2 hrs on the phone with MS, they told me to call HP since HP preinstalled the Windows 7 and they handle any software/warranty issues.

So, I called HP. Their support is the pits. Nobody I talked with even knew what a DSN is (they kept telling me it was DNS not DSN and they are 2 different things!!). Then, they suggested I call Microsoft and PAY to have them help me.

This is a brand new PC and it's a Windows 7 issue, not Worldship, not hardware, yet I can get any help.

I've tried some of the options on the various forum (running the 32 bit.exe, copying files, etc) and nothing has worked.

Anyone have any ideas HOW I can get the Access and Excel DSNs in the ODBC Manager? I need help asap as this is a critical PC to our shipping area. Without it, we are unable to ship via UPS and losing $$$.

Thanks for any suggestions because I'm fed up with Microsoft AND HP!!!

A:No DSN in ODBC Data Source Admin

Hello tandrews, welcome to the forum.

First, let me say that the subject of your query is not actually in my knowledge base, However, in an effort to assist I did a search and thought I would offer the following:
ODBC: frequently asked questions

here:
Step-by-step guide on how to set up DSN in ODBC Data Source Administrator on Windows.

and here:
MySQL :: MySQL 5.0 Reference Manual :: 19.1.4.3 Configuring a Connector/ODBC DSN on Windows
Hopefully something in there might help.

Read other 2 answers
RELEVANCY SCORE 58

In trying to use BRIO to access LOtus Approach on my machine, I'm told to "You need to define the .dbf file as a ODBC data source in windows." How do you define a file as such ??
 

A:Defining .dbf file as an ODBC data source

Click on Start>Settings>ControlPanel>ODBC Data Sources
 

Read other 1 answers
RELEVANCY SCORE 58

I need to create a system DSN that links a program to a database (to keep it simple). I've already done this, however I have moved the database location to another computer. It is imperative that I recreate the system DSN with the exact same database name as before. The problem is: even though I've removed the previous dsn, when I go to create the new one it denies me by saying this database name has already been used. Sure enough the database name still exists in the drop-down list of database names in the create databse dialog box. I've checked the ODBC.ini files and manually removed any references to the database name I want to re-use to no avail. How can I re-use (or clear) a previously used database name?
 

A:ODBC SYstem Data Source cleanup

Read other 7 answers
RELEVANCY SCORE 58

In trying to use BRIO to access LOtus Approach on my machine, I'm told to "You need to define the .dbf file as a ODBC data source in windows." How do you define a file as such ??
 

A:Defining .dbf file as ODBC data source

Please don't post duplicates in multiple forums. I moved the one from the Windows forum to the Business Apps forum. You can find it here.

http://forums.techguy.org/showthread.php?s=&threadid=51606
 

Read other 1 answers
RELEVANCY SCORE 58

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 56.4

I am using Outlook 2003 with VISTA Home Premium 64 bit O/S

'Error 1919 configuring ODBC Data Source
Component not found in registry.'

I research this error online and found instructions from Microsoft support
to help correct this problem
One of the instructions was to export two .reg files from another computer
on my network where the software was working and then import them to the
computer that needed to be fixed.
I did this, but it was not successful because on one of the ODBC files I
exported, I received the following error message when I attempted to import
it:

cannot import ODBC2.reg . not all data was successfully written to the
registry. Some keys are open by the system or other processes.
The folder I exported this from in the registry was
HKEY_LOCAL_MACHINE/SOFTWARE/ODBC

I attempted to do this in Safe Mode and was not successful with importing
from there as well. I received the same error message

ANY OTHER RECOMMENDATIONS WOULD CERTAINLY BE APPRECIATED.

Thank you in advance for your support and suggestions,

HankL
 

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 55.6

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 55.6

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

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

Regards Hakit

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

A:ODBC connection problem

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

Read other 3 answers
RELEVANCY SCORE 55.2

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

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

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

thanks anyway

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

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

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

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

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

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

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

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

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

Read other 4 answers
RELEVANCY SCORE 53.2

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 52.8

Hiya

The Microsoft Data Analyzer design and create data cubes article sample files provides sample source data for creating data cubes from text files. Use this file in conjunction with the article Design and Create Data Cubes from Text Files.

http://office.microsoft.com/assistance/2002/articles/daCubePrinciples.aspx

http://office.microsoft.com/downloa...seID=43350&area=search&ordinal=12&redirect=no

Regards

eddie
 

Read other answers
RELEVANCY SCORE 48.4

Hi

Please Fellas I need a help........I appriciate any help. Thank you
When I attending to share folder on my desktop computer ( win xp pro sp2 ) I got following Sharing Error Message.
> In Shared Documents Properties
>> Sharing
- Network Sharing and security
I select " Share this folder on the network "
Click apply & I get following Error message :

" An error occured while trying to share Documents. The data is invalid.
The shared resource was not created at this time. "

.................................................................................................

Please if you know anything about this problem let me know. Thank you
Igi
 

A:Sharing doc error in winxp-sp2: The data is invalid.The shared resources wasn't creat

Read other 6 answers
RELEVANCY SCORE 48

Problem started total security/AV 2009/other malware installed on some of our client computers. Was able to remove the porblems, but then the computers had a bad network connection and could not repair or renew IP address. Fixed this by resetting winsock/tcp stack/dns settings. Machines get an IP address and can see the internet, but still not our network resources. Cannot re-add them to the domain or hit network. BUT! If I disable/unistall the NIC this all works fine until the computer is restarted. Have tested different cards in them and total removed the card and oem driver files, but still quits working after first reboot. Any advice/help???

Read other answers
RELEVANCY SCORE 47.6

I Have Recently Updated Xp With First Sp2 And Then Sp3. Now I Cannot Create A Dialup Connection.
When I Go To Wizard For New Conenction Only Broadband Option Is Selectable And The Other 2 Are Greyed Out.
The Modem Is Working Fine.
I Doubt This May Be Because Of Service Packs I Have Installed.
The Remote Access Connection Manager Service Couldn't Be Started ( Error 126 : The Specified Module Could Not Be Found )
Other Depending Services Like Telephony Are Running.
I Have Tried Deleting The 25,26 Registry Keys.
Also Deleted The Telephony Registry Key And Restarted But Still No Use.
I Have Also Tried After Uninstalling Sp3 But The Same Problem.
I Am Currently Using Broadband Connection.
But I Need Dialup Connection Too.

Help Needed Desperately.

Read other answers
RELEVANCY SCORE 47.2

Hi,

I don't have a networking background but I am responsible for coming up with a solution so any help is much appreciated. I have a main office that is networked and another local office that is networked and also connects to the main office which has the DNS server. Now what happened was cables were cut caused by construction near the local office and the network and wifi was down at the local office but not at the main office which was not affected by this issue because it's at a different location but the the local office network printers and our connection to the network data servers which are located at our local office were down and they are not located at the main office. My problem is this since the cable was cut and needed to be repaired so the internet and wifi was down and the local office could not connect to the main office because of this but how or what can I do to make the local network printers and local network shares work if this happens again? Did the local network printers and local network drive not work even though they are located at the local office because the DNS is at the main office and if I would setup another DNS cache at the local office would this fix the problem and how would I being to do this?

Thank you,
Bill
 

Read other answers
RELEVANCY SCORE 46.8

I've Googled for this but cannot find anything relevant. First off, all computers on the current router are running Windows 7 Pro and this is not a domain network. I want to do all this configuration within the routers if possible.

This network currently consists of several computers on one router we'll call SSID1. We want to add another public/guest router we'll call SSID2 that will handle public access to the internet. SSID2 needs to be totally unaware of and firewalled from resources on SSID1.

Can someone point me to some Internet resources that deal with this subject and/or tell me what terms to Google.
 

A:Need to do this on same Internet Connection: SSID1 resources unaware of SSID2

Hi Alex Ethridge,

The easiest way to do this is to use a wireless router which broadcasts 2 signals -- one for guests and one for the main home network.

See this link.
 

Read other 1 answers
RELEVANCY SCORE 46.4

I have had this problem for years (4 years to be exact). So how do I fix that:Basically it says:"State of the connectionLimited or no connectivityYou might not be able to access the Internet or some network resources.This problem happens because the network did not attribute an address to the computer."

A:This connection has limited or no connectivity. You might not be able to access the Internet or some network resources.

Can you still access internet?
It appears that your ISP is not running a DHCP server. DHCP allows you to request an IP address and DNS server addresses automatically. So, you may have to manually set the IP address and DNS server addresses.

Read other 7 answers
RELEVANCY SCORE 45.6

Hi, i keep getting this error while trying to make a data cd... im using windows xp, a dvd burner, and a double layer dvd+r. Ive been able to make a data cd in the past, but ive recently reformated my computer and havent been able to since. Heres the error im getting with one of the files im trying to put on there, the error shows up with the rest of the files also. Oh and the files are some jpeg's and more of the one in the error below.

"Windows has encountered a problem when trying to copy this file. What do you want to do?

Saikano 01
Type: Zoom Player Playlist
Title: [V-A] Saikano - 01 - We Fall In Love
Duration: 0:24:18
Dimensions: 794 x 396
XVID, Vorbis, SSA, SRT/UFT-8
Size: 172MB

Retry Skip Cancel"

any help at all with fixing this is very much appreciated, thanks!
 

A:Error while trying to create a data cd

Read other 8 answers
RELEVANCY SCORE 45.6

Please help.
Ive bought A lenovo g580(?) with 7 pre installed. There is four partitions preinstalled on the hdd. I've understod that You can not delete any of these, in order to keep the recovery system working.
Four partitions is the Max number of such.

Is it possible to Get an extra data partition?
If not, should i store my user data on c? What if win7 crashes,then i Will loose everything on c.

On my old pc, i had A dedicated d-partition for data. This is not possible on my new pc. Or is it?

Lee

A:Not able to create data partition

Yes, it is possible to add a data partition.

BUT, you cannot exceed 4 primary partitions. I assume you already have 4 primary partitions.

The best choice is probably to convert your current C partition to logical. You could then shrink C and make a data partition from the space generated by shrinking.

DO NOT DO NOT DO NOT say yes to any choice involving dynamic partitions. If you attempt to make a data partition right now, without first converting to logical, you will likely be asked to accept dynamic partitions. SAY NO. Better yet, don't try to make more partitions right now.

Best thing you can do right now:

Post a screen shot of Windows Disk Management so we can see your current partition structure.

Read other 1 answers
RELEVANCY SCORE 45.6

Hello,

I have a lovely report that shows the sum of four tables of forestry information based on a parcelID. These are not subreports.

My control source for each is something like SumOfTheseTypeOfTrees, SumOfThoseTypeOfTrees, SumOfMyTypeOfTrees, SumOfYourTypeOfTrees. Great fine.

However, some parcels don't have records for (example) TheseTypeOfTrees so the report is just blank in that spot. This would be no big deal except that I want to use the report to get a grand total for each parcel. If any of those control boxes is blank, the grand total sum is also blank. I don't want to have to go around adding a zero to all my tables for every parcel that doesn't have (example) TheseTypesOfTrees but I need a grand total to show up. Can I get around this?

Thanks.
 

A:Solved: Create a SUM when there is no data

Read other 14 answers
RELEVANCY SCORE 45.2

Purchased a website and email domain. I have a fresh install of MS office 2010 and when trying to incorporate my pop3 mail everything works fine, even the test emails, but I can not save profile because i get an error, "This information service is not installed on your computer", so it wont let me create a new data file. when I search for an existing .pst none are found on hard drive. so I'm kinda stuck. I tried the same basic thing via control panel > mail > data file tab > add data file, but i get the same error. "This information service is not installed on your computer." I took a look at my add/remove windows features pane to see if maybe on windows install I missed some email protocols or something but I could not find any. did the same for the office 2010 install, checked to see if I did not install a key feature. still nothing.

**Edit: Tried using IMAP as well since this does not require .pst access but still same error. "This information service is not installed on your computer."

A:Can't create Outlook New Data File (.pst)

Something to try:
Inbox Repair Tool (scanpst.exe) | MSOutlook.info

Read other 5 answers
RELEVANCY SCORE 45.2

Please disregard... I figured out that I was just being a bone head...
 

Read other answers
RELEVANCY SCORE 45.2

I successfully installed Win 7 Home Premium x64 to UEFI/GPT disk (3TB).
Now I need to create a couple of data partitions ON THE SAME disk drive.

Questions :
Do those data partitions need to be also GPT partitions (on the disk with GPT) ?
Or is there a choice : GPT or MBR ?

.................................................................................................... ....

After Win 7 install (UEFI) on disk "0" - I wanted reconnect also my (older) HDD with old Win 7 installation (legacy BIOS). But this resulted in boot error of freshly installed (UEFI) Win 7.

My questions :
1. Is it possible to use 2 HDDs : one with GPT and the second with MBR (and the second operating system in dual boot) in the same computer?
2. How should I connect the second drive properly (with 2 MBR drives it wasn't a problem) ?

A:need to create a couple of data partitions

1. Yes. I have a GPT data HDD (4TB), two MBR data HDDs (2 TB each), and a MBR SSD boot drive in my desktop computer.
2. I connected my GPT HDD the same way I connected my others.

I don't know if you can mix GPT partitions with MBR partitions on a drive or not but I would play it safe and make them the same. However, that leads to a question I want to ask. Why do you want to make two data partitions on the same drive?

Read other 1 answers
RELEVANCY SCORE 44.8

I've noticed that the "Local units and resources" in Remote Desktop Connection is missing an OK button. It seems to be a localization issue because I changed my Windows profile language to English, logged out and back in again, started RDC and
the Ok and Cancel button became visible. Changed my language back to Norwegian again and the buttons are gone again.
I have also confirmed this by testing the same on a clean new installation.
Temporary Work-around: Select an option, press tab-key once (it will select the OK button which you cannot see), then press Enter.

A:Bug report: Under Remote Desktop Connection, local units and resources menu has OK button missing

Hi,
Based on my test,I got the same result.

Thanks for your feedback.
We will submit this issue to Microsoft product team.
Regards,Kelvin Xu
TechNet Community Support

Read other 3 answers
RELEVANCY SCORE 44.8

Hi all,
I have a 500 GB hard disk which is by default frmatted in FAT32 file system. It is now around 400 GB filled up. I have some files which are more than 4GB size which are not supported in FAT32 file system. Hence I need to create a new drive with NTFS file system. But I don't want to loose the 400GB filled up data. Any solution?
Thanks in advance
-pkd
 

A:How to create a new from an existing partition without loosing data

I don't know in Disk Management in XP there is an option to shrink the drive.....Disk Director by Acronis could do it.
 

Read other 3 answers
RELEVANCY SCORE 44.8

Apart from Nero 7, which software would you lads recommend that could burn data on CD's, DVD's and re-writables and create DVD movies?
 

A:Burn data and create movies, which software?

Read other 6 answers
RELEVANCY SCORE 44.8

Dear all,

Existing now, i have 2 server running w/d server 2003.
Svr01 is for Active Directly another is solomon system, but now, i dun hv any backup devices to backup our data.
Can anyone teach me how to backup those data!?
Actually i still thinking to setup another w/d server 2003 as a mirro for AD, then also can as a backup server.So, i would to create a bath file to running the scedule task copy those data into the new server.

Izzit work?
Anybody can give me some suggestion....

Thanks in advance....
 

A:how to create a bath file for bakup data

Can somebody help me?
 

Read other 2 answers
RELEVANCY SCORE 44.8

I have a data file partition on my hard drive and am cannot create a shortcut from the My Documents folder on the data partition to my desktop
When I right click the folder it does not show a send to desktop option in the menu that appears

How can I solve this problem? Thanks!

A:unable to create shortcut to data file

Hi there,

Have you tried going to the folder you want to shortcut and dragging it to the desktop it normally create's one that way.

Hope this helps.

Read other 2 answers
RELEVANCY SCORE 44.8

How do I create a password so you would need a password to clear private data in firefox?

A:How do create a password for clear private data

Hi, welcome to TSF

The 'clear private data' feature is not password protected. You might be able to do it through the about:config settings or there might be an addon available, but I can't find anything.

Is your Firefox profile password-protected, and have you set a master password in Tools > Options > Security tab? If other people are using the computer, do they all have their own Firefox profiles?

You could install the Menu Editor addon which allows you to remove menu entries. This would remove 'Clear Private Data' from the Tools menu, but would not disable the keyboard shortcut, Ctrl-Shift-Del.

Read other 6 answers
RELEVANCY SCORE 44.8

In the past, it seemed sensible to create a separate F: partition to hold my data away from the operating system on the C: partition. The advantage was that malware is less likely to cross into the data partition. Also it becomes possible to backup and restore each partition separately. A good solution to a malware incident might be simply to restore a previous version of the operating system without touching the data partition.
 
I have redirected the following folders to the F: drive: desktop, documents, downloads, music, pictures, videos.
 
This has worked reasonably well except that some software installer programs refuse to work from the F: partition and need to be run from the C: partition.
 
Times have changed over the last few years and I am wondering if this is still worth the trouble. Perhaps it would be easier to keep successive backups of the entire hard drive and, when necessary, restore everything at one time.
 
I would welcome any thoughts on this.

A:Create a separate F: partition to hold my data

I still use 3 partitions: One for Windows and programs, one for data files, one for my tools.Personally, I think the choice is up to you though - how you want to arrange your files and so on.

Read other 3 answers
RELEVANCY SCORE 44.8

Hello,

I wonder how I can create a plot of a data range that will vary depending on the project length.

I have a data range displaying a monthly result of a contract. The contract could range from 3 years to 20 years. Currently I have just plotted the range I need, but how can I make Excel to select the entire range (20 years x 12) but just plot the acutal range (3 years x 12). Currently I will get a loooong diagram with only data in the left corner displaying values fort the first years but zero for the rest of the 17 years x12. Any tips how to solve this?

Cheers
P
 

A:Create a plot of a data range that will vary

Read other 9 answers
RELEVANCY SCORE 44.8

I have a Thinkpad L420 and went to try create a recovery USB from the Q drive before migrating to from HDD to SSD.  It seemed to accept the prompts to create a recovery USB for boot and data sections and then I got a Lenovo error message that it had trouble reading Q drive and that data was missing. Had to cancel.  I was eventually able to load a boot section but only if I unchecked the data section.  So the Q drive is corrupted.  Is there any way to recover a proper recovery partition for this laptop?

Read other answers
RELEVANCY SCORE 44.8

Hi,
I have a major problem crunching large amounts of numbers coming off an instrument I work with but the file format it puts the results into is terrible and I cannot change it. So I must export the results in a format which needs some serious formating before it becomes of any use to me.

I have used excel macros to delete rows and rows with specific text values. But now I would like to create a macro that will reorganise this data in a more user friendly format. I did use the sort asending command to partially solve the formating problem but it would still require alot of work/time to organise it into the final format I need.

This is the current format of the instrument date:

Analyte Meas. Intensity
Rh 10
Y 98
Cs 66
Co 98
Analyte Meas. Intensity
Rh 10
Y 114
Cs 72
Co 86
Analyte Meas. Intensity
Rh 20
Y 108
Cs 44
Co 90
Analyte Meas. Intensity
Rh 20
Y 68
Cs 44
Co 66
Analyte Meas. Intensity
Rh 490.008
Y 58
Cs 34
Co 78
Used the "sort asending" command to separate data into useful form but need to get the data into either of the two tables shown below

Analyte Meas. Intensity
Analyte Meas. Intensity
Analyte Meas. Intensity
Analyte Meas. Intensity
Analyte Meas. Intensity
Co 98
Co 86
Co 90
Co 66
Co 78
Cs 66
Cs 72
Cs 44
Cs 44
Cs 34
Rh 10
Rh 10
Rh 20
Rh 20
Rh 490.008
Y 98
Y 114
Y 108
Y 68
Y 58
I would like to turn the data into this final format using a macro.

Co Cs Rh Y
98 66 10 98
86 72 10 114
90 44 20 108
66 44 20 68
78 34 490.008 58

Can somebody help me please ... Read more

A:create an excel macro to reorganise data?

ZIP and post a sample workbook.
Rollin
 

Read other 1 answers
RELEVANCY SCORE 44.8

i have Office 2000

what is the best way to create a chart with multiple lines relating to simple x and Y access data

i want to put maybe 10 sets of X and Y data on the same chart , thinking a line chart best with a different colour for each data set.

does office 2000 do this or is there a better app ???
 

A:how to create line charts from data file

Excel does charting and graphing.
 

Read other 1 answers
RELEVANCY SCORE 44.4

I am trying to create a new outlook data file, but when I open the new file I have the same info that my other file has. And if I change one thing it changes in both files. Can you tell me how to create a new pst data file with no data in it.
 

A:Need help to create blank Outlook 2003 pst data file

Create a new profile
 

Read other 1 answers