Dear Group,
I'm using Access 2003 linked to an SQL Server data table via an ODBC
connection.
On one form I have several check boxes which want data mapped to a
TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
bit, a binary, or a tinyint? I've only been able to get it to work
with a smallint which is 2 bytes long.
Thanks,
Max
Arg. Access wants to insert -1 for true and 0 for false.
So sorry the type will need to support negative numbers.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Max Yaffe" <myaffe@.not.gamry.com> wrote in message
news:0f1ji1p22uleclnn5t4lka3vnta48bda3k@.4ax.com...
> Dear Group,
> I'm using Access 2003 linked to an SQL Server data table via an ODBC
> connection.
> On one form I have several check boxes which want data mapped to a
> TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
> bit, a binary, or a tinyint? I've only been able to get it to work
> with a smallint which is 2 bytes long.
> Thanks,
> Max
Showing posts with label dear. Show all posts
Showing posts with label dear. Show all posts
Thursday, March 22, 2012
Binary or Byte data linked to Checkbox
Dear Group,
I'm using Access 2003 linked to an SQL Server data table via an ODBC
connection.
On one form I have several check boxes which want data mapped to a
TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
bit, a binary, or a tinyint? I've only been able to get it to work
with a smallint which is 2 bytes long.
Thanks,
MaxArg. Access wants to insert -1 for true and 0 for false.
So sorry the type will need to support negative numbers.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Max Yaffe" <myaffe@.not.gamry.com> wrote in message
news:0f1ji1p22uleclnn5t4lka3vnta48bda3k@.
4ax.com...
> Dear Group,
> I'm using Access 2003 linked to an SQL Server data table via an ODBC
> connection.
> On one form I have several check boxes which want data mapped to a
> TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
> bit, a binary, or a tinyint? I've only been able to get it to work
> with a smallint which is 2 bytes long.
> Thanks,
> Max
I'm using Access 2003 linked to an SQL Server data table via an ODBC
connection.
On one form I have several check boxes which want data mapped to a
TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
bit, a binary, or a tinyint? I've only been able to get it to work
with a smallint which is 2 bytes long.
Thanks,
MaxArg. Access wants to insert -1 for true and 0 for false.
So sorry the type will need to support negative numbers.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Max Yaffe" <myaffe@.not.gamry.com> wrote in message
news:0f1ji1p22uleclnn5t4lka3vnta48bda3k@.
4ax.com...
> Dear Group,
> I'm using Access 2003 linked to an SQL Server data table via an ODBC
> connection.
> On one form I have several check boxes which want data mapped to a
> TRUE/FALSE datatype. Is there a direct way to bind a checkbox to a
> bit, a binary, or a tinyint? I've only been able to get it to work
> with a smallint which is 2 bytes long.
> Thanks,
> Max
Tuesday, March 20, 2012
big problem with data conversion
Dear colleagues, I have a big problem with data conversion. For example, on my Windows form (C#) i have one text box and in my table I have field type float. When I use following conversion or casting:
float i = (float)Convert.ToDouble(textBox1.Text);
and insert number 12,3 in my table I have following number 12.30000000000032324!
What I must to do with this conversion and have in my table number 12,3?
Hi,
although this is not a C# forum, you should take a look at the Help for a more precise datatype than float.
http://msdn2.microsoft.com/en-us/library/b1e65aza.aspx
In addition see the float definition in the BOL for more information about float in SQL Server.
You might want to have a look on the decimal type instead.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Thursday, March 8, 2012
BI Accelerator 1.1 and Bulk Insert
Dear Anyone,
I had been using BI Accelerator 1.1 for 2 years now. In our current project, I encountered the following error during the importing phase of BI.
I traced the problem to the bulk insert statement that BI Accelerator is executing which is ...
BULK INSERT [Project88_Staging]..[S_Fact_BrdcastAlert] FROM 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\Import\S_Fact_BrdcastAlert.txt' WITH ( FORMATFILE = 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\DTS\Import\Format\S_Fact_Brdcast Alert.fmt' , DATAFILETYPE = 'widechar', BATCHSIZE = 100000 , MAXERRORS = 100 )
The error that it generates is as follows:
Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.
We export data to text files that BI Accelerator picks up. All other files imports properly imported without problems except for one fact table text file. We use the same format file that BI Accelerator uses to export to file the data to make sure that there would be no incompatabilities. File size is about 2.3GB++, which is a standard size with our other fact table files that doesnt have any errors.
We also checked for data error which we found none. We also checked the txt file we generate, notepad confirms that it is a unicode file.
Can anyone please shed a light in what is happening. Is this a bug? As much as possible I dont want to place a workaround on this one since our entire framework for loading data is all the same and has already been set up. Any help would be apreciated.
Thank YouAny reply would be appreciated.
Joseph Ollero
jollero@.wizardsgroup.com
I had been using BI Accelerator 1.1 for 2 years now. In our current project, I encountered the following error during the importing phase of BI.
I traced the problem to the bulk insert statement that BI Accelerator is executing which is ...
BULK INSERT [Project88_Staging]..[S_Fact_BrdcastAlert] FROM 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\Import\S_Fact_BrdcastAlert.txt' WITH ( FORMATFILE = 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\DTS\Import\Format\S_Fact_Brdcast Alert.fmt' , DATAFILETYPE = 'widechar', BATCHSIZE = 100000 , MAXERRORS = 100 )
The error that it generates is as follows:
Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.
We export data to text files that BI Accelerator picks up. All other files imports properly imported without problems except for one fact table text file. We use the same format file that BI Accelerator uses to export to file the data to make sure that there would be no incompatabilities. File size is about 2.3GB++, which is a standard size with our other fact table files that doesnt have any errors.
We also checked for data error which we found none. We also checked the txt file we generate, notepad confirms that it is a unicode file.
Can anyone please shed a light in what is happening. Is this a bug? As much as possible I dont want to place a workaround on this one since our entire framework for loading data is all the same and has already been set up. Any help would be apreciated.
Thank YouAny reply would be appreciated.
Joseph Ollero
jollero@.wizardsgroup.com
Wednesday, March 7, 2012
Beyond SQL
Dear gurus,
Which are the most difficult tasks for a guru? Which would be the most
complex task concerning RDBMS?
I am not talking about administrative tasks, common routines, left join
issues, nested cursors, etc, but amazing milestones, strange jobs or
nightmares using the maximum capabilities of SQL engine.
Thanks in advance and regards,,How do you define "guru"?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...
> Dear gurus,
> Which are the most difficult tasks for a guru? Which would be the most
> complex task concerning RDBMS?
> I am not talking about administrative tasks, common routines, left join
> issues, nested cursors, etc, but amazing milestones, strange jobs or
> nightmares using the maximum capabilities of SQL engine.
> Thanks in advance and regards,,|||"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...
> Dear gurus,
> Which are the most difficult tasks for a guru? Which would be the most
> complex task concerning RDBMS?
> I am not talking about administrative tasks, common routines, left join
> issues, nested cursors, etc, but amazing milestones, strange jobs or
> nightmares using the maximum capabilities of SQL engine.
> Thanks in advance and regards,,
The biggest hurdle I have seen lately is moving from a small to medium size
database architecture and schema and then designing and developing and
migrating that solution to a VLDB environment. There are a lot of potential
gotchas and mistakes that are made.
It is one thing to design speed and intelligence into a system that works
with 100 million rows and something else entirely when you are dealing with
billions of rows.
Just my .02
Rick Sawtell|||Trying to avoid the throngs of female fans while on public outings;
especially if they show up at user group meetings and sit on the front row
just drooling while you're trying to give a presentation. Then there are the
weird g
s who walk up to the table (while at a restraunt with the wife and
kids) and shove some 20 page sample of crap SQL under your nose expecting
you to somehow shed some light on their problem between bites of veal
parmesan. Once you reach a certain level of popularity, it can be a real
problem.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...
> Dear gurus,
> Which are the most difficult tasks for a guru? Which would be the most
> complex task concerning RDBMS?
> I am not talking about administrative tasks, common routines, left join
> issues, nested cursors, etc, but amazing milestones, strange jobs or
> nightmares using the maximum capabilities of SQL engine.
> Thanks in advance and regards,,|||I wouldn't call myself a guru, but what the hell.
For me, understanding the business is always the most critical and most
difficult part of my job. Until I understand how the business's data
IS - that is, what it is, what is an attribute of what, how it relates
within itself and how it flows - I am effectively spinning my wheels.
Free advice, freely given - worth what you pay for it.
Payson
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...|||LOL. Not to mention the paparizzi - who can script with all those camera
flashes?|||That's why we have body guards and ride around in limos with tented windows.
;-)
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23ffSONzoFHA.3120@.TK2MSFTNGP09.phx.gbl...
> LOL. Not to mention the paparizzi - who can script with all those camera
> flashes?
>
Which are the most difficult tasks for a guru? Which would be the most
complex task concerning RDBMS?
I am not talking about administrative tasks, common routines, left join
issues, nested cursors, etc, but amazing milestones, strange jobs or
nightmares using the maximum capabilities of SQL engine.
Thanks in advance and regards,,How do you define "guru"?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...
> Dear gurus,
> Which are the most difficult tasks for a guru? Which would be the most
> complex task concerning RDBMS?
> I am not talking about administrative tasks, common routines, left join
> issues, nested cursors, etc, but amazing milestones, strange jobs or
> nightmares using the maximum capabilities of SQL engine.
> Thanks in advance and regards,,|||"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...
> Dear gurus,
> Which are the most difficult tasks for a guru? Which would be the most
> complex task concerning RDBMS?
> I am not talking about administrative tasks, common routines, left join
> issues, nested cursors, etc, but amazing milestones, strange jobs or
> nightmares using the maximum capabilities of SQL engine.
> Thanks in advance and regards,,
The biggest hurdle I have seen lately is moving from a small to medium size
database architecture and schema and then designing and developing and
migrating that solution to a VLDB environment. There are a lot of potential
gotchas and mistakes that are made.
It is one thing to design speed and intelligence into a system that works
with 100 million rows and something else entirely when you are dealing with
billions of rows.
Just my .02
Rick Sawtell|||Trying to avoid the throngs of female fans while on public outings;
especially if they show up at user group meetings and sit on the front row
just drooling while you're trying to give a presentation. Then there are the
weird g
s who walk up to the table (while at a restraunt with the wife andkids) and shove some 20 page sample of crap SQL under your nose expecting
you to somehow shed some light on their problem between bites of veal
parmesan. Once you reach a certain level of popularity, it can be a real
problem.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...
> Dear gurus,
> Which are the most difficult tasks for a guru? Which would be the most
> complex task concerning RDBMS?
> I am not talking about administrative tasks, common routines, left join
> issues, nested cursors, etc, but amazing milestones, strange jobs or
> nightmares using the maximum capabilities of SQL engine.
> Thanks in advance and regards,,|||I wouldn't call myself a guru, but what the hell.
For me, understanding the business is always the most critical and most
difficult part of my job. Until I understand how the business's data
IS - that is, what it is, what is an attribute of what, how it relates
within itself and how it flows - I am effectively spinning my wheels.
Free advice, freely given - worth what you pay for it.
Payson
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:9A450896-F654-43D4-9755-1C4A5C0580F2@.microsoft.com...|||LOL. Not to mention the paparizzi - who can script with all those camera
flashes?|||That's why we have body guards and ride around in limos with tented windows.
;-)
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23ffSONzoFHA.3120@.TK2MSFTNGP09.phx.gbl...
> LOL. Not to mention the paparizzi - who can script with all those camera
> flashes?
>
Friday, February 24, 2012
Best way to stop Transactional Replication
Dear All,
Can anyone point me to a resource for the best way to disable transactional
replication for one database where there are multiple databases on a server
being replicated.
Thanks
Peter
Drop the publications. To do this expand your database, expand the
publications folder and right click on each one and select delete.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
news:E6A1ACD5-D9A0-4091-ABDE-0E677A132485@.microsoft.com...
> Dear All,
> Can anyone point me to a resource for the best way to disable
transactional
> replication for one database where there are multiple databases on a
server
> being replicated.
> Thanks
> Peter
|||Thanks Hilary,
We have done that in the past, however the last time we did it we ran into a
problem. Although the publication had been deleted using the method you said,
when we went to modify the table stucture of the publication database we
recieved the 'Cannot modify schema as its used in replication error'
Finally I had to create a new database, copy the data over, then apply the
changes. We have another release this Thursday, is there anything you can
sugest ?
Thanks for your time
Peter
"Hilary Cotter" wrote:
> Drop the publications. To do this expand your database, expand the
> publications folder and right click on each one and select delete.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
> news:E6A1ACD5-D9A0-4091-ABDE-0E677A132485@.microsoft.com...
> transactional
> server
>
>
|||You could use sp_MSunmarkreplinfo to allow modifications
after dropping the publication.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul,
I will try that if things become pear shaped.
Peter
"Paul Ibison" wrote:
> You could use sp_MSunmarkreplinfo to allow modifications
> after dropping the publication.
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Can anyone point me to a resource for the best way to disable transactional
replication for one database where there are multiple databases on a server
being replicated.
Thanks
Peter
Drop the publications. To do this expand your database, expand the
publications folder and right click on each one and select delete.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
news:E6A1ACD5-D9A0-4091-ABDE-0E677A132485@.microsoft.com...
> Dear All,
> Can anyone point me to a resource for the best way to disable
transactional
> replication for one database where there are multiple databases on a
server
> being replicated.
> Thanks
> Peter
|||Thanks Hilary,
We have done that in the past, however the last time we did it we ran into a
problem. Although the publication had been deleted using the method you said,
when we went to modify the table stucture of the publication database we
recieved the 'Cannot modify schema as its used in replication error'
Finally I had to create a new database, copy the data over, then apply the
changes. We have another release this Thursday, is there anything you can
sugest ?
Thanks for your time
Peter
"Hilary Cotter" wrote:
> Drop the publications. To do this expand your database, expand the
> publications folder and right click on each one and select delete.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
> news:E6A1ACD5-D9A0-4091-ABDE-0E677A132485@.microsoft.com...
> transactional
> server
>
>
|||You could use sp_MSunmarkreplinfo to allow modifications
after dropping the publication.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul,
I will try that if things become pear shaped.
Peter
"Paul Ibison" wrote:
> You could use sp_MSunmarkreplinfo to allow modifications
> after dropping the publication.
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Subscribe to:
Posts (Atom)