Price Brattin's Q&A profile

• SQL Server Import from Access - Datatype conversions

  I have to do a lot of inporting from Access files.  Is there a place where I can change the default datatype conversion for Access Text from nvarchar to varchar Thanks. Kato If you are using the import wizard then you can affect this with the mapping files at: %PROGRAMFILES%\Microsoft SQL Server\90\DTS\MappingFiles I'm guessing that the one you want is JetToSSIS.xml If you are building packages manually then you can change this in the source adapter. -Jamie ...Show All

• Visual C++ error C2065: 'vector' : undeclared identifier

  ok, i've been away from the language for a few years but i feel like i'm losing my mind. here's my code: // test.cpp #include <vector> void foo() { vector<int> v; } /////////////////////////////////////// and i get the error in the subject. this happens on both VC6 and 2005 Express. the compiler is finding the vector header, it's not complaining and i can right click on <vector> and pick open document and it opens the file. i can't imagine there's a compiler switch to enable templates is there i am obviously missing something very obvious but i've been banging my head for two hours. someone sort me out please. tnx. of course.. i guess at the point in Strous ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. [MDX] VertexBuffer.SetData() ArgumentException

  I'm creating a particle system in MDX and when I try to write the array that holds the particles I keep getting the ArgumentException. I've never had a problem with writing to a vertexBuffer before. Maybe someone can help me out with this. For now I'll just post the initialization of the VertexBuffer and how I write to it. Init vertexBuffer: mVertexBuffer = new VertexBuffer( typeof (Particle), mMaxParticles, mGDevice,                                     Usage.Dynamic | Usage.WriteOnly | Usage.Points,           &nb ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. myFirstGame sprite flicker - anyone else?

  i completed the first tutorial to make a sprite bounce around the screen. My sprite is 2kb at 87x61 pixels. Tutorial said to use a small sprite ... maybe that's a relative term, but i'd call that small. When my sprite moves around the screen, it looks like my computer is thinking really hard about redrawing it. i get a very noticeable flicker as it cruises around. Does anyone else have this problem i don't know what specs to feed you ... i'm running a dual-core system w/ 2GB RAM and a ATI X1300 vid card that has 256MB memory. i didn't think pushing a 2k image would bring it to its knees ( ) - MrSock Aha, found it, I think. The following line of code in my GraphicsDevice_DeviceReset call fixed the ...Show All

• Visual Studio VS 05 SP1 installed but not showing....

  Hi... Im using Microsoft Windows Server 2003, Enterprise Edition SP1 with the following VS info after installing VS80sp1-KB926601-X86-ENU.exe with no errors and finished successfully. Why does it not say SP1 Thanks, BillB My Dev Studio minus the keys looks like this: Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Enterprise Architect Microsoft Visual Basic 2005 Microsoft Visual Basic 2005 Microsoft Visual C# 2005 Microsoft Visual C# 2005 Microsoft Visual C++ 2005 Microsoft Visual C++ 2005 Microsoft Visual J# 2005 Microsoft Visual J# 2005 Microsoft Visual Studio Tools for Office Microsoft Visual Studio Tools for the Micros ...Show All

• Windows Live Developer Forums What's problem about errorcode "80048869"?

  MSN Messenger in my computer can't login MSN server. But myself component demo can login OK. Would you like to tell me what's meant about "80048869" ...Show All

• SQL Server three tables, 2 field combines and a left join

  Hi people, I have three tables, paths, files, mp3data. i need to combine two fields from paths and files on the path_id field that exists in both files and paths tables. select files.file_id, paths.path +'\'+ files.filename as FilesTBL from paths, files where paths.path_id = files.path_id then i need to do a left join to the mp3data table using file_id from the results of the first query above to find the paths that does not have data in the mp3data table. i have this query that works using the files table and the mp3data table. SELECT files.file_id, filename FROM files left join mp3data on mp3data.file_id = files.file_id where (mp3data.file_id is null) but i can not get this to work using the results of the first sql query above. ...Show All

• Smart Device Development minimize dialog in FormView app

  Hello. I have a FormView application set up and I need to be able to minimize the dialog when a button on the screen is pressed. Seems so simple, but I can't find how to do it.... Generally : howWindow(hDlg ,SW_MINIMIZE); does this. ...Show All

