Almost, SQL does not by default import primary key's or autonumber fields.
SQL Server does not have memo fields either. You will want to stay away from
them, just to be safe.
I usually point the SQL Server ODBC driver to 127.0.0.1, but localhost will
probably work too.
jon
----- Original Message -----
From: "Geoff Hoffman" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 8:38 PM
Subject: Access - SQL - CF - questions
> i'm developing the alpha version of a CF - Access "web app" and have
> a question regarding migrating access to msSQL7 ...
>
> i haven't really looked into mssql7 that far, but i just have this
> theory that if i set up/recreate exactly (or import?) the .mdb file's
> structure in a sql7 file, everything should 'pretty much' work the
> same, or more to the point, faster, which is the point i guess.
>
> am i too far off ? all of my sql statements are realitively
straightforward
> ( ben forta's teach yourself SQL in 10 min. )
>
> also, in regard to maping SQL7 as a datasource in CF... it's not
> done the same as access, is it? for now the db/sql7server is on the
> same machine as cfserver, would the syntax be 'localhost' or
'computername.
> db' as Matt said?
>
>
>
>
>
>
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
