SQL Alert: February 2012

Saturday, February 25, 2012

Access SQL Server from SOLARIS.

Hi All,
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
ThanksHello Retf,
Microsoft don't supply their own drivers for non-Windows based clients any
longer, so you have to use a 3rd-party product.
To connect to SQL Server from SOLARIS, there are other third party ODBC
drivers for Solaris; and of course, the JDBC driver for SQL Server.
Your choices (in no particular order) are :
1. You could reverse engineer the undocumented TDS protocol yourself.
This
could and does change between versions of SQL Server, so only attempt this
if
you want an on-going maintenance challenge. Several people have done such
reverse engineering for the portions of TDS they needed and have reported
it's
not that difficult. Once such is the FreeTDS project that is reverse
engineering the TDS specification and is currently implementing CTLIB,
DBLIB,
and JDBC interfaces for TDS. ODBC and PERL DBD drivers are planned.
The FreeTDS JDBC driver is a type 4 driver and should work on any JVM. The
CTLIB and DBLIB interfaces are known to compile under AIX, Linux, and
FreeBSD
without any problems. More info from <http://sunsite.unc.edu/freetds/>
and/or
<http://metalab.unc.edu/freetds/index.html>.
The mailing list archive can be viewed at
<http://franklin.oit.unc.edu/cgi-bin...l?enter=freetds>. Source-code
can be
downloaded from <ftp://freetds.internetcds.com/pub/freetds_dbd/>
<http://metalab.unc.edu/freetds/index.html>
2. If you can use Java/JDBC then see the "jdbc.txt" FAQ entry for details
of
that
3. The recommended option is that you acquire an ODBC/OLE-DB driver from a
driver vendor that will offer on-going support. However, many ODBC vendors
have either moved from pure client drivers to "3-tier" driver systems which
many people don't want, or they have moved from ODBC into OLE-DB.
Therefore
you may have trouble finding just what you want. (Success and failure
stories
welcome - but be persistent with whichever vendors you talk to - they may
not
be actively advertising what you want, but that doesn't mean they don't
still
have old but working copies of it buried in a cupboard somewhere).
Vendors to try are (in no particular order) :-
OpenLink www.openlinksw.com <http://www.openlinksw.com>
Merant (were Intersolv
<http://www.merant.com/datadirect/pr...ct/overview.asp>
Visigenic www.visigenic.com <http://www.visigenic.com>
Easysoft www.easysoft.com <http://www.easysoft.com>
(ODBC-ODBC
Bridge)
Applix corp.
4. For other pointers to ODBC/JDBC/OLEDB vendor's :-
<http://ourworld.compuserve.com/home...th/odbcvend.htm>
<http://ourworld.compuserve.com/home...th/jdbcvend.htm>
<http://ourworld.compuserve.com/home...th/oledbven.htm>
<http://www.unixodbc.org>
<http://www.algonet.se/~sommar/mssqlperl/unix.html>
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Im searcheing for 3rdparty component that make it possible, tahnks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escreveu na mensagem
news:LvO%23AF%23XHHA.296@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Access SQL server from AS/400 DB2

Hi everyone,
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!Hi Farmer,
From your descriptions, I understood that you would like to use SQL Server
as "Linked Server" in AS/400 DB2. Have I understood you? Correct me if I
was wrong.
Based on my scope, unfortuantely, SQL Server has no such funcationality to
do this. Anyway, I will do more research try to find whether IBM DB2 will
provide such funcaitonality. Please understand that I have rather limited
DB2 knowledge

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Farmer,
Thanks for your patience and corperation!
I searched in the DB2 forum and here is the link I used with search key,
connect sql server. It seems there are many useful information there and
hope it helps
http://www-106.ibm.com/developerwor...arch=true&cat=2
4&forum=339&q=connect+sql+server&forums=cid19&Go.x=12&Go.y=9
Moreover, don't hesitate to let me know whether there is anything I could
do to help on SQL Server side.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Access SQL server from AS/400 DB2

Hi everyone,
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!
Hi Farmer,
From your descriptions, I understood that you would like to use SQL Server
as "Linked Server" in AS/400 DB2. Have I understood you? Correct me if I
was wrong.
Based on my scope, unfortuantely, SQL Server has no such funcationality to
do this. Anyway, I will do more research try to find whether IBM DB2 will
provide such funcaitonality. Please understand that I have rather limited
DB2 knowledge

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Farmer,
Thanks for your patience and corperation!
I searched in the DB2 forum and here is the link I used with search key,
connect sql server. It seems there are many useful information there and
hope it helps
http://www-106.ibm.com/developerwork...rch=true&cat=2
4&forum=339&q=connect+sql+server&forums=cid19&Go.x =12&Go.y=9
Moreover, don't hesitate to let me know whether there is anything I could
do to help on SQL Server side.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

access SQL Server from application

Hi,

I have recently transfered data from MS Access to MS SQL Server 2000 and created user interface in MS Access Project (ADP). Now I need to secure the data on server and want to access it ONLY through interface I created in MS Access. Every user has to log in the application (user id and password). Users may have the same access rights to the server (so maybe just one account or whatever I need for all of them). Can anyone advice me how to set it up? To access sql server from MS Access I am using ADO.

Thank you.
djLookup "Application Roles" in Books Online.

But be aware that it is better practice to limit your to establish security at the data level than the application level. Establishing Application Roles is no substitute for making sure that your database is locked down.|||Yes, I agree. I have no experience with SQL Server. In MS Access it was easy. So, how to lock down database. What I should create there to secure data? Any password? And then I need to access data through ADO. There is connection string where I have to pass a password.

Could you help me to clarify that.
Thanks
dj

Access SQL Server Behind Firewall

Web Services
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151082261.350657.124850@.m73g2000cwd.googlegroups.com...
>I have an SQL server that resides on my local LAN. My local LAN is
> behind a firewall that we do not maintain. We have been told that we
> cannot have any additional ports opened on the firewall, meaning that
> the ports used by SQL server are and will remain closed.
> My dilemma is that I need to provide people outside my company view
> only access, via our internet site, to data that is on my local SQL
> server. My web server resides on a public network that is outside my
> firewall. Is there a way that this can be done without opening the
> ports on the firewall?
>Arnie Rowland wrote:
> Web Services
>
Can you be a little more specific? Your answer doesn't really help as
is.|||Web Services, by design (and definition) use port 80 (http). Almost all
firewalls have port 80 open. Web Services are normally 'inside' the firewall
running on a web server (IIS).
With Visual Studio, you can create one or more web services (applications
that run on an IIS server). The web service receives a http post from the
web application, and then the web service retrieves the data from SQL Server
and passes it back to the web application in the response.
Also, SQL 2005 has the capability to host stored procedures as web services.
However, this should only be done when one is in complete understanding of
the security issues.
This is a lengthy and complicated discussion, inappropriate for this forum.
I suggest that you investigate Web Services in Visual Studio. Here is a
place to start.
http://msdn.microsoft.com/webservices/
Good luck.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151082723.343995.161530@.g10g2000cwb.googlegroups.com...
> Arnie Rowland wrote:
> Can you be a little more specific? Your answer doesn't really help as
> is.
>|||I have an SQL server that resides on my local LAN. My local LAN is
behind a firewall that we do not maintain. We have been told that we
cannot have any additional ports opened on the firewall, meaning that
the ports used by SQL server are and will remain closed.
My dilemma is that I need to provide people outside my company view
only access, via our internet site, to data that is on my local SQL
server. My web server resides on a public network that is outside my
firewall. Is there a way that this can be done without opening the
ports on the firewall?|||Web Services
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151082261.350657.124850@.m73g2000cwd.googlegroups.com...
>I have an SQL server that resides on my local LAN. My local LAN is
> behind a firewall that we do not maintain. We have been told that we
> cannot have any additional ports opened on the firewall, meaning that
> the ports used by SQL server are and will remain closed.
> My dilemma is that I need to provide people outside my company view
> only access, via our internet site, to data that is on my local SQL
> server. My web server resides on a public network that is outside my
> firewall. Is there a way that this can be done without opening the
> ports on the firewall?
>|||Arnie Rowland wrote:
> Web Services
>
Can you be a little more specific? Your answer doesn't really help as
is.|||Web Services, by design (and definition) use port 80 (http). Almost all
firewalls have port 80 open. Web Services are normally 'inside' the firewall
running on a web server (IIS).
With Visual Studio, you can create one or more web services (applications
that run on an IIS server). The web service receives a http post from the
web application, and then the web service retrieves the data from SQL Server
and passes it back to the web application in the response.
Also, SQL 2005 has the capability to host stored procedures as web services.
However, this should only be done when one is in complete understanding of
the security issues.
This is a lengthy and complicated discussion, inappropriate for this forum.
I suggest that you investigate Web Services in Visual Studio. Here is a
place to start.
http://msdn.microsoft.com/webservices/
Good luck.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151082723.343995.161530@.g10g2000cwb.googlegroups.com...
> Arnie Rowland wrote:
> Can you be a little more specific? Your answer doesn't really help as
> is.
>|||It is my understanding that to do this we will need to upgrade to SQL
2005 and Visual Studio 2005. Our application is running on SQL 2000
and was written in Visual Studio 6 and is not easily rewirtable.
Arnie Rowland wrote:
> Web Services, by design (and definition) use port 80 (http). Almost all
> firewalls have port 80 open. Web Services are normally 'inside' the firewa
ll
> running on a web server (IIS).
> With Visual Studio, you can create one or more web services (applications
> that run on an IIS server). The web service receives a http post from the
> web application, and then the web service retrieves the data from SQL Serv
er
> and passes it back to the web application in the response.
> Also, SQL 2005 has the capability to host stored procedures as web service
s.
> However, this should only be done when one is in complete understanding of
> the security issues.
> This is a lengthy and complicated discussion, inappropriate for this forum
.
> I suggest that you investigate Web Services in Visual Studio. Here is a
> place to start.
> http://msdn.microsoft.com/webservices/
> Good luck.|||.NET Web Services can access data in any ADO.NET datastore -including SQL
Server 2000, Oracle, Exchange, Access, Excel files, etc..
You can create .NET Web Services using Visual Notepad -however Visual Studio
makes it easier.
SQL Server 2005 is not necessary for Web Services.
IIS and the .NET framework on the IIS server (and the development boxes) is
required.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151088102.639755.88150@.c74g2000cwc.googlegroups.com...
> It is my understanding that to do this we will need to upgrade to SQL
> 2005 and Visual Studio 2005. Our application is running on SQL 2000
> and was written in Visual Studio 6 and is not easily rewirtable.
> Arnie Rowland wrote:
>|||And this will work if my outside IIS server is unable to access my LAN?
I am told that we can go from inside out but not outside in.

Access SQL Server Behind Firewall

I have an SQL server that resides on my local LAN. My local LAN is
behind a firewall that we do not maintain. We have been told that we
cannot have any additional ports opened on the firewall, meaning that
the ports used by SQL server are and will remain closed.
My dilemma is that I need to provide people outside my company view
only access, via our internet site, to data that is on my local SQL
server. My web server resides on a public network that is outside my
firewall. Is there a way that this can be done without opening the
ports on the firewall?Web Services
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151082261.350657.124850@.m73g2000cwd.googlegroups.com...
>I have an SQL server that resides on my local LAN. My local LAN is
> behind a firewall that we do not maintain. We have been told that we
> cannot have any additional ports opened on the firewall, meaning that
> the ports used by SQL server are and will remain closed.
> My dilemma is that I need to provide people outside my company view
> only access, via our internet site, to data that is on my local SQL
> server. My web server resides on a public network that is outside my
> firewall. Is there a way that this can be done without opening the
> ports on the firewall?
>|||Arnie Rowland wrote:
> Web Services
>
Can you be a little more specific? Your answer doesn't really help as
is.|||Web Services, by design (and definition) use port 80 (http). Almost all
firewalls have port 80 open. Web Services are normally 'inside' the firewall
running on a web server (IIS).
With Visual Studio, you can create one or more web services (applications
that run on an IIS server). The web service receives a http post from the
web application, and then the web service retrieves the data from SQL Server
and passes it back to the web application in the response.
Also, SQL 2005 has the capability to host stored procedures as web services.
However, this should only be done when one is in complete understanding of
the security issues.
This is a lengthy and complicated discussion, inappropriate for this forum.
I suggest that you investigate Web Services in Visual Studio. Here is a
place to start.
http://msdn.microsoft.com/webservices/
Good luck.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151082723.343995.161530@.g10g2000cwb.googlegroups.com...
> Arnie Rowland wrote:
>> Web Services
> Can you be a little more specific? Your answer doesn't really help as
> is.
>|||It is my understanding that to do this we will need to upgrade to SQL
2005 and Visual Studio 2005. Our application is running on SQL 2000
and was written in Visual Studio 6 and is not easily rewirtable.
Arnie Rowland wrote:
> Web Services, by design (and definition) use port 80 (http). Almost all
> firewalls have port 80 open. Web Services are normally 'inside' the firewall
> running on a web server (IIS).
> With Visual Studio, you can create one or more web services (applications
> that run on an IIS server). The web service receives a http post from the
> web application, and then the web service retrieves the data from SQL Server
> and passes it back to the web application in the response.
> Also, SQL 2005 has the capability to host stored procedures as web services.
> However, this should only be done when one is in complete understanding of
> the security issues.
> This is a lengthy and complicated discussion, inappropriate for this forum.
> I suggest that you investigate Web Services in Visual Studio. Here is a
> place to start.
> http://msdn.microsoft.com/webservices/
> Good luck.|||.NET Web Services can access data in any ADO.NET datastore -including SQL
Server 2000, Oracle, Exchange, Access, Excel files, etc..
You can create .NET Web Services using Visual Notepad -however Visual Studio
makes it easier.
SQL Server 2005 is not necessary for Web Services.
IIS and the .NET framework on the IIS server (and the development boxes) is
required.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151088102.639755.88150@.c74g2000cwc.googlegroups.com...
> It is my understanding that to do this we will need to upgrade to SQL
> 2005 and Visual Studio 2005. Our application is running on SQL 2000
> and was written in Visual Studio 6 and is not easily rewirtable.
> Arnie Rowland wrote:
>> Web Services, by design (and definition) use port 80 (http). Almost all
>> firewalls have port 80 open. Web Services are normally 'inside' the
>> firewall
>> running on a web server (IIS).
>> With Visual Studio, you can create one or more web services (applications
>> that run on an IIS server). The web service receives a http post from the
>> web application, and then the web service retrieves the data from SQL
>> Server
>> and passes it back to the web application in the response.
>> Also, SQL 2005 has the capability to host stored procedures as web
>> services.
>> However, this should only be done when one is in complete understanding
>> of
>> the security issues.
>> This is a lengthy and complicated discussion, inappropriate for this
>> forum.
>> I suggest that you investigate Web Services in Visual Studio. Here is a
>> place to start.
>> http://msdn.microsoft.com/webservices/
>> Good luck.
>|||And this will work if my outside IIS server is unable to access my LAN?
I am told that we can go from inside out but not outside in.|||harel.davidm@.gmail.com wrote:
> And this will work if my outside IIS server is unable to access my LAN?
> I am told that we can go from inside out but not outside in.
>
You really need to read more about web services and understand them,
you're missing the point. The web service would run on an IIS instance
INSIDE YOUR FIREWALL. The IIS instance that sits outside the firewall
would talk to the web services running on the IIS instance inside the
firewall, using it as a sort of proxy to get data from your SQL Server
machine. The web services will NOT run on the IIS instance outside the
firewall, therefore it doesn't matter if that machine can see the SQL
Server machine.|||Tracy McKibben wrote:
> harel.davidm@.gmail.com wrote:
> > And this will work if my outside IIS server is unable to access my LAN?
> > I am told that we can go from inside out but not outside in.
> >
> You really need to read more about web services and understand them,
> you're missing the point. The web service would run on an IIS instance
> INSIDE YOUR FIREWALL. The IIS instance that sits outside the firewall
> would talk to the web services running on the IIS instance inside the
> firewall, using it as a sort of proxy to get data from your SQL Server
> machine. The web services will NOT run on the IIS instance outside the
> firewall, therefore it doesn't matter if that machine can see the SQL
> Server machine.
Maybe I am missing the point, but isn't that what these forums are for?
I asked a simple question, at least to me. I am not a
developer/programmer so allot of this is new to me. I am more of the
technical/hardware person here. I was just relaying the information I
was given by those who maintain the firewall. Regardless of how Web
Services works, the information I detailed is what I was told. I am
simply looking for a preferred means of providing information on my
Internet site..|||Bottom line.
With your current situation, you are not going to be able to provide any
data from SQL Server to the web server outside the firewall without opening
ports in the firewall for the web server to use to connect with the SQL
Server.
If you cannot open any ports, Web Services is an option. However, web
services will require significant programming expertise and can, if not
implimented correctly, have serious data security issues. It sounds like
that option is also not available for you.
If your web host provides any database support, you could 'manually' upload
data extracted from your SQL Server. If not, then you could manually upload
datafiles as csv, Access, etc. However, that presents severe maintenance and
latency issues. And then there is not a way to capture user interaction from
the web site and send it back to your database server. But it may be the
only option for you to explore.
You asked a 'simple' question. The question, and its followups, received
clear and informative -though complex responses. You have been directed to a
source of additional information.
I don't know how else we can help you.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
<harel.davidm@.gmail.com> wrote in message
news:1151093318.784026.187460@.y41g2000cwy.googlegroups.com...
> Tracy McKibben wrote:
>> harel.davidm@.gmail.com wrote:
>> > And this will work if my outside IIS server is unable to access my LAN?
>> > I am told that we can go from inside out but not outside in.
>> >
>> You really need to read more about web services and understand them,
>> you're missing the point. The web service would run on an IIS instance
>> INSIDE YOUR FIREWALL. The IIS instance that sits outside the firewall
>> would talk to the web services running on the IIS instance inside the
>> firewall, using it as a sort of proxy to get data from your SQL Server
>> machine. The web services will NOT run on the IIS instance outside the
>> firewall, therefore it doesn't matter if that machine can see the SQL
>> Server machine.
> Maybe I am missing the point, but isn't that what these forums are for?
> I asked a simple question, at least to me. I am not a
> developer/programmer so allot of this is new to me. I am more of the
> technical/hardware person here. I was just relaying the information I
> was given by those who maintain the firewall. Regardless of how Web
> Services works, the information I detailed is what I was told. I am
> simply looking for a preferred means of providing information on my
> Internet site..
>|||harel.davidm@.gmail.com wrote:
> Maybe I am missing the point, but isn't that what these forums are for?
> I asked a simple question, at least to me. I am not a
> developer/programmer so allot of this is new to me. I am more of the
> technical/hardware person here. I was just relaying the information I
> was given by those who maintain the firewall. Regardless of how Web
> Services works, the information I detailed is what I was told. I am
> simply looking for a preferred means of providing information on my
> Internet site..
>
The preferred means is to have your database server and web server
within close proximity, either living together within a DMZ, or the web
server in DMZ, data behind the internal firewall with a port opened.
What you're attempting to do is connect a web server that lives outside
of your environment to a database server inside your environment, but
you don't want to open a hole for it to talk through. It should be a
trivial thing for your network guy to open a port to the SQL machine,
and configure a rule to allow ONLY the IP of the web server to connect
to it. Put SQL on a non-default port, open that port up, and secure it
with a rule, you should be just fine.
I wasn't attacking you. Your question is not a simple one. You were
given a recommendation of using web services, I was merely suggesting
that you research them a bit further before discounting them or asking
further questions.
Good luck...

Access sql server behide firewall?

How do I access a sql server behide an ISA server? What are the steps requir
ed to access via query analyzer from the internet?Have you looked at this article:
HOWTO: Configure ISA Server 2000 and Enterprise Manager to Connect Through
ISA to a SQL Server
http://support.microsoft.com/defaul...kb;en-us;299673
Rand
This posting is provided "as is" with no warranties and confers no rights.

Access sql server behide firewall?

How do I access a sql server behide an isa server? What are the steps required to access via query analyzer from the internet?
Have you looked at this article:
HOWTO: Configure ISA Server 2000 and Enterprise Manager to Connect Through
ISA to a SQL Server
http://support.microsoft.com/default...b;en-us;299673
Rand
This posting is provided "as is" with no warranties and confers no rights.

access sql server across domain thru windows authentication

Hi,
I have a sql server in a domain which is different than the one I log into,
and thats server has Windows authenticatrion, I have a domain account in the domain where sql is running, now how do I provide that domain acc info en EM to connect to that sql server. If I just select windows authenication while registering that server it gives me Cannot generate SSPI context error.

Any help will be appricaited.

Tia,
ParthYou can not do this from EM, as far as I know!
Or if you can, I would like to know that, too.

Best regards!

Access SQL Server 2005 via HTTP

Is it possible to access sql server 2005 via http and do some management and administration task?

Thanks in advance,

Larry

I believe that there may be a web based admin tool in development. Otherwise, your only good options are third party products or VPN.

access sql server 2005 via http

Is it possible to access sql server 2005 via http and do some management and administration task? if possible how?

Thanks in advance,

Larry

Hi larry,

I suggest you configure a windows 2000 or 2003 VPN or cisco VPN
to actually access the Sql server box via http
this is i think more secure.

You can however access sql server via SQL server Endpoint
but i suggest you do configure a VPN
since it is more secure

regards,
joey|||

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en closely related to SQL 2000 or MSDE, but you are looking for SQL 2005 instance so as suggested endpoings are good to go, http://www.developer.com/db/article.php/3390241 and http://davidhayden.com/blog/dave/archive/2006/03/31/2897.aspxfyi..

http://codebetter.com/blogs/raymond.lewallen/archive/2005/06/23/65089.aspx tooq

Access SQL Server 2005 from C++ programs in UNIX/LINUX

Hi,

Is there as way to access SQL SErver DB for DML Operations from C++ programs in UNIX/LINUX. The current approach is by uisng Pro C to connect to ORACLE from C++. But I want to connect to SQL Server 2005.

Regards,

Kart

The best approach here is to convert the application to use ODBC rather than Embedded SQL and access SQL Server via one of the 3rd party ODBC drivers for SQL Server, such as Data Direct ( http://www.datadirect.com/products/odbc/index.ssp )

Access Sql server 2005 from .net class library

I have Sql server 2005 running on a workgroup server and wish to access the
data from another workgroup server using direct sql access (ie not ODBC). Th
e
code to access the data is written in visual studio 2005 and is within a
class library DLL. I wish to use Windows Authentication between the two
servers, but am not clear how to set the user within the code. Do I need to
use Component Services (ie MTS) to do this?Just use regular connection string for Windows Authentication, you can find
the syntax at www.connectionstrings.com. Since you are in a workgroup, you
may have to use a mirrored account (same username/password on both
computers).
Roman
Roman Rehak
http://sqlblog.com/blogs/roman_rehak
"lankylad" <lankylad@.discussions.microsoft.com> wrote in message
news:F4F155F9-1D2E-449F-A5FF-5FCD24CF1025@.microsoft.com...
>I have Sql server 2005 running on a workgroup server and wish to access the
> data from another workgroup server using direct sql access (ie not ODBC).
> The
> code to access the data is written in visual studio 2005 and is within a
> class library DLL. I wish to use Windows Authentication between the two
> servers, but am not clear how to set the user within the code. Do I need
> to
> use Component Services (ie MTS) to do this?|||No need for COM+/MTS. The important thing here is that the class library
has the capability to accept connection string parameters and switch them
when necessary. Refer to the Enterprise Application Block, particularly the
Dta Access Application Block for samples. As Roman mentioned, since you are
in a workgroup environment, mixed mode authentication is a bit simpler for
this - create the same account on both server and assign permissions for the
necessary securables
"Roman Rehak" <rrehak@.hotmail.com> wrote in message
news:%23peB3KqwHHA.4628@.TK2MSFTNGP02.phx.gbl...
> Just use regular connection string for Windows Authentication, you can
> find the syntax at www.connectionstrings.com. Since you are in a
> workgroup, you may have to use a mirrored account (same username/password
> on both computers).
> Roman
> --
> Roman Rehak
> http://sqlblog.com/blogs/roman_rehak
>
> "lankylad" <lankylad@.discussions.microsoft.com> wrote in message
> news:F4F155F9-1D2E-449F-A5FF-5FCD24CF1025@.microsoft.com...
>|||Thanks both.
www.connectionstrings.com shows that the format for a Trusted Connection in
SQLConnection (.NET) is:
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated
Security=SSPI;
Do I just add a "User Id" entry to the end of that?
"bass_player [SBS-MVP]" wrote:

> No need for COM+/MTS. The important thing here is that the class library
> has the capability to accept connection string parameters and switch them
> when necessary. Refer to the Enterprise Application Block, particularly th
e
> Dta Access Application Block for samples. As Roman mentioned, since you a
re
> in a workgroup environment, mixed mode authentication is a bit simpler for
> this - create the same account on both server and assign permissions for t
he
> necessary securables
>
> "Roman Rehak" <rrehak@.hotmail.com> wrote in message
> news:%23peB3KqwHHA.4628@.TK2MSFTNGP02.phx.gbl...
>
>|||lankylad (lankylad@.discussions.microsoft.com) writes:
> www.connectionstrings.com shows that the format for a Trusted Connection
> in SQLConnection (.NET) is:
> Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated
> Security=SSPI;
> Do I just add a "User Id" entry to the end of that?
No. User Id is for SQL Authentication. When you use Windows Authentication,
the presumption is that you are already logged into Windows. And if you
are logged in as MACHINE1\USER1, you cannot log into SQL Server as
MACHINE2\USER2, you can only connect to SQL Server with the Windows
user you are logged in as.
Note that to get Windows Authentication to work in a workgroup, you
need to take some precautions. First, the usernamd and password must be
the same on the two machines. Next, run gpedit.msc, and check
Computer Cnofiguration->Windows Settings->Security Settings->
Local Policies->Security Options->Network access: Sharing and Security
model for local accounts. This needs to be set to Classic for the scheme
to work.
Given all this trickery, SQL authentication may be a better option in a
workgroup.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks.
Since I'm writing the data access code in a Class Library DLL does that when
I'm using the class from a web application I have to use Anonymous login and
have that user set up on my sqlserver server with the same password?
"Erland Sommarskog" wrote:

> lankylad (lankylad@.discussions.microsoft.com) writes:
> No. User Id is for SQL Authentication. When you use Windows Authentication
,
> the presumption is that you are already logged into Windows. And if you
> are logged in as MACHINE1\USER1, you cannot log into SQL Server as
> MACHINE2\USER2, you can only connect to SQL Server with the Windows
> user you are logged in as.
> Note that to get Windows Authentication to work in a workgroup, you
> need to take some precautions. First, the usernamd and password must be
> the same on the two machines. Next, run gpedit.msc, and check
> Computer Cnofiguration->Windows Settings->Security Settings->
> Local Policies->Security Options->Network access: Sharing and Security
> model for local accounts. This needs to be set to Classic for the scheme
> to work.
> Given all this trickery, SQL authentication may be a better option in a
> workgroup.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||lankylad (lankylad@.discussions.microsoft.com) writes:
> Since I'm writing the data access code in a Class Library DLL does that
> when I'm using the class from a web application I have to use Anonymous
> login and have that user set up on my sqlserver server with the same
> password?
Web servers are not my area, but I guess that if you use integrated
security from a web server, then the Windows login under which the
web server runs is what will count. But it may be that an SQL login
is better in this case.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||All the advice from Microsoft seems to be to avoid mixed authentication, so
I
have been trying to use only Windows Authentication.
"Erland Sommarskog" wrote:

> lankylad (lankylad@.discussions.microsoft.com) writes:
> Web servers are not my area, but I guess that if you use integrated
> security from a web server, then the Windows login under which the
> web server runs is what will count. But it may be that an SQL login
> is better in this case.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||lankylad (lankylad@.discussions.microsoft.com) writes:
> All the advice from Microsoft seems to be to avoid mixed authentication,
> so I have been trying to use only Windows Authentication.
I was involved in a thread recently, where people with more experience than
me of ASP .Net appeared to say that SQL Authentication is the way to. See
65" target="_blank">http://groups.google.com/group/micr...48400
65
SQL authentication on SQL 2000 has a couple of problems. The password is
passed only lightly masked, and there is no protection against brute force
attacks. SQL 2005 on Win 2003 is better protected against the latter.
But you should not expose SQL Server on the Internet if possible.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Access SQL Server 2005 database using a published website

Hi all,

I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as

/Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx

the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :-

xmlversion="1.0"?>

configuration>

appSettings/>

connectionStrings/>

system.web>

compilationdebug="true"/>

authenticationmode="Windows"/>

system.web>

configuration>

Am I missing something? Ieven have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator.... I appreciate your suggestions.

Thanks,

Kavya

Can you post your connection string as well as SQL commands? Can you connect to the SQL Server from the machine (on which you can access the published website) via Management Studio?

access sql server 2000

I am new to using .net. I am told that I need to setup a config file that
will be accessed by a VB.net dll. This vb.net dll will be setup to run every
5 to 10 minutes by a timer that is coded into the vb.net application.
A user will submit a request to obtain data from a HP mainframe.
This web config file needs to be able to do the following:
1. The user will submit the request to a sql server 2000 database (that
resides on a different that where the vb.net application will be running).
2.. The vb.net code will that submit the request for data to the hp
mainframe by using http and xml.
Thus my questions are:
1. How do you setup a connection and retrieve data from the sql server 2000
database that resides with the company's intranet? This will somehow need to
include a connection object and statements oh how to connect to the SQL
server 2000 database. The user name and password are suppose to be passed to
the sql server as part of the connection string.
2. How would I request to the HP mainframe using soap, http, and xml to wrap
up the request?
Thanks!Regarding the SQL Server part of your question, you can use System.Data
SqlConnection and SqlCommand objects to connect to SQL Server and execute
queries. The results can then be retrieved using a SqlDataAdapter
(disconnected) or SqlDataReader (connected).
The example below shows how you can accomplish the task using a
parameteritized SELECT statement. You can find details and many examples in
the Visual Studio reference.
Try
'Create connection
Dim conn As New SqlConnection( _
"Data Source=MyServer;Integrated Security=SSPI;Initial
Catalog=MyDatabase")
'Create command
Dim cmd As New SqlCommand( _
"SELECT MyData FROM MyTable WHERE MyKey = @.MyKey", conn)
cmd.CommandType = CommandType.Text
'Create input paramater for command
cmd.Parameters.Add("@.MyKey", SqlDbType.Int)
cmd.Parameters("@.MyKey").Direction = ParameterDirection.Input
cmd.Parameters("@.MyKey").Value = 1
cmd.Connection.Open()
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable
da.Fill(dt)
'process dt DataTable here
conn.Close()
Catch ex As SqlExcelption
'exception handling here
End Try
Hope this helps.
Dan Guzman
SQL Server MVP
"Wendy Elizabeth" <WendyElizabeth@.discussions.microsoft.com> wrote in
message news:1693FA1F-8530-4F22-B4D8-EBA89881C8B5@.microsoft.com...
>I am new to using .net. I am told that I need to setup a config file that
> will be accessed by a VB.net dll. This vb.net dll will be setup to run
> every
> 5 to 10 minutes by a timer that is coded into the vb.net application.
> A user will submit a request to obtain data from a HP mainframe.
> This web config file needs to be able to do the following:
> 1. The user will submit the request to a sql server 2000 database (that
> resides on a different that where the vb.net application will be running).
> 2.. The vb.net code will that submit the request for data to the hp
> mainframe by using http and xml.
> Thus my questions are:
> 1. How do you setup a connection and retrieve data from the sql server
> 2000
> database that resides with the company's intranet? This will somehow need
> to
> include a connection object and statements oh how to connect to the SQL
> server 2000 database. The user name and password are suppose to be passed
> to
> the sql server as part of the connection string.
> 2. How would I request to the HP mainframe using soap, http, and xml to
> wrap
> up the request?
> Thanks!

Access SQL problems using MS Jet OLEDB with ADO+VB6

Hi there. I am having trouble with querying a record set by date range using the Between operator. Im using VB 6 with ADO.

Referenced: Microsoft ActiveX Data Objects 2.8 Library

Connection String: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\localdata\orders.mdb;Persist Security Info=False"

SQL Query used: "SELECT * FROM tbl_orders WHERE (InsertDate BETWEEN #12/07/2004# AND #14/07/2004#)"

Code:

QueryString is passed as "(InsertDate BETWEEN #12/07/2004# AND #14/07/2004#)"

Public Function GetOrders(ByRef OrderArray() As OrderDetails, QueryString As String) As Boolean

On Error GoTo errorHandler

'\\ Adds a new customer to the local database.

Dim dbConnection As ADODB.Connection
Dim dbRecordSet As ADODB.Recordset
Dim intLoopIndex As Integer

If Len(Application.LocalDBConnection) < 1 Then

MsgBox "No local database connection parameter provided. Please run the configuration utility. Unable to get orders.", 48, "Warning"

Exit Function

End If

Set dbConnection = New ADODB.Connection
Set dbRecordSet = New ADODB.Recordset

'Connect to the database
dbConnection.ConnectionString = Application.LocalDBConnection
dbConnection.Open

'Build SQL command
With dbRecordSet

.Open "SELECT * FROM tbl_orders WHERE " & QueryString, dbConnection, adOpenStatic, adLockReadOnly

If Not (.RecordCount < 1) Then

ReDim OrderArray(.RecordCount - 1)

intLoopIndex = 0

.MoveFirst

Do

OrderArray(intLoopIndex).Customer = .Fields("Customer").Value
OrderArray(intLoopIndex).CustOrdNo = .Fields("CustOrdNo").Value
OrderArray(intLoopIndex).Description = .Fields("Description").Value
OrderArray(intLoopIndex).User = .Fields("User").Value
OrderArray(intLoopIndex).Total = .Fields("Total").Value
OrderArray(intLoopIndex).InsertDate = .Fields("InsertDate").Value

.MoveNext

intLoopIndex = (intLoopIndex + 1)

Loop Until (.EOF)

GetOrders = True

End If

End With

'Close recordset and connection
If (dbRecordSet.State = adStateOpen) Then

dbRecordSet.Close

End If

If (dbConnection.State = adStateOpen) Then

dbConnection.Close

End If

'Dispose of DB objects
Set dbConnection = Nothing
Set dbRecordSet = Nothing

Exit Function

errorHandler:

'Close recordset and connection
If (dbRecordSet.State = adStateOpen) Then

dbRecordSet.Close

End If

If (dbConnection.State = adStateOpen) Then

dbConnection.Close

End If

'Dispose of DB objects
Set dbConnection = Nothing
Set dbRecordSet = Nothing

ShowError Err, "modFunctions.GetOrders()"

End Function

Problem:

The recordset returns a record that has the field 'InsertDate' equal to 15/07/2004. This is not within my date range specified.

The actual orders.mdb file is attached to this post.

Any help much appreciated!

Regards,
-Matthew Hall.Hi,

The following query will solve your requirement.

SELECT * FROM tbl_orders WHERE (InsertDate BETWEEN #7/12/2004# AND #7/14/2004#)

I believe Access evaluates date values as mm/dd/yyyy by default. If a supplied value is not valid in this format, Access will attempt to convert it. Therefore, the query you supplied would be equal to ... BETWEEN #12/07/2004# AND #7/14/2004#, which would indeed return 7/15/2004.|||Thank you for your response.

Is this not dependent on the systems regional settings?

Is there an option I can set in the actual Access file that will set the date to be in the correct format, or am I forced to use American format dates?

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:
> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >I have a MSDE instance running on a server. I am able to start the services
> > for the
> > engine. But when I try to access the instance through "SQL Enterprise
> > Manager" I
> > get an error message.
> >
> > "[server name] - SQL Server does not exist or access is denied."
> >
> > I tried to access the instance through "Windows Authentication" and "SQL
> > Server Login" and I get the same error message.
> >
> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> > start
> > the SQL services and I can restore a few databases from backup to the
> > instance.
> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> > password
> > using the SAPWD switch.
> >
> >
> > Questions:
> > Is there somthing that I am forgetting to do?
> > How can I access the instance through SQL Enterprise Manager?
> >
> > Thanks in advance
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>> Greg,
>> Instance? Have you tried servername\instancename?
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >I have a MSDE instance running on a server. I am able to start the
>> >services
>> > for the
>> > engine. But when I try to access the instance through "SQL Enterprise
>> > Manager" I
>> > get an error message.
>> >
>> > "[server name] - SQL Server does not exist or access is denied."
>> >
>> > I tried to access the instance through "Windows Authentication" and
>> > "SQL
>> > Server Login" and I get the same error message.
>> >
>> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
>> > start
>> > the SQL services and I can restore a few databases from backup to the
>> > instance.
>> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
>> > password
>> > using the SAPWD switch.
>> >
>> >
>> > Questions:
>> > Is there somthing that I am forgetting to do?
>> > How can I access the instance through SQL Enterprise Manager?
>> >
>> > Thanks in advance
>>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:
> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > What do you mean servername\instancename?
> > There is no place to enter that info in SQL Enterprise Manager.
> >
> > Is there anywhere else I can enter that info?
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> Instance? Have you tried servername\instancename?
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >I have a MSDE instance running on a server. I am able to start the
> >> >services
> >> > for the
> >> > engine. But when I try to access the instance through "SQL Enterprise
> >> > Manager" I
> >> > get an error message.
> >> >
> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >
> >> > I tried to access the instance through "Windows Authentication" and
> >> > "SQL
> >> > Server Login" and I get the same error message.
> >> >
> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> >> > start
> >> > the SQL services and I can restore a few databases from backup to the
> >> > instance.
> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> >> > password
> >> > using the SAPWD switch.
> >> >
> >> >
> >> > Questions:
> >> > Is there somthing that I am forgetting to do?
> >> > How can I access the instance through SQL Enterprise Manager?
> >> >
> >> > Thanks in advance
> >>
> >>
> >>
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>> Greg,
>> I don't use MSDE but if EM sees it as another SQL Server and not the
>> default
>> install then it probably sees it as a named instance. When you're
>> registering MSDE. For more information on named instances see:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>> > What do you mean servername\instancename?
>> > There is no place to enter that info in SQL Enterprise Manager.
>> >
>> > Is there anywhere else I can enter that info?
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> Greg,
>> >>
>> >> Instance? Have you tried servername\instancename?
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "Greg" <gregkh@.hotmail.com> wrote in message
>> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >> >I have a MSDE instance running on a server. I am able to start the
>> >> >services
>> >> > for the
>> >> > engine. But when I try to access the instance through "SQL
>> >> > Enterprise
>> >> > Manager" I
>> >> > get an error message.
>> >> >
>> >> > "[server name] - SQL Server does not exist or access is denied."
>> >> >
>> >> > I tried to access the instance through "Windows Authentication" and
>> >> > "SQL
>> >> > Server Login" and I get the same error message.
>> >> >
>> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
>> >> > to
>> >> > start
>> >> > the SQL services and I can restore a few databases from backup to
>> >> > the
>> >> > instance.
>> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
>> >> > sa
>> >> > password
>> >> > using the SAPWD switch.
>> >> >
>> >> >
>> >> > Questions:
>> >> > Is there somthing that I am forgetting to do?
>> >> > How can I access the instance through SQL Enterprise Manager?
>> >> >
>> >> > Thanks in advance
>> >>
>> >>
>> >>
>>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:
> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > an
> > MSDE instance. I need to access thaat instance from SQL Enterprise
> > Manager. I
> > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > instance.
> >
> > How about this, How do I put the MSDE instance in single-user mode?
> >
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> I don't use MSDE but if EM sees it as another SQL Server and not the
> >> default
> >> install then it probably sees it as a named instance. When you're
> >> registering MSDE. For more information on named instances see:
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> >> > What do you mean servername\instancename?
> >> > There is no place to enter that info in SQL Enterprise Manager.
> >> >
> >> > Is there anywhere else I can enter that info?
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> Greg,
> >> >>
> >> >> Instance? Have you tried servername\instancename?
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >> >I have a MSDE instance running on a server. I am able to start the
> >> >> >services
> >> >> > for the
> >> >> > engine. But when I try to access the instance through "SQL
> >> >> > Enterprise
> >> >> > Manager" I
> >> >> > get an error message.
> >> >> >
> >> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >> >
> >> >> > I tried to access the instance through "Windows Authentication" and
> >> >> > "SQL
> >> >> > Server Login" and I get the same error message.
> >> >> >
> >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> >> >> > to
> >> >> > start
> >> >> > the SQL services and I can restore a few databases from backup to
> >> >> > the
> >> >> > instance.
> >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> >> >> > sa
> >> >> > password
> >> >> > using the SAPWD switch.
> >> >> >
> >> >> >
> >> >> > Questions:
> >> >> > Is there somthing that I am forgetting to do?
> >> >> > How can I access the instance through SQL Enterprise Manager?
> >> >> >
> >> >> > Thanks in advance
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
> > Greg,
> >
> > So MSDE is the only SQL Server installed? Try registering with the machine
> > IP address. Or if that doesn't work try:
> >
> > (local)
> >
> > HTH
> >
> > Jerry
> >
> >
> > "Greg" <gregkh@.hotmail.com> wrote in message
> > news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > > an
> > > MSDE instance. I need to access thaat instance from SQL Enterprise
> > > Manager. I
> > > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > > instance.
> > >
> > > How about this, How do I put the MSDE instance in single-user mode?
> > >
> > >
> > > "Jerry Spivey" wrote:
> > >
> > >> Greg,
> > >>
> > >> I don't use MSDE but if EM sees it as another SQL Server and not the
> > >> default
> > >> install then it probably sees it as a named instance. When you're
> > >> registering MSDE. For more information on named instances see:
> > >>
> > >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> > >>
> > >> HTH
> > >>
> > >> Jerry
> > >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > >> > What do you mean servername\instancename?
> > >> > There is no place to enter that info in SQL Enterprise Manager.
> > >> >
> > >> > Is there anywhere else I can enter that info?
> > >> >
> > >> > "Jerry Spivey" wrote:
> > >> >
> > >> >> Greg,
> > >> >>
> > >> >> Instance? Have you tried servername\instancename?
> > >> >>
> > >> >> HTH
> > >> >>
> > >> >> Jerry
> > >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> > >> >> >I have a MSDE instance running on a server. I am able to start the
> > >> >> >services
> > >> >> > for the
> > >> >> > engine. But when I try to access the instance through "SQL
> > >> >> > Enterprise
> > >> >> > Manager" I
> > >> >> > get an error message.
> > >> >> >
> > >> >> > "[server name] - SQL Server does not exist or access is denied."
> > >> >> >
> > >> >> > I tried to access the instance through "Windows Authentication" and
> > >> >> > "SQL
> > >> >> > Server Login" and I get the same error message.
> > >> >> >
> > >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> > >> >> > to
> > >> >> > start
> > >> >> > the SQL services and I can restore a few databases from backup to
> > >> >> > the
> > >> >> > instance.
> > >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> > >> >> > sa
> > >> >> > password
> > >> >> > using the SAPWD switch.
> > >> >> >
> > >> >> >
> > >> >> > Questions:
> > >> >> > Is there somthing that I am forgetting to do?
> > >> >> > How can I access the instance through SQL Enterprise Manager?
> > >> >> >
> > >> >> > Thanks in advance
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

Access SQL functions through .net?

I usually access stored procedures using SQL data source. But now I need a string returned from the database. If I write a function in SQL how do I access it from an aspx.vb file?

Put it in a proc and run an EXEC query, same way as any other procedure.

Jeff

|||

If the SQL function returns a string, why not use SqlCommand.ExecuteScalar method:

using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ToString()))
{
conn.Open();

string qstring = "SELECT dbo.fn_test('IORI')";

SqlCommand cmd = new SqlCommand(qstring, conn);
string s=cmd.ExecuteScalar().ToString();

Response.Write("The new string is:" + s);
}

|||Cool! Thanks guys!

access Sql from asp.net

hi,

i have few forms in my form.i dont want to repeat coding for database connectivity.i want to make it as standard in one file.so that in future if any changes in database i can access that file and modify it.

im using global.aspx file here

Sub Session_Start(ByVal senderAsObject,ByVal eAs EventArgs)

' Fires when the session is started

Session("ConnectionPath") ="DRIVER={SQL server};SERVER=localhost;UID=sa;PWD=;DATABASE=mas;"

EndSub

now in my forms how can i access this connection path without repeatin the above code again in my dim con = new sql(...) i dont want to do like this..

You need to use the web.config...

add this

<?xmlversion="1.0"?>
<configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<addname="ConnectionString"connectionString="Data Source=<SERVERNAME>;Initial Catalog=<DATABASENAME>;UID=<USERNAME>;Password=<PASSWORD>;"providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
......
</system.web>
</configuration>

Then in you code behind do this to access is...

Dim conn as SqlConnection =New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

|||

Or better you create a public shared method and create it there.

|||

Error 101 Value of type 'System.Configuration.ConnectionStringSettingsCollection' cannot be converted to 'String'.

im getting this error

|||

Since you have added the connection string in session variable, use the below code to access it Dim conn as SqlConnection = New SqlConnection(session("ConnectionPath"))

|||

hi, thankyou,i manged to solve it with all ur advices...

i have a doubt in procedure.is it possible to retive value of a column from a table inside procedure?someth like this

cREATE PROCEDURE a @.val varchar(50)
AS
declare @.type char(2)
set @.type='select id from dbo.Handle_Master where name = @.val'
if @.type='A'
Begin .....

if @.Type='B'

Begin...

someth like this...is that possible??if can!! how ?i tried like this but no error and no result also...

|||

wat i felt here is instead of accesing from table ,i planned to pass the value as parameter...jus changed the logic...its workin fine...

Access SQL Conversion Issues?

Hi there, apologies if i have entered this into the wrong forum.

I am currently building an application using microsoft access and coding in VBA (what i can!)

When i have got it working as i like after user testing i would like to create an MDE file to distribute to users and i would like to convert the access database held on a file server to a SQL server but have no experience of doing this.

In what order would i do this and would i suffer a loss of functionality in changing from access to SQL i.e. would some of the VBA code not work in SQL?

Thanks for your time,

Rhys.

Yes, you are right, if you do not use the GUI "only", you *could* get into problems after migrating. If you already know that you will switch to the SQL Server option, you should build your application directly on top of that.

HTH, Jens Suessmeyer.

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

Hello

Have you tried importing the Access database using SQL Server Integration Services (or Data Transformation Services if you use SQL Server 2000)?
I'm not sure if it works with MDE files but I would give it try.

Let us know if it works

Worf

|||

one thing you have to watch out are the stored procedure.

in access it looks like this

select * from employees where employee_id=?

while in SQL server it looks like this

Select * from employees where employee_id=@.employeeid

ACCESS SQL COLUMN DATA TYPE

HELLO

i have an sql server database, with a table an some columns.

how can i get the data type of each column and the lengh define in the database table?

Are you working with SQL Server 2000 or 2005?

|||

sql 2000

|||

Fire up profiler, filter to your spid, and run sp_help on a table. See what SQL Server does. You can copy the code from what SQL Server does and use it for yourself. To start with, check out syscolumns in books online.

|||

Or, you could use the INFORMATION_SCHEMA views to do it:

SELECT *FROM INFORMATION_SCHEMA.columnsWHERE table_Name =table

HTH,

Stu

Access Sql 2005 from sql 2000

Hi,

I access the sql 2000 db's . Now, the dbs have been moved to 2005. Is it possible to connect to sql 2005 db from sql enterprise manager 2000. Or let me know if I have to upgrade to 2005 to access the same.

I get the error message To connect to the server you must use sql server management studio or sql server management objects(SMO) when trying to access the server from sql enterprise manager 2000.

Usually it is not possible to access higher version dbs from a lower version.

Please help me out as soon as possible as this is very urgent.

Thanks & Regards,

K. Sripriya

Hi Sripriya K,

You will have to upgrade to sql 2005 management studio to manage sql 2005 database's
|||Priya you cannot access your SQL 2005 databases from SQL 2000 enterprise manager but vice-versa is possible......Yes you need to have SQL 2005 to access the same.......also you cannot restore sql 2005 dbs backup file in sql 2000.....and you also cannot perform detach and attach sql 2005 dbs in sql 2000|||If you are using SQL Express then you need the install SQL Management Express seperately, from there you can access your sql.
Download SQL Mangament Express

If you have other edition then you will have management studio installed already.
Goto run, type sqlwb, press enter.. You will get management studio to connect to sql 2005 server.

You cant use EM to connect to a Sql 2005 machine, but you can use query analyser to connect to sql 2005 server.

Access specific Graph data

Hello again
I have a graph which lists cell phone minutes broken down by month. I want the specific data for that month to show in either a matrix or table underneath the graph. The key is that I just want the date for that month only. When the user clicks on a specific month on the graph I just want to show that months data. I know how to accomplish this using the "jump to report" option with parameters,but how do I do this on the same report -- right underneath the graph?

thanks
km

Try SubReport.

SubReport is the report where you can view the main report and drilled down report (sub report) in the same window.

1)the development includes design of a new subreport

2) Have an item called "subreport" in the main report where you want to place that is beneath

3) assign the subreport properties to get your newly developed report(Name of the report,Parameters)

4) Control the visibiliy of the subreport.

Thanks

|||great thanks
appreciate the help
km

Access sometimes won't use index of linked view

Hello,
I have a weird problem with sql server 2000. I have a view wich
combines 2 tables like this:
SELECT foo
FROM dbo.tblA LEFT OUTER JOIN
dbo.tblB ON dbo.A.ID = dbo.B.ID
Table B contains a field named fldSorting, wich has an index. It is
used - you have already guessed it by now

- for sorting.
The view, linked with odbc, is the datasource on a form in ms access
like this: SELECT * FROM foo ORDER BY fldSorting;
This does work. However, for some weird reason, this view becomes
very, VERY slow from time to time (> 1 minute). This happens once in
three months or something. I have looked with the profiler what
exactly access is querying, and that is just normal: SELECT * FROM foo
ORDER BY fldSorting. If i execute this in the query analyzer, it is as
fast as always (<2 seconds)! This is extremely weird, right?
I have found a way to make it quick again, but only for a couple of
months: remove the index on field fldSorting and create it again.
How comes? I have absolutely no clue whatsoever.
1. Why does this problem pop up sometimes?
2. Why does sometimes the exact same query seems to not use an index
if access executes it via odbc, while executed via the query analyzer,
all is ok?
This is a very unpleasant problem since it is our main sql server, and
our ERP system is also running on this server. So every time this
happens, everybody has a break...
Does anybody has some ideas? I will be very happy with all thoughts...
Thanks in advance,
B. Lowsma
Netherlands
Being that the problem goes away when you drop and recreate
the index and then it comes back again in a couple of
months, I'd start looking into the possibility that the
index is fragmented when you start hitting the problems.
-Sue
On Fri, 29 Jun 2007 07:29:19 -0000, "meatusenet@.gmail.com"
<meatusenet@.gmail.com> wrote:

>Hello,
>I have a weird problem with sql server 2000. I have a view wich
>combines 2 tables like this:
>SELECT foo
>FROM dbo.tblA LEFT OUTER JOIN
> dbo.tblB ON dbo.A.ID = dbo.B.ID
>Table B contains a field named fldSorting, wich has an index. It is
>used - you have already guessed it by now

- for sorting.
>The view, linked with odbc, is the datasource on a form in ms access
>like this: SELECT * FROM foo ORDER BY fldSorting;
>This does work. However, for some weird reason, this view becomes
>very, VERY slow from time to time (> 1 minute). This happens once in
>three months or something. I have looked with the profiler what
>exactly access is querying, and that is just normal: SELECT * FROM foo
>ORDER BY fldSorting. If i execute this in the query analyzer, it is as
>fast as always (<2 seconds)! This is extremely weird, right?
>I have found a way to make it quick again, but only for a couple of
>months: remove the index on field fldSorting and create it again.
>How comes? I have absolutely no clue whatsoever.
>1. Why does this problem pop up sometimes?
>2. Why does sometimes the exact same query seems to not use an index
>if access executes it via odbc, while executed via the query analyzer,
>all is ok?
>This is a very unpleasant problem since it is our main sql server, and
>our ERP system is also running on this server. So every time this
>happens, everybody has a break...
>Does anybody has some ideas? I will be very happy with all thoughts...
>Thanks in advance,
>B. Lowsma
>Netherlands
|||Thanks for your reply. So if this occurs i can possibly fix it with
DBCC DBREINDEX or DBCC INDEXDEFRAG? I will try that the first time it
happens again... If this is the case, is there anything i can do to
prevent this from happening?
TIA,
B. Lowsma
On 6 jul, 05:27, Sue Hoegemeier <S...@.nomail.please> wrote:[vbcol=seagreen]
> Being that the problem goes away when you drop and recreate
> the index and then it comes back again in a couple of
> months, I'd start looking into the possibility that the
> index is fragmented when you start hitting the problems.
> -Sue
> On Fri, 29 Jun 2007 07:29:19 -0000, "meatuse...@.gmail.com"
> <meatuse...@.gmail.com> wrote:
>
>
>
>
|||Sure...read up on the subject in books online under the help
topic for DBCC SHOWCONTIG. You want to be doing some type of
index maintenance on a regular basis but you do want to take
other things into consideration with defragmentation of
indexes. This is a good source of information on the
subject, what to consider, etc:
Microsoft SQL Server 2000 Index Defragmentation Best
Practices
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
-Sue
On Fri, 06 Jul 2007 13:11:12 -0000, "meatusenet@.gmail.com"
<meatusenet@.gmail.com> wrote:

>Thanks for your reply. So if this occurs i can possibly fix it with
>DBCC DBREINDEX or DBCC INDEXDEFRAG? I will try that the first time it
>happens again... If this is the case, is there anything i can do to
>prevent this from happening?
>TIA,
>B. Lowsma
>On 6 jul, 05:27, Sue Hoegemeier <S...@.nomail.please> wrote:
>
|||Thanks!
Sue Hoegemeier wrote:[vbcol=seagreen]
> Sure...read up on the subject in books online under the help
> topic for DBCC SHOWCONTIG. You want to be doing some type of
> index maintenance on a regular basis but you do want to take
> other things into consideration with defragmentation of
> indexes. This is a good source of information on the
> subject, what to consider, etc:
> Microsoft SQL Server 2000 Index Defragmentation Best
> Practices
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
> -Sue
> On Fri, 06 Jul 2007 13:11:12 -0000, "meatusenet@.gmail.com"
> <meatusenet@.gmail.com> wrote:

Saturday, February 25, 2012

Access SQL Server from SOLARIS.

Access SQL server from AS/400 DB2

Access SQL server from AS/400 DB2

access SQL Server from application

Access SQL Server Behind Firewall

Access SQL Server Behind Firewall

Access sql server behide firewall?

Access sql server behide firewall?

access sql server across domain thru windows authentication

Access SQL Server 2005 via HTTP

access sql server 2005 via http

Access SQL Server 2005 from C++ programs in UNIX/LINUX

Access Sql server 2005 from .net class library

Access SQL Server 2005 database using a published website

access sql server 2000

Access SQL problems using MS Jet OLEDB with ADO+VB6

access SQL instance issue

access SQL instance issue

access SQL instance issue

Access SQL functions through .net?

access Sql from asp.net

Access SQL Conversion Issues?

ACCESS SQL COLUMN DATA TYPE

Access Sql 2005 from sql 2000

Access specific Graph data

Access sometimes won't use index of linked view

SQL Alert

Blog Archive

About Me