Is anyone familiar with Versant and how it stacks up against MS SQL as a
development technology. I have a client that currently has an application
developed on Versant and they want to investigate moving to MS SQL.
Any help or direction is appreciated.
Thanks
--
George AdrianAs far as I can tell from a quick look at their web site, the Versant DB
does not use SQL, but instead is queried via an object API. Is that
accurate? If so, the changes to the application's data access code are
going to be massive -- you're going to have to write queries instead of
using objects. I hope that the client's code is well structured and that
they've segregated the data access and business / user interface code enough
that this won't require a complete re-write of the application.
Why do they want to switch, anyway?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"George Adrian" <GeorgeAdrian@.discussions.microsoft.com> wrote in message
news:EEEC9583-E662-4612-9071-001CDE36CF57@.microsoft.com...
> Is anyone familiar with Versant and how it stacks up against MS SQL as a
> development technology. I have a client that currently has an application
> developed on Versant and they want to investigate moving to MS SQL.
> Any help or direction is appreciated.
> Thanks
> --
> George Adrian|||Adam,
thanks for your feedback, yes the database is an object database.
The client wishes to change because the development is costing too much and
the developer is unable to provide any documentation. The community for
development in this field seems to be smaller and therefore more expensive.
that is why they want to change.
--
George Adrian
"Adam Machanic" wrote:
> As far as I can tell from a quick look at their web site, the Versant DB
> does not use SQL, but instead is queried via an object API. Is that
> accurate? If so, the changes to the application's data access code are
> going to be massive -- you're going to have to write queries instead of
> using objects. I hope that the client's code is well structured and that
> they've segregated the data access and business / user interface code enou
gh
> that this won't require a complete re-write of the application.
> Why do they want to switch, anyway?
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "George Adrian" <GeorgeAdrian@.discussions.microsoft.com> wrote in message
> news:EEEC9583-E662-4612-9071-001CDE36CF57@.microsoft.com...
>
>
Showing posts with label client. Show all posts
Showing posts with label client. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
MS SQL Setup for beginners
:) Hi dear fellow members,
I am a newbie to MS SQL. I already completed the installations on the SERVER side and CLIENT side. I have an inventory database in Ms Access that I want to transfer into MS SQL SERVER 2000. Is there anybody who can help me how to do it?
I would be very thankful to anybody who can help like me
who is new to SQL
Regards.
BOBOY PONCEUse the DTS under your tools menu. This will bring in the whole table.
You can create a new table in the server and import the data only.
I am a newbie to MS SQL. I already completed the installations on the SERVER side and CLIENT side. I have an inventory database in Ms Access that I want to transfer into MS SQL SERVER 2000. Is there anybody who can help me how to do it?
I would be very thankful to anybody who can help like me
who is new to SQL
Regards.
BOBOY PONCEUse the DTS under your tools menu. This will bring in the whole table.
You can create a new table in the server and import the data only.
ms sql server response is slow
Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgs
You have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs
|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
sql
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgs
You have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs
|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
sql
ms sql server response is slow
Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on Windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on Windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO librari
es
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exact
ly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers do
wn
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
i have ms access client program connecting to sql server 2000 wif sp3a
running on Windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on Windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO librari
es
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exact
ly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers do
wn
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
ms sql server response is slow
Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> > Hi ,
> >
> > i have ms access client program connecting to sql server 2000 wif sp3a
> > running on windows 2000 server
> >
> > the user is complaining that the response from the client program is slow
> >
> > i have check the current activity and there's no much user connected and
> > there's no lock/blocking process
> >
> > where could i check further to determine the cause ?
> >
> > tks & rdgs
>
>
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> > Hi ,
> >
> > i have ms access client program connecting to sql server 2000 wif sp3a
> > running on windows 2000 server
> >
> > the user is complaining that the response from the client program is slow
> >
> > i have check the current activity and there's no much user connected and
> > there's no lock/blocking process
> >
> > where could i check further to determine the cause ?
> >
> > tks & rdgs
>
>
Monday, March 26, 2012
ms sql server enterprise manager
I have a need to create some database and tables on a remote copy of SQL server. (I have been given a password and userid). How do I get a client version of Enterprise Manager? I understand that if I download the 120 day trial of sql server I will get it, but what happens after 120 days? Is there some other free utility for maintaining and creating a database on the hosted SQL Server or do I need to purchase sql 2000 server just to maintain my databases?Someone mentioned to just install the tools from the 120 day package. What will happen to my Enterprise Manager after 120 days??|||Yes it will continue to work after the 120 days, it's the db engine that stops working.
MS SQL Server client under linux/unix.
Hi, everyone!
I was just wondering if any of you knows of a linux/unix client
(preferably on the command line) that would connect to ms sql server?
Any hints would be appreciated!
Roumen.http://www.sommarskog.se/mssqlperl/unix.html
I was just wondering if any of you knows of a linux/unix client
(preferably on the command line) that would connect to ms sql server?
Any hints would be appreciated!
Roumen.http://www.sommarskog.se/mssqlperl/unix.html
--
David Portas
SQL Server MVP
--sql
ms sql server client
probably a very easy question to answer:
which client component do i have to use in order to send queries to a remote sql server and receive the resultset, how can i start this utility?
Hi,
See linked servers in books online. Using Linked servers you could connect
to the remote sql server standing from local sql server.
Only thing is you have to use four part names to refer the table.
Linkedserver.dbname.tableowner.table_name
In otherwise you just want to query a remote server then:-
1. Create a alias server using CLeint network utility
2. Mention TCP IP as protocol , Ip address and port number
3. Using this alis name you could connect to to remote server and query the
remote server using query analyzer or OSQL utility
Thanks
Hari
MCDBA
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
|||If you are trying to connect to one SQL Server but request information from
a different SQL Server, then Hari's answer is what you should do..
If you are asking what software must be installed on any client to connect
to a server... then
For connection using YOUR software, the minimum in Using the SQL Server CD,
install the CLIENT CONNECTIVITY piece.
If , additionally you want tools like query analyzer on your desktop,
install the tools options as well... Most programmers also install Books On
Line as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
which client component do i have to use in order to send queries to a remote sql server and receive the resultset, how can i start this utility?
Hi,
See linked servers in books online. Using Linked servers you could connect
to the remote sql server standing from local sql server.
Only thing is you have to use four part names to refer the table.
Linkedserver.dbname.tableowner.table_name
In otherwise you just want to query a remote server then:-
1. Create a alias server using CLeint network utility
2. Mention TCP IP as protocol , Ip address and port number
3. Using this alis name you could connect to to remote server and query the
remote server using query analyzer or OSQL utility
Thanks
Hari
MCDBA
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
|||If you are trying to connect to one SQL Server but request information from
a different SQL Server, then Hari's answer is what you should do..
If you are asking what software must be installed on any client to connect
to a server... then
For connection using YOUR software, the minimum in Using the SQL Server CD,
install the CLIENT CONNECTIVITY piece.
If , additionally you want tools like query analyzer on your desktop,
install the tools options as well... Most programmers also install Books On
Line as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
ms sql server client
probably a very easy question to answer:
which client component do i have to use in order to send queries to a remote sql server and receive the resultset, how can i start this utility?Hi,
See linked servers in books online. Using Linked servers you could connect
to the remote sql server standing from local sql server.
Only thing is you have to use four part names to refer the table.
Linkedserver.dbname.tableowner.table_name
In otherwise you just want to query a remote server then:-
1. Create a alias server using CLeint network utility
2. Mention TCP IP as protocol , Ip address and port number
3. Using this alis name you could connect to to remote server and query the
remote server using query analyzer or OSQL utility
Thanks
Hari
MCDBA
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?|||If you are trying to connect to one SQL Server but request information from
a different SQL Server, then Hari's answer is what you should do..
If you are asking what software must be installed on any client to connect
to a server... then
For connection using YOUR software, the minimum in Using the SQL Server CD,
install the CLIENT CONNECTIVITY piece.
If , additionally you want tools like query analyzer on your desktop,
install the tools options as well... Most programmers also install Books On
Line as well.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
which client component do i have to use in order to send queries to a remote sql server and receive the resultset, how can i start this utility?Hi,
See linked servers in books online. Using Linked servers you could connect
to the remote sql server standing from local sql server.
Only thing is you have to use four part names to refer the table.
Linkedserver.dbname.tableowner.table_name
In otherwise you just want to query a remote server then:-
1. Create a alias server using CLeint network utility
2. Mention TCP IP as protocol , Ip address and port number
3. Using this alis name you could connect to to remote server and query the
remote server using query analyzer or OSQL utility
Thanks
Hari
MCDBA
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?|||If you are trying to connect to one SQL Server but request information from
a different SQL Server, then Hari's answer is what you should do..
If you are asking what software must be installed on any client to connect
to a server... then
For connection using YOUR software, the minimum in Using the SQL Server CD,
install the CLIENT CONNECTIVITY piece.
If , additionally you want tools like query analyzer on your desktop,
install the tools options as well... Most programmers also install Books On
Line as well.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
ms sql server client
probably a very easy question to answer:
which client component do i have to use in order to send queries to a remote
sql server and receive the resultset, how can i start this utility?Hi,
See linked servers in books online. Using Linked servers you could connect
to the remote sql server standing from local sql server.
Only thing is you have to use four part names to refer the table.
Linkedserver.dbname.tableowner.table_name
In otherwise you just want to query a remote server then:-
1. Create a alias server using CLeint network utility
2. Mention TCP IP as protocol , Ip address and port number
3. Using this alis name you could connect to to remote server and query the
remote server using query analyzer or OSQL utility
Thanks
Hari
MCDBA
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?|||If you are trying to connect to one SQL Server but request information from
a different SQL Server, then Hari's answer is what you should do..
If you are asking what software must be installed on any client to connect
to a server... then
For connection using YOUR software, the minimum in Using the SQL Server CD,
install the CLIENT CONNECTIVITY piece.
If , additionally you want tools like query analyzer on your desktop,
install the tools options as well... Most programmers also install Books On
Line as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
which client component do i have to use in order to send queries to a remote
sql server and receive the resultset, how can i start this utility?Hi,
See linked servers in books online. Using Linked servers you could connect
to the remote sql server standing from local sql server.
Only thing is you have to use four part names to refer the table.
Linkedserver.dbname.tableowner.table_name
In otherwise you just want to query a remote server then:-
1. Create a alias server using CLeint network utility
2. Mention TCP IP as protocol , Ip address and port number
3. Using this alis name you could connect to to remote server and query the
remote server using query analyzer or OSQL utility
Thanks
Hari
MCDBA
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?|||If you are trying to connect to one SQL Server but request information from
a different SQL Server, then Hari's answer is what you should do..
If you are asking what software must be installed on any client to connect
to a server... then
For connection using YOUR software, the minimum in Using the SQL Server CD,
install the CLIENT CONNECTIVITY piece.
If , additionally you want tools like query analyzer on your desktop,
install the tools options as well... Most programmers also install Books On
Line as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cajota" <cajota@.discussions.microsoft.com> wrote in message
news:E9DF0A05-3225-4B3E-BEC3-E52AFD618FE5@.microsoft.com...
> probably a very easy question to answer:
> which client component do i have to use in order to send queries to a
remote sql server and receive the resultset, how can i start this utility?
MS SQL Server 7.0 SP4 on Windows 2003 Server.
My regards for all on this NG!
My client need to use Windows 2003 Server, but it have some databases
and systems that use SQLServer 7.0
I need to know if MS SQL Server 7.0 can be instaled and if will run
with no problems into Windows 2003 Server.
Thanks a lot!!
LucioLucio Chiessi [VORio] (lucio@.vorio.eti.br) writes:
> My regards for all on this NG!
> My client need to use Windows 2003 Server, but it have some databases
> and systems that use SQLServer 7.0
> I need to know if MS SQL Server 7.0 can be instaled and if will run
> with no problems into Windows 2003 Server.
Microsoft does not support SQL 7.0 on Windows 2003. See further
http://support.microsoft.com/defaul...kb;en-us;810391.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks a lot for your response.
We are upgrading to MSDE2K and working fine.
Best Regards...|||Lucio Chiessi [VORio] (lucio@.vorio.eti.br) writes:
> Thanks a lot for your response.
> We are upgrading to MSDE2K and working fine.
Be sure to apply SP3, as this is required for Windows 2003.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Wednesday, March 21, 2012
MS SQL Server 2000 VPN problem
Hi,
I'm using MS SQL Server 2000 from long time and its amazing i got stuck this
time. Here is a scenario:
1. I have a client and i used to connect from VPN to login their network and
i can do then whatever i want except i can connect to their MS SQL Server
from my Enterprise Manager as well.
2. I use Remote Desktop Connection to login to different machine so i went
inside the MS SQL Server and see its working fine. Even it works fine when
users are loggin from their local domain name.
Any suggestions will be apreciated.
Thanks.
What is the exact error you get? How are you trying to connect when you get
it (what tool, what protocol, by IP or Name or Name,port or IP,port)?
From a VPN you might need to specify the port since UDP 1434 might be
blocked for certain types of connections. Or even the SQL Server TCP port
(by default it's 1433 for a default instance, it's dynamic for a named
instance) might be blocked by a firewall.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
Please can you give me steps on how to connect to instance of two SQL Server through VPN.
I shall appricaite it very well.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Yusuf,
test that you can see the server through the SQL tcpip port (default is
1433).
If you're logged on the domain you can use (a) windows authentication,
otherwise you have to use (b) pass-through authentication or (c) sql
standard authentication
Regards,
Paul Ibison
I'm using MS SQL Server 2000 from long time and its amazing i got stuck this
time. Here is a scenario:
1. I have a client and i used to connect from VPN to login their network and
i can do then whatever i want except i can connect to their MS SQL Server
from my Enterprise Manager as well.
2. I use Remote Desktop Connection to login to different machine so i went
inside the MS SQL Server and see its working fine. Even it works fine when
users are loggin from their local domain name.
Any suggestions will be apreciated.
Thanks.
What is the exact error you get? How are you trying to connect when you get
it (what tool, what protocol, by IP or Name or Name,port or IP,port)?
From a VPN you might need to specify the port since UDP 1434 might be
blocked for certain types of connections. Or even the SQL Server TCP port
(by default it's 1433 for a default instance, it's dynamic for a named
instance) might be blocked by a firewall.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
Please can you give me steps on how to connect to instance of two SQL Server through VPN.
I shall appricaite it very well.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Yusuf,
test that you can see the server through the SQL tcpip port (default is
1433).
If you're logged on the domain you can use (a) windows authentication,
otherwise you have to use (b) pass-through authentication or (c) sql
standard authentication
Regards,
Paul Ibison
MS SQL Server 2000 VPN problem
Hi,
I'm using MS SQL Server 2000 from long time and its amazing i got stuck this
time. Here is a scenario:
1. I have a client and i used to connect from VPN to login their network and
i can do then whatever i want except i can connect to their MS SQL Server
from my Enterprise Manager as well.
2. I use Remote Desktop Connection to login to different machine so i went
inside the MS SQL Server and see its working fine. Even it works fine when
users are loggin from their local domain name.
Any suggestions will be apreciated.
Thanks.What is the exact error you get? How are you trying to connect when you get
it (what tool, what protocol, by IP or Name or Name,port or IP,port)?
From a VPN you might need to specify the port since UDP 1434 might be
blocked for certain types of connections. Or even the SQL Server TCP port
(by default it's 1433 for a default instance, it's dynamic for a named
instance) might be blocked by a firewall.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Please can you give me steps on how to connect to instance of two SQL Server
through VPN.
I shall appricaite it very well.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||Yusuf,
test that you can see the server through the SQL tcpip port (default is
1433).
If you're logged on the domain you can use (a) windows authentication,
otherwise you have to use (b) pass-through authentication or (c) sql
standard authentication
Regards,
Paul Ibison
I'm using MS SQL Server 2000 from long time and its amazing i got stuck this
time. Here is a scenario:
1. I have a client and i used to connect from VPN to login their network and
i can do then whatever i want except i can connect to their MS SQL Server
from my Enterprise Manager as well.
2. I use Remote Desktop Connection to login to different machine so i went
inside the MS SQL Server and see its working fine. Even it works fine when
users are loggin from their local domain name.
Any suggestions will be apreciated.
Thanks.What is the exact error you get? How are you trying to connect when you get
it (what tool, what protocol, by IP or Name or Name,port or IP,port)?
From a VPN you might need to specify the port since UDP 1434 might be
blocked for certain types of connections. Or even the SQL Server TCP port
(by default it's 1433 for a default instance, it's dynamic for a named
instance) might be blocked by a firewall.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Please can you give me steps on how to connect to instance of two SQL Server
through VPN.
I shall appricaite it very well.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||Yusuf,
test that you can see the server through the SQL tcpip port (default is
1433).
If you're logged on the domain you can use (a) windows authentication,
otherwise you have to use (b) pass-through authentication or (c) sql
standard authentication
Regards,
Paul Ibison
Monday, March 19, 2012
MS SQL restore
I have a MS SQL database backup from a client and would like to use this to create the database on my local machine.
I have been advised to do this by using restore database in enterprise manager.
I am lost though as I really dont know much about MS SQL - sorry people but can anyone tell me how to do this?Sure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_20h1.asp).
-PatP|||I think they had the database on their D:/ drive and I only have a C: drive
That is whats causing the problem I think.
Any suggestions on how to get round this?
Thanks
Paul|||When restoring in EM, click on Options tab and change the path for every device there.|||and buy a copy of this book...
Inside SQL Server 2000 By Kalen Delaney (http://www.bestwebbuys.com/Inside_Microsoft_SQL_Server_2000-ISBN_0735609985.html?isrc=b-search)
I have been advised to do this by using restore database in enterprise manager.
I am lost though as I really dont know much about MS SQL - sorry people but can anyone tell me how to do this?Sure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_20h1.asp).
-PatP|||I think they had the database on their D:/ drive and I only have a C: drive
That is whats causing the problem I think.
Any suggestions on how to get round this?
Thanks
Paul|||When restoring in EM, click on Options tab and change the path for every device there.|||and buy a copy of this book...
Inside SQL Server 2000 By Kalen Delaney (http://www.bestwebbuys.com/Inside_Microsoft_SQL_Server_2000-ISBN_0735609985.html?isrc=b-search)
Monday, March 12, 2012
MS SQL Express 2005 Client?
hi to all,
newbie to ms sql here. i just installed the free sql express edition and i do not know what i need to access the database...
shouldn't there be a gui somewhere that shows how to create, edit, connect, to a database?
thanks in advance
Download the SQL Server Express Managment Studio: http://msdn.microsoft.com/vstudio/express/sql/download/HTH, jens Suessmeyer.
http://www.sqlserver2005.de|||You can also use the Visual Studio Express Editions to access SQL Server Express if you already have these. Or use sqlcmd 
hi to all,
thanks for the reply.
just finished downloading the 240 mb download!
yep, there is the client gui there.
thanks again!
phil
Friday, March 9, 2012
MS SQL conflicting with other DB Engines.
Hello All,
I work for a company that packages MSDE and MSSQL 8.0 because our software requires storing client information in a database. The problem is that we've found that if the our users have another DB engine installed (BDE or Paradox usually), our program has trouble using MSDE to access the database and thus making our software inaccessible. It behaves as if this other database engine locks on our database before MSDE can. I'm basically looking for help on either how to uninstall these other db engines or how to get around this problem so that both MSSQL and other db engines can co-exist in one system.I'd try to dump the data out of the other database to some type of file then import it in to sql server. Just a thought|||Thanks for the idea garrydawkins but unfortunately that's not an option we have.|||Does SQL Server have to be installed on everyone's desktop? Can it not be installed on a dedicated server, and everyone who uses your software can utilize this single instance?|||depends on the chosen environment, we have the ability to use a machine as a dedicated server, unfortunately, servers are used as servers. If they are serving our product, they are serving the conflicting product. We also have a lot of "stand-Alone" Clients. Not an option here either. Sorry for being difficult. :(|||Wow.. so the Stand-Alone clients, and the distributed clients both require the full install of SQL Server? Sounds overkill for the Stand-Alone. One idea might be to use Access for the Stand-Alone implementations, and SQL Server for the distributed clients. That might require significant recoding of the install, and the app (to execute SQL vs Access specific statements), but it would probably solve the problem.
At the same time, it would reduce the cost of your Stand-Alone version (since they won't have to purchase a commerical SQL Server license), be cheaper for your clients, giving you an edge over your competators.|||I work with Geeneus,
ok, the MSDE (MSDE 2000) is only running on the server, the workstations are not required to be running the server app(sorry about being unclear about this). This in turn, explains why a stand-alone is required to run it as well. Turning the client app to Access is a leap backwards, and not needed. The symptom we are experiencing, is that another database app is grabbing a hold of our database before MSDE can grab it. I suspect BDE (Borland), Paradox, Delphi (also Borland), etc...is just reacting faster and putting a lock on the database even though it is not using it. I know that this BDE can come from many sources, the most common being things like the "Corel" office suite. Anything from Oracle will be using Delphi. Any suggestions?
Xero|||I don't care for Access either, I understand, just trying to think of an option that wouldn't have you writing your own :). Is it possible this other app is running as a service? In which case you could simply disable the process.|||yea, thats my assumption. I am having huge troubles locating the offending app/service. BDE tends to hide. In most cases the MSDE will install. It is when we try to run the configuration scripts to attach the database is when it blows up. Something allready installed has grabbed ahold of it and locked it.|||Good News!!
Reverend managed to figure out how to work around the problem. I'll let him explain it but just wanted to give you all the good news!!|||I have discovered a conflict btween what was called MQIS (MSMQ), and is now Active Directory. This MQIS thing came with early versions of Windows, i.e. Win95, Win98, and NT4. It has an installed backbone of SQL 6.5. If, throughout its lifetime, any of these components have been removed, then this issue can arise. Identification can be made by Start -> Programs -> Startup. I have noticed that the MSDE will show as "Service Manager" and the other instance will be called simply SQL Server. Remove SQl server from startup and run your configuration scripts. viola. Be advised that the next time this client runs any exe that calls for that old SQL Server (app in the case of win9x) it will be reactivated in startup and cause this nightmare again.
Have also seen strange(same) behavior while trying to install the MSDE after the newest version of quickbooks is installed.|||stupid user tricks:Install MSDE to a win98 machine, upgrade to WIN2k or WINXP. Now the database can not be read by the MSDE.
I believe that the MSDE installes as a application, when you roll up to xp or 2k, you suddenly have services and POOF! we get blown out of the water.
anyone had any experience with this and have a workaround/fix?|||Install MDAC 2.7 then uninstall the MSDE. Then reinstall the MSDE, it will now install as a service rather than an application. (This was tested from 98 to XP, 2000 is still unknown) Then run any attach/repair scripts (ours run auto in our installer).
-Frank
I work for a company that packages MSDE and MSSQL 8.0 because our software requires storing client information in a database. The problem is that we've found that if the our users have another DB engine installed (BDE or Paradox usually), our program has trouble using MSDE to access the database and thus making our software inaccessible. It behaves as if this other database engine locks on our database before MSDE can. I'm basically looking for help on either how to uninstall these other db engines or how to get around this problem so that both MSSQL and other db engines can co-exist in one system.I'd try to dump the data out of the other database to some type of file then import it in to sql server. Just a thought|||Thanks for the idea garrydawkins but unfortunately that's not an option we have.|||Does SQL Server have to be installed on everyone's desktop? Can it not be installed on a dedicated server, and everyone who uses your software can utilize this single instance?|||depends on the chosen environment, we have the ability to use a machine as a dedicated server, unfortunately, servers are used as servers. If they are serving our product, they are serving the conflicting product. We also have a lot of "stand-Alone" Clients. Not an option here either. Sorry for being difficult. :(|||Wow.. so the Stand-Alone clients, and the distributed clients both require the full install of SQL Server? Sounds overkill for the Stand-Alone. One idea might be to use Access for the Stand-Alone implementations, and SQL Server for the distributed clients. That might require significant recoding of the install, and the app (to execute SQL vs Access specific statements), but it would probably solve the problem.
At the same time, it would reduce the cost of your Stand-Alone version (since they won't have to purchase a commerical SQL Server license), be cheaper for your clients, giving you an edge over your competators.|||I work with Geeneus,
ok, the MSDE (MSDE 2000) is only running on the server, the workstations are not required to be running the server app(sorry about being unclear about this). This in turn, explains why a stand-alone is required to run it as well. Turning the client app to Access is a leap backwards, and not needed. The symptom we are experiencing, is that another database app is grabbing a hold of our database before MSDE can grab it. I suspect BDE (Borland), Paradox, Delphi (also Borland), etc...is just reacting faster and putting a lock on the database even though it is not using it. I know that this BDE can come from many sources, the most common being things like the "Corel" office suite. Anything from Oracle will be using Delphi. Any suggestions?
Xero|||I don't care for Access either, I understand, just trying to think of an option that wouldn't have you writing your own :). Is it possible this other app is running as a service? In which case you could simply disable the process.|||yea, thats my assumption. I am having huge troubles locating the offending app/service. BDE tends to hide. In most cases the MSDE will install. It is when we try to run the configuration scripts to attach the database is when it blows up. Something allready installed has grabbed ahold of it and locked it.|||Good News!!
Reverend managed to figure out how to work around the problem. I'll let him explain it but just wanted to give you all the good news!!|||I have discovered a conflict btween what was called MQIS (MSMQ), and is now Active Directory. This MQIS thing came with early versions of Windows, i.e. Win95, Win98, and NT4. It has an installed backbone of SQL 6.5. If, throughout its lifetime, any of these components have been removed, then this issue can arise. Identification can be made by Start -> Programs -> Startup. I have noticed that the MSDE will show as "Service Manager" and the other instance will be called simply SQL Server. Remove SQl server from startup and run your configuration scripts. viola. Be advised that the next time this client runs any exe that calls for that old SQL Server (app in the case of win9x) it will be reactivated in startup and cause this nightmare again.
Have also seen strange(same) behavior while trying to install the MSDE after the newest version of quickbooks is installed.|||stupid user tricks:Install MSDE to a win98 machine, upgrade to WIN2k or WINXP. Now the database can not be read by the MSDE.
I believe that the MSDE installes as a application, when you roll up to xp or 2k, you suddenly have services and POOF! we get blown out of the water.
anyone had any experience with this and have a workaround/fix?|||Install MDAC 2.7 then uninstall the MSDE. Then reinstall the MSDE, it will now install as a service rather than an application. (This was tested from 98 to XP, 2000 is still unknown) Then run any attach/repair scripts (ours run auto in our installer).
-Frank
MS SQL client not found for connect to local running server
Hi
I got this error when I try to install SSMAExtPack.exe that is required by SS Migration Assistant.
MS SQL client not found for connect to local running server
I got Sql server 2005 trivial version installed and SS Studio Express on my laptop, everything on one machine. Do I need to install MS SQL client? If so, where and how can I donwload it? Is it free trival version?
Thanks in advanced
Li
When you install SQL Server 2005, SQL Native Client(SNAC) will be installed automatically. Also, MDAC is part of Windows OS. So, you should not have this problem unless the machine is messed up.
|||Hi
Thanks.
Have anyone else got this problem?
|||Yes i got the same problem. And my machine is not messed up.
Got all programs clean installed. VS .NET 2005 SQL Server developer 2005.
All programs working fine. But running SSMAExtPack.exe returns the described error.
|||Moving to tools, hope somebody knows what the issue is.|||Have you chosen to install client tools when Evaluation edition is select to install?|||
Satya SKJ wrote:
Have you chosen to install client tools when Evaluation edition is select to install?
Hi,
When i install development software, i always do a full install, to prevent things from missing.
I do not run any evaluation software, but fully registered software. In order to resolve this
problem i tried to download and install the SQL Client components from Microsoft with no
result. The setup told me if i wanted to remove or repair the current installation, so my initial
installation was successfull. Tried selecting the repaire option did not do the trick.
Rgrds,
Chris
MS SQL client not found for connect to local running server
Hi
I got this error when I try to install SSMAExtPack.exe that is required by SS Migration Assistant.
MS SQL client not found for connect to local running server
I got Sql server 2005 trivial version installed and SS Studio Express on my laptop, everything on one machine. Do I need to install MS SQL client? If so, where and how can I donwload it? Is it free trival version?
Thanks in advanced
Li
When you install SQL Server 2005, SQL Native Client(SNAC) will be installed automatically. Also, MDAC is part of Windows OS. So, you should not have this problem unless the machine is messed up.
|||Hi
Thanks.
Have anyone else got this problem?
|||Yes i got the same problem. And my machine is not messed up.
Got all programs clean installed. VS .NET 2005 SQL Server developer 2005.
All programs working fine. But running SSMAExtPack.exe returns the described error.
|||Moving to tools, hope somebody knows what the issue is.|||Have you chosen to install client tools when Evaluation edition is select to install?|||
Have you chosen to install client tools when Evaluation edition is select to install?
Hi,
When i install development software, i always do a full install, to prevent things from missing.
I do not run any evaluation software, but fully registered software. In order to resolve this
problem i tried to download and install the SQL Client components from Microsoft with no
result. The setup told me if i wanted to remove or repair the current installation, so my initial
installation was successfull. Tried selecting the repaire option did not do the trick.
Rgrds,
Chris
MS SQL and Sybase SQL conflict
has anyone had sucess in troubleshooting conflicts between these two?
I need to shut down the sybase client on a machine that is running MS SQL if thats possible.They generally co-exist rather peacefully once you get them settled down. The newcomer always seems to ruffle the feathers of the established resident on any given machine, but they can learn to live in peace in most circumstances.
What kind of problems are you having?
-PatP|||We're trying to install MS SQL on a machine that only has the Sybase SQL client (not the server) and it throws an error during the MS SQL install saying that it cannot find odbcbcp.dll.
So i'm wondering if shutting down the Sybase SQL client will make that dll file available/usable.|||BCP is one of few facilities common to both engines. Make sure that any Sybase-related services are shut down before you start the install.
I need to shut down the sybase client on a machine that is running MS SQL if thats possible.They generally co-exist rather peacefully once you get them settled down. The newcomer always seems to ruffle the feathers of the established resident on any given machine, but they can learn to live in peace in most circumstances.
What kind of problems are you having?
-PatP|||We're trying to install MS SQL on a machine that only has the Sybase SQL client (not the server) and it throws an error during the MS SQL install saying that it cannot find odbcbcp.dll.
So i'm wondering if shutting down the Sybase SQL client will make that dll file available/usable.|||BCP is one of few facilities common to both engines. Make sure that any Sybase-related services are shut down before you start the install.
Wednesday, March 7, 2012
MS SQL 6 yes 6
Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
We have a 6 running that can't be upgraded and now it's in need of some TLC.
Mike
It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA
|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. But EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL 6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>
|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business. I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
We have a 6 running that can't be upgraded and now it's in need of some TLC.
Mike
It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA
|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. But EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL 6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>
|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business. I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Subscribe to:
Posts (Atom)