Correct connection string for sql express2005 using VS2003

Hi,

I am using VS2003. I have installed .net2.0 so that I can run SQL Express. I am using XP Pro SP2.

My server is called ikitsch. The path to my database is

ikitsch\sqlexpress\Databases\Test1

I am using windows authentication. For some reason I can't seem to connect to the database. What would be a correct connection string to

connect to this database on my local machine?

Thanks

Hi

Take a look at http://www.connectionstrings.com/ for all kinds of connection strings.

Hope it helps.

|||Thanks a lot...one of ems gotta work!

copying data from a foreign database to Sql Server 2000

I am going to be setting up some Stored procedures that will be copying
data from a foreign database that will have an ODBC connection.
This task will need to be executed at night or from a .NET web page and
I was wondering what would the best way to copy the data from this
procedure.
It won't be necessarily be copying all the data from the database, but
could copy selected tables at different times.
Is this easily done from a Stored Procedure?
Thanks,
Tom.I would play with DTS if I were you. Seems a better candidate than a sproc
without using Linked Servers and such...
Greg Jackson
PDX, Oregon|||Jaxon wrote:

> I would play with DTS if I were you. Seems a better candidate than a sproc
> without using Linked Servers and such...
>
The question is, can it be run from ASP.NET? They want to run this
during the day when necessary, not just at a particular time of day and
don't want to run it from EM.
Tom.

> Greg Jackson
> PDX, Oregon
>
>

copying connection/registration info to other pc

hi folks
i need to transfer all my sql 2000 registerede databases from my desktop to
my laptop.
is there an easy way to do this? hope so ;)
thanks!This data is stored in the regsitry in the HKCU key. You could try copying
the regsitry from your desktop and importing it into your laptop's regsitry.
But make sure you backup the registry key on your laptop before you do. I
don't know if the user credentials are stored in the key or if they're
encrypted with a machine key, so you'll want to be careful so you can
restore everything in case this breaks Enterprise manager.
Mark
"moishie" <moishie@.discussions.microsoft.com> wrote in message
news:5B1F9178-D71E-42E8-B661-E64B6F2551CC@.microsoft.com...
> hi folks
> i need to transfer all my sql 2000 registerede databases from my desktop
> to
> my laptop.
> is there an easy way to do this? hope so ;)
> thanks!|||Thanks, Mark
i appreciate it
"Mark Miller" wrote:

> This data is stored in the regsitry in the HKCU key. You could try copying
> the regsitry from your desktop and importing it into your laptop's regsitr
y.
> But make sure you backup the registry key on your laptop before you do. I
> don't know if the user credentials are stored in the key or if they're
> encrypted with a machine key, so you'll want to be careful so you can
> restore everything in case this breaks Enterprise manager.
> Mark
>
> "moishie" <moishie@.discussions.microsoft.com> wrote in message
> news:5B1F9178-D71E-42E8-B661-E64B6F2551CC@.microsoft.com...
>
>

copying connection/registration info to other pc

hi folks
i need to transfer all my sql 2000 registerede databases from my desktop to
my laptop.
is there an easy way to do this? hope so ;)
thanks!This data is stored in the regsitry in the HKCU key. You could try copying
the regsitry from your desktop and importing it into your laptop's regsitry.
But make sure you backup the registry key on your laptop before you do. I
don't know if the user credentials are stored in the key or if they're
encrypted with a machine key, so you'll want to be careful so you can
restore everything in case this breaks Enterprise manager.
Mark
"moishie" <moishie@.discussions.microsoft.com> wrote in message
news:5B1F9178-D71E-42E8-B661-E64B6F2551CC@.microsoft.com...
> hi folks
> i need to transfer all my sql 2000 registerede databases from my desktop
> to
> my laptop.
> is there an easy way to do this? hope so ;)
> thanks!|||Thanks, Mark
i appreciate it
"Mark Miller" wrote:
> This data is stored in the regsitry in the HKCU key. You could try copying
> the regsitry from your desktop and importing it into your laptop's regsitry.
> But make sure you backup the registry key on your laptop before you do. I
> don't know if the user credentials are stored in the key or if they're
> encrypted with a machine key, so you'll want to be careful so you can
> restore everything in case this breaks Enterprise manager.
> Mark
>
> "moishie" <moishie@.discussions.microsoft.com> wrote in message
> news:5B1F9178-D71E-42E8-B661-E64B6F2551CC@.microsoft.com...
> > hi folks
> >
> > i need to transfer all my sql 2000 registerede databases from my desktop
> > to
> > my laptop.
> > is there an easy way to do this? hope so ;)
> >
> > thanks!
>
>

copy/paste bugs

try copying a connection manager from one package to another

it does not work

e.g. excel connection manager

it loses the name of the connection manager and also the file you are pointing to

so it is basically no different to 'add new connection manager'

also

try copying the name of the connection manager to another connection

select connection, hit F2 (edit) ctrl C,

try pasting!

in order to paste you have to right click on the selected text and select copy from the context menu

this is not a bug

this sloppy, poorly tested software

So get busy posting these bugs over at http://connect.microsoft.com/sqlserver/feedback.