connection error

Hello freinds,

i want to copy my bulk files to database using dts.bulkinsert function.For that i need to activate MS Distributed Transatction Coordinator.But whwn i am activating this i am getting [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. error. can anyone please suggest me whats d problem exactly and hoe can i remove it.:confused:Hi,

Please check whether the services are started or not.

If not open service manager and start the services.

Regards,
Shashidhar

connection between sql files and .Net

I have a project I'm trying to open using sql server .Net but there's a problem with the "connection" between the two. What should I do? Something with "attaching" the *.ldf and *.mdf files?!
I'll apperciate any kind of suggestion.
Thanks,
Inbal.
Hi,
Before connecting it from the application attach the database (MDF and LDF)
file using Query Analyzer.
Steps:
1. Login to SQL Serevr using Query analyzer
2. Copy the MDF and LDF file to a specific directory say (C:\mssql\data\)
3 Attach the MDF and LDF files to SQL server using a database name, use the
below command
sp_attach_db 'dbname','c:\msql\data\dbname_data.MDFdbname_log.L DF'
Executing the above command will attach the database to SQl server, After
that try to access your database using application.
Thanks
Hari
MCDBA
"inbal" <inbal_rulz@.hotmail.com> wrote in message
news:EF7647E2-5CDC-4651-9DE0-6DEE94456460@.microsoft.com...
> I have a project I'm trying to open using sql server .Net but there's a
problem with the "connection" between the two. What should I do? Something
with "attaching" the *.ldf and *.mdf files?!
> I'll apperciate any kind of suggestion.
> Thanks,
> Inbal.

connection between sql files and .Net

I have a project I'm trying to open using sql server .Net but there's a problem with the "connection" between the two. What should I do? Something with "attaching" the *.ldf and *.mdf files?
I'll apperciate any kind of suggestion.
Thanks
Inbal.Hi,
Before connecting it from the application attach the database (MDF and LDF)
file using Query Analyzer.
Steps:
1. Login to SQL Serevr using Query analyzer
2. Copy the MDF and LDF file to a specific directory say (C:\mssql\data\)
3 Attach the MDF and LDF files to SQL server using a database name, use the
below command
sp_attach_db 'dbname','c:\msql\data\dbname_data.MDFdbname_log.LDF'
Executing the above command will attach the database to SQl server, After
that try to access your database using application.
Thanks
Hari
MCDBA
"inbal" <inbal_rulz@.hotmail.com> wrote in message
news:EF7647E2-5CDC-4651-9DE0-6DEE94456460@.microsoft.com...
> I have a project I'm trying to open using sql server .Net but there's a
problem with the "connection" between the two. What should I do? Something
with "attaching" the *.ldf and *.mdf files?!
> I'll apperciate any kind of suggestion.
> Thanks,
> Inbal.

connection between sql files and .Net

I have a project I'm trying to open using sql server .Net but there's a prob
lem with the "connection" between the two. What should I do? Something with
"attaching" the *.ldf and *.mdf files?!
I'll apperciate any kind of suggestion.
Thanks,
Inbal.Hi,
Before connecting it from the application attach the database (MDF and LDF)
file using Query Analyzer.
Steps:
1. Login to SQL Serevr using Query analyzer
2. Copy the MDF and LDF file to a specific directory say (C:\mssql\data\)
3 Attach the MDF and LDF files to SQL server using a database name, use the
below command
sp_attach_db 'dbname','c:\msql\data\dbname_data.MDFdbname_log.LDF'
Executing the above command will attach the database to SQl server, After
that try to access your database using application.
Thanks
Hari
MCDBA
"inbal" <inbal_rulz@.hotmail.com> wrote in message
news:EF7647E2-5CDC-4651-9DE0-6DEE94456460@.microsoft.com...
> I have a project I'm trying to open using sql server .Net but there's a
problem with the "connection" between the two. What should I do? Something
with "attaching" the *.ldf and *.mdf files?!
> I'll apperciate any kind of suggestion.
> Thanks,
> Inbal.

Connecting VB Express files to SQL Server Management Studio Express

Really confused ... I created 2 tables in a VB Express program (which went well). Problem is that I can't see/find those tables with MSME. I don't really understand how to connect the MSME to where the tables are. I created the tables under \My Documents\Data and they are DBapp.mdf + DBapp_log.LDF and the tables are Items and Preferences. The VB application can "see" the tables OK.

Do I need to move the tables to C:\Program Files\Microsoft SQL Server\MSQL.1\MSQL\DATA (like the Adventureworks installation which I haven't done) or what?

Please help a newbie

Thanks

George

Are you suing a user instance or a server attached instance ? If you are not sure post the connection string here, that we can see which method you are using. If you are using a user instance, you won′t see them in the managment studio unless you attach the database to the server. Visual Studio can also make them viewable in the Server Explorer.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

The express products can only use the sql express system if it is installed as a instance name called ".\SQLEXPRESS". Also when it does create files it creates them as a user instance. This means that the files are not attached to the actuall engine untill the application starts. If you do want to use these database files from the SQL Management Studio you will have to attach these to the engine. To do this I would copy the files to another directory (Say c:\Data" and then from the Management Studio under the databases tab right click and select attach....