[dba-VB] Weird table name restriction

Right!  Those pesky, literal-minded computers!  They insist on doing
what I tell them instead of what I WANT.  LOL

Charlotte 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Friday, November 30, 2007 4:31 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Weird table name restriction

"What a PITA.  Keeps me searching for answers long after this thing
should just work." jc

...my life as a developer :(

William

----- Original Message -----
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: <dba-vb at databaseadvisors.com>
Sent: Friday, November 30, 2007 2:21 PM
Subject: Re: [dba-VB] Weird table name restriction


> The problem is that they are fine (as are spaces) in file names...
>
> I am doing a "copy file to temp table, copy temp to permanent".  Thus
the
> temp table name is just the file name.  I discussed awhile back that I
got
> an "in" or something similar as a file name, which collided with a
reserve
> word.  kind of the same issue only different.
>
> What a PITA.  Keeps me searching for answers long after this thing
should
> just work.
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
> Sent: Friday, November 30, 2007 2:11 PM
> To: dba-vb at databaseadvisors.com
> Subject: Re: [dba-VB] Weird table name restriction
>
> Yep, dashes are as bad as spaces.  ;-}
>
> Charlotte Foust
>
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Friday, November 30, 2007 11:04 AM
> To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com
> Subject: [dba-VB] Weird table name restriction
>
> I just discovered that SQL Server (or VB.Net) does not like dashes in 
> table
> names.
>
> If I use a table name "ZIP4-AA_X", the BulkCopy.WriteToServer throws
an
> error "can't access destination table" but if I remove the dash
"ZIP4AA_X"
> it works just fine.
>
> The problem is that I take the name of the datafile, strip off the 
> extension
> and use that as my table name.  Thus I now have to start doing edits
of 
> the
> file name before I can use it as a field name.
>
> The hoops we have to jump through...
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 


_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com