• Smart Device Development SNTP on CE 5.0 device not working as expected

  Hello, I've got serious problems getting the timesvc.dll (WinCE SNTP daemon) to work. It simply does *not* update the time of the device. I use my development PC WinXP with enabled Time Server as NTP Server and a CE 5.0 based device as Client. My Registry settings are as follows: [HKEY_LOCAL_MACHINE\Services\TIMESVC] "refresh"=dword:00001388 "recoveryrefresh"=dword:00002710 "threshold"=dword:00002710 "Server"="192.168.100.75" "Trustlocalclock"=dword:00000000 "ServerRole"=dword:00000000 "Order"=dword:00000063 "Dll"="timesvc.dll" "Clientonly"=dword:00000001 "Context"=dword:00000000 "Keep"=dword:00000001 "Prefix"="NTP" "Index"=dword:00000000 The time of my device is never updated. I don't know why. Can anybody give me some hint ...Show All

• Visual Studio Team System Incorrect syntax was encountered while parsing

  During deploy, I get the following error: ------ Build started: Project: WZ.Hermes.DB.Schema, Configuration: Default Any CPU ------ Building deployment script for Hermes : EnableFullTextSearch, BlockIncrementalDeploymentIfDataLoss WZ.Hermes.DB.Schema --> C:\Projekte\Team\Tilfried.Weissenberg\WZ.Hermes\WZ.Hermes.DB.Schema\sql\WZ.Hermes.DB.Schema.(local)_SQLEXPRESS.Hermes.sql ------ Deploy started: Project: WZ.Hermes.DB.Schema, Configuration: Default Any CPU ------ Deploying script C:\Projekte\Team\Tilfried.Weissenberg\WZ.Hermes\WZ.Hermes.DB.Schema\sql\WZ.Hermes.DB.Schema.(local)_SQLEXPRESS.Hermes.sql to server (local)\SQLEXPRESS C:\Projekte\Team\Tilfried.Weissenberg\WZ.Hermes\WZ.Hermes.DB.Schema\sql\WZ.Hermes.DB.Sch ...Show All

• Visual Studio Tools for Office Programmatically creating a new outlook email message containing tables

  I am writing an application using VB.NET in VS 2003 that needs to programmatically create a new email message in Outlook 2003.  The email needs to include tables containing data from a database.  How do I create the body of the email   I found information about creating Word documents which would work perfectly for my needs if I could make it work in Outlook.  http://support.microsoft.com/kb/316383   Does anyone know how I could get this to work Thank you ...Show All

• SQL Server copy structure ? Possible?

  I just installed SQLEXPRESS on XP Prof. It is working fine. I want to know if there is a way to copy a table structure so I could create clones. I need about 300 tables with identical structure but different name for each one. Also I am wondering if there is a way to ADD a table to SQL database. It is kind of a long shot but I will try to explain. I have about 200 tables in old Visual dBase format (v7.1). I would like to convert them to SQL Server tables. I found a company that offers an app that converts them to MySQL. I tried and it kind of works. I could open the output file in SQL Server but it is not a table but a kind of csv file with INSERT commands. I had to run it. So far it did not compile but in the future if those bugs (in t ...Show All

• SQL Server Install problem

  I am having a problem installing SQL express. I have 2.0 framework installed as well as the other express software. I also have Visual Studio 2003 installed. Do I need to uninstall other version of Visual Studio Do I need to uninstall other versions of SQL. I get an error but it does not tell me what the problem is. Thank you Dee this is from the core file Microsoft SQL Server 2005 Setup beginning at Wed Aug 16 18:14:14 2006 Process ID : 4668 c:\8c27e35b5d509dc8609c33e266\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/7/16 18:14:13 Complete: LoadResourcesAction at: 2006/7/16 18:14:13, returned true Running: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14 Loade ...Show All

• Visual Studio Tools for Office 5 Outlook questions (CommandBarPopup, StatusBar, TrayIcon & updating items)

  Hi all! I am having troubles coding some stuff on my outlook plugin. I'm using a shared office plugin on VS but i think this is the right section to put the post 1st In outlook toolbar you can see a CommandBarPopup that has a icon. How can i set a icon on a CommandBarPopup I tried adding a button with the popup caption before the popup and loose the popup caption but when the popup is clicked the area bellow the button i created is not filled so im not satisfied with the solution. Is there any way to fix this Can i use begingroup to acheive this 2nd Can i place a icon on outlook status bar How 3rd How should i proceed if i wish to add a windows tray icon everytime my plugin is started 4th How do you update outlook items. I mean if you ...Show All

• Visual Studio Express Editions reading

  How do i read, write, create, and edit variables in an configuration text file. Thanks. 1.) You don't want a text configuration file. There's something much better. 2.) to create settings variables a.) Open your project b.) On the main menu Project | Properties | Settings c.) create a user scoped variable called foo of type string 3.) To write foo: a.) In your code My.Settings.Foo = "green" My.Settings.save 4.) to read foo: Dim A as string = My.settings.foo ...Show All