Connect to MSDE

I have confirmed that MSDE is running on a workstation.
However, when I attempt to add it in EM, it doesn't
exist. Is there any changes I have to make on that
workstation running MSDE so that I can access it via EM ?
Besides, I have made a copy of the MDF file. We just want
to find out what is stored in the database. Is it
possible for us to access the data directly with Access
ADP or we have to attach it to another SQL Server ?
Thanks
Hi,
I. You can very well register and access MSDE using EM. Try identify the SQl
server name by reading the SQL Server Error log and
use the same name to register in EM.
II. You need to attach the MDF and LDF file into a SQL Server by giving
Database name using SP_ATTACH_DB command. After that
you could access the database to read/write the data
Thanks
Hari
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:093101c53fd0$62593c90$a601280a@.phx.gbl...
>I have confirmed that MSDE is running on a workstation.
> However, when I attempt to add it in EM, it doesn't
> exist. Is there any changes I have to make on that
> workstation running MSDE so that I can access it via EM ?
> Besides, I have made a copy of the MDF file. We just want
> to find out what is stored in the database. Is it
> possible for us to access the data directly with Access
> ADP or we have to attach it to another SQL Server ?
> Thanks
|||Peter
You will probably find you need to create an alias for the server msde is
running on. Use the client network utility in your SQL Server program group
to do this. Add the alias for whatever network protocol you are using.
Hope this helps
John
"Hari Prasad" wrote:

> Hi,
> I. You can very well register and access MSDE using EM. Try identify the SQl
> server name by reading the SQL Server Error log and
> use the same name to register in EM.
> II. You need to attach the MDF and LDF file into a SQL Server by giving
> Database name using SP_ATTACH_DB command. After that
> you could access the database to read/write the data
> Thanks
> Hari
> SQL Server MVP
>
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:093101c53fd0$62593c90$a601280a@.phx.gbl...
>
>
|||Hi Hari,
Can you help me on following ?
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***

Connect to MSDE

I have confirmed that MSDE is running on a workstation.
However, when I attempt to add it in EM, it doesn't
exist. Is there any changes I have to make on that
workstation running MSDE so that I can access it via EM ?
Besides, I have made a copy of the MDF file. We just want
to find out what is stored in the database. Is it
possible for us to access the data directly with Access
ADP or we have to attach it to another SQL Server ?
ThanksHi,
I. You can very well register and access MSDE using EM. Try identify the SQl
server name by reading the SQL Server Error log and
use the same name to register in EM.
II. You need to attach the MDF and LDF file into a SQL Server by giving
Database name using SP_ATTACH_DB command. After that
you could access the database to read/write the data
Thanks
Hari
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:093101c53fd0$62593c90$a601280a@.phx.gbl...
>I have confirmed that MSDE is running on a workstation.
> However, when I attempt to add it in EM, it doesn't
> exist. Is there any changes I have to make on that
> workstation running MSDE so that I can access it via EM ?
> Besides, I have made a copy of the MDF file. We just want
> to find out what is stored in the database. Is it
> possible for us to access the data directly with Access
> ADP or we have to attach it to another SQL Server ?
> Thanks|||Peter
You will probably find you need to create an alias for the server msde is
running on. Use the client network utility in your SQL Server program group
to do this. Add the alias for whatever network protocol you are using.
Hope this helps
John
"Hari Prasad" wrote:

> Hi,
> I. You can very well register and access MSDE using EM. Try identify the S
Ql
> server name by reading the SQL Server Error log and
> use the same name to register in EM.
> II. You need to attach the MDF and LDF file into a SQL Server by giving
> Database name using SP_ATTACH_DB command. After that
> you could access the database to read/write the data
> Thanks
> Hari
> SQL Server MVP
>
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:093101c53fd0$62593c90$a601280a@.phx.gbl...
>
>|||Hi Hari,
Can you help me on following ?
Have developed Client/Server (VB.NET) application with SQL Server 2000
backend engine. It is working fine. This application can connect to
Database engine if user in our LAN or WAN.
Now, my users need to work on application while they are not in our
network. For instance from Hotel, travel etc.. To achieve this, I
thought to have MSDE installed on user's laptop and get copy of SQL 2k
DB on user machine. But. here I got stuck !. Woudl really appreciate if
you could help me !
MSDE engine, I hope that I can d/load from MS site. Belive that can be
installed easly like other MS application. Upon installation, how can I
get my SQL 2K DB attached or Sychronized ?
What about login id (like "sa") to connect to MSDE engine from my
applciation. I will modify my application user to choose DB engine LOCAL
or LAN. If LAN, I will use my existing connection string. But, LOCAL,
what would be the provider, password, user id etc..
Never user MSDE, so queries will be bit more.
Appreciate all your help to get this resolved.
Many thanks in advance..
Regards,
AJ
*** Sent via Developersdex http://www.codecomments.com ***

Connect to MSDE

I have confirmed that MSDE is running on a workstation.
However, when I attempt to add it in EM, it doesn't
exist. Is there any changes I have to make on that
workstation running MSDE so that I can access it via EM ?
Besides, I have made a copy of the MDF file. We just want
to find out what is stored in the database. Is it
possible for us to access the data directly with Access
ADP or we have to attach it to another SQL Server ?
ThanksHi,
I. You can very well register and access MSDE using EM. Try identify the SQl
server name by reading the SQL Server Error log and
use the same name to register in EM.
II. You need to attach the MDF and LDF file into a SQL Server by giving
Database name using SP_ATTACH_DB command. After that
you could access the database to read/write the data
Thanks
Hari
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:093101c53fd0$62593c90$a601280a@.phx.gbl...
>I have confirmed that MSDE is running on a workstation.
> However, when I attempt to add it in EM, it doesn't
> exist. Is there any changes I have to make on that
> workstation running MSDE so that I can access it via EM ?
> Besides, I have made a copy of the MDF file. We just want
> to find out what is stored in the database. Is it
> possible for us to access the data directly with Access
> ADP or we have to attach it to another SQL Server ?
> Thanks

connect to different SQL via SP

I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition on
my local workstation. SQL2 is out on the internet, remote from SQL3 which is
also out there on the internet. Currently, I have a DTS on SQL1 that copies
data from SQL3 over to SQL2. Problem: I would like to get this on a
schedule. I don't want to schedule it on my SQL1 machine and I'm not allowed
DTS packages on SQL2 and SQL3 because they are on shared plans. That leaves
me with scheduling SPs through the use of ASP pages.
Is it possible to transfer data between SQL2 and SQL3 in an SP?
thanks!shank
Have you looked at linked servers? For more details please refer to the BOL
"shank" <shank@.tampabay.rr.com> wrote in message
news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>I have three locations: SQL1, SQL2 and SQL3. SQL1 is a Developers Edition
>on my local workstation. SQL2 is out on the internet, remote from SQL3
>which is also out there on the internet. Currently, I have a DTS on SQL1
>that copies data from SQL3 over to SQL2. Problem: I would like to get this
>on a schedule. I don't want to schedule it on my SQL1 machine and I'm not
>allowed DTS packages on SQL2 and SQL3 because they are on shared plans.
>That leaves me with scheduling SPs through the use of ASP pages.
> Is it possible to transfer data between SQL2 and SQL3 in an SP?
> thanks!
>|||I have just been advised by our webhost that they do not allow Linked
Servers due to security issues.
Is there another way to connect through an SP?
In short, I need to automate transfer of data from SQL3 to SQL2 without
Linked Servers or DTS packages.
thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uEltjujIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> shank
> Have you looked at linked servers? For more details please refer to the
> BOL
> "shank" <shank@.tampabay.rr.com> wrote in message
> news:%230vAUpgIGHA.1124@.TK2MSFTNGP10.phx.gbl...
>

Connect to a DSN for data

I have an AS400 system and I created a DSN to see the data on my workstation. The connection works fine. I created the samne connection on the Server that has SQL 2005 installed. What I need to do is to populate the SQL database with tables from the AS400 table but I am having trouble connecting a DSN to the SQL database.

Can anyone offer some advice or a website that could walk me through this?

Hello,

I think you should be using Integration Services for this, Reporting Services does not do any type of data transfer. IS will be able to handle this easily, one connection will be your SQL Server, the other will be a ODBC or OLE DB connection using your DSN.

Hope this helps.

Jarret

Conflicts?

Does anyone know if there is a conflict between MS SQL 7.0 and Sybase's SQL client running on the same PC? Reason is I have a workstation that is config'ed like this and the MS SQL Server Agent will not run. Gets the error that a response from the Agent was not received in time.Hi,
No , I have Sybase 12 and MSSQL server client running my machine and running
smoothly. Just check the availability of environment variables
\binn for SQL server
\bin for Sybase.
Otherwise using explorer go to the appropriate directories and execute the
client softwares.
Thanks
Hari
MCDBA
"dbush" <anonymous@.discussions.microsoft.com> wrote in message
news:793F0A29-CE6E-4625-A042-DBA33B104B40@.microsoft.com...
> Does anyone know if there is a conflict between MS SQL 7.0 and Sybase's
SQL client running on the same PC? Reason is I have a workstation that is
config'ed like this and the MS SQL Server Agent will not run. Gets the error
that a response from the Agent was not received in time.