Accessing Index Server from SQL Server on different system

Hi
I have SQL Server and Index Server running on 2 different system.
How can I call Index server from SQL Server (store procedure) in such
case.
Regards

> Hi
> I have SQL Server and Index Server running on 2 different system.
> How can I call Index server from SQL Server (store procedure) in such
> case.
> Regards
You can connect use the OLE DB Provider for Microsoft Indexing Service to
connect to the remote Index Server. More info:
http://msdn.microsoft.com/library/de...us/acdata/ac_8
_qd_12_0h0l.asp
Eric Crdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Accessing Index Server from SQL Server on different system

Hi
I have SQL Server and Index Server running on 2 different system.
How can I call Index server from SQL Server (store procedure) in such
case.
Regards
> Hi
> I have SQL Server and Index Server running on 2 different system.
> How can I call Index server from SQL Server (store procedure) in such
> case.
> Regards
--
You can connect use the OLE DB Provider for Microsoft Indexing Service to
connect to the remote Index Server. More info:
http://msdn.microsoft.com/library/d...-us/acdata/ac_8
_qd_12_0h0l.asp
Eric Crdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Accessing Index Server from SQL Server on different system

Hi
I have SQL Server and Index Server running on 2 different system.
How can I call Index server from SQL Server (store procedure) in such
case.
Regards> Hi
> I have SQL Server and Index Server running on 2 different system.
> How can I call Index server from SQL Server (store procedure) in such
> case.
> Regards
--
You can connect use the OLE DB Provider for Microsoft Indexing Service to
connect to the remote Index Server. More info:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8
_qd_12_0h0l.asp
--
Eric Cárdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Accessing agents status!

Hi everybody...
I'm testing a system with one distribution server and 2 subscribers
(pointing to 2 different publications on server)(planning to add other 7
subscribers on it!). I'm using bidirectional transactional replication.
Sql server 2000 is installed everywhere. All the system works fine. Data
is being updated on subscribers with a rate of about 100 records each
minute.
In that system one of the testcases is to disconnect one of the
subscriber (no more data is written in it!) for 60 minutes or more, the
reconnect it. When i reconnect it I have 2 problems:
1 - My agent is stopped (i'm using PUSH subscriptions...). I've heard
that it's the normal behavior when using a push subscription, but
there's a way to avoid it? Maybe with some triggers/stored procedures?
2 - Atfer reconnection the subscriber and restarting the agent that
stopped all the agents start working and sincronizing data. But if i
start writing data in the data that has just been reconnected, all the
data i put inside it is not sent to server and goes to conflict tables!
First question: Can i do something about that?
I tryied to do it all again but this time i've waited all the agents to
finish syncronising the data writen when the subscriber was "down". This
could be an acceptable procedure to me but I have to "tell" the normal
user to that the agent has synconized everything and he can start
writing on the subscriber.
Second question: Is there a way to look at the agent status (not using
enterprise manager!!)? I'm open minded to all kind of solutions...
Running scripts, stored procedures, writing my own small program (maybe
using some libraries... maybe RMO?).
And Thank you in advance for any
feedback
Fabio,
this is a script I use to examine the state of a job:
http://www.replicationanswers.com/Do...nningJobs.txt.
You could use it to decide what to do. To have your agent automatically
restart when connectivity is reestablished, a simple solution is to not have
the continuous schedule but a schedule once a minute. However, in this case
the above script won't really be helpful. So, I'd have a job that runs every
minute and does sp_start_job to start the merge agent, but only if it is not
already running (use my script for that). On the subscriber, if the merge
agent isn't running (again my script) you could prevent user access if you
want to avoid conflicts.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
"Fabio Pliger" wrote:

> Hi everybody...
> I'm testing a system with one distribution server and 2 subscribers
> (pointing to 2 different publications on server)(planning to add other 7
> subscribers on it!). I'm using bidirectional transactional replication.
> Sql server 2000 is installed everywhere. All the system works fine. Data
> is being updated on subscribers with a rate of about 100 records each
> minute.
> In that system one of the testcases is to disconnect one of the
> subscriber (no more data is written in it!) for 60 minutes or more, the
> reconnect it. When i reconnect it I have 2 problems:
> 1 - My agent is stopped (i'm using PUSH subscriptions...). I've heard
> that it's the normal behavior when using a push subscription, but
> there's a way to avoid it? Maybe with some triggers/stored procedures?
> 2 - Atfer reconnection the subscriber and restarting the agent that
> stopped all the agents start working and sincronizing data. But if i
> start writing data in the data that has just been reconnected, all the
> data i put inside it is not sent to server and goes to conflict tables!
> First question: Can i do something about that?
> I tryied to do it all again but this time i've waited all the agents to
> finish syncronising the data writen when the subscriber was "down". This
> could be an acceptable procedure to me but I have to "tell" the normal
> user to that the agent has synconized everything and he can start
> writing on the subscriber.
> Second question: Is there a way to look at the agent status (not using
> enterprise manager!!)? I'm open minded to all kind of solutions...
> Running scripts, stored procedures, writing my own small program (maybe
> using some libraries... maybe RMO?).
> And Thank you in advance for any
> feedback
>

Access Vs SQL Server

Hello!

I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.

http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp

I know the basics, just want stats and facts to back them up.

Thanks...Originally posted by swestenhofer
Hello!

I am trying to gather information on why MS SQL Server 2000 is a better enterprise level database management system MS Access 2002. There is an article on the Microsoft Technet, but when I try and access the article I get a 404 error. Link is there, but page behind is missing.

http://www.micrsoft.com/sql/techinfo/planning/SQLAccess.asp

I know the basics, just want stats and facts to back them up.

Thanks...

1) Volume of data
2) Scalbility
3) Performance
4) OLAP
5) Security features
6) Easy Query processing
7) Data distribution and replication
8) Job scheduling
9) Programmability

There are lots of reasons like this. Access is good if your data is less than 2GB and depends what you are looking from a database.|||Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.

Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.

In a nutshell, running Access as an Enterprise solution drags a network to its knees.|||Originally posted by blindman
Access is not a database "Server". Thus, if you have a query in Access that joins a parent table with 10,000 rows to a child table with 100,000 to return a filtered set of records consisting of, say 200 rows, Access will transfer all 110,000 records from both tables over your network and then perform the SQL statement on whatever (slow) desktop the user happens to be at.

Under SQL Server, all the calculation is done on the (powerfull quad-processor, RAM out the wazzoo) server, and only the final 200 rows are returned over your network.

In a nutshell, running Access as an Enterprise solution drags a network to its knees.

Thanks all!! This should be good fuel for my client to use... thanks for the help!|||Hey...no one told him about the cost...

What's the differences between a kia and a bentley?|||Originally posted by Brett Kaiser
Hey...no one told him about the cost...

What's the differences between a kia and a bentley?

I know the cost differences involved, and the client is aware as well, and in the long run, user connection timeouts and database size limitations may outway the costs based on recovery and migration...

Thanks again!

Access Val Function in SQL Server

What is the counterpart of this function when using SQL Server 2000? Imgetting this error "System.Data.SqlClient.SqlException: 'Val' is not arecognized function name"
What do I have to change in my queryString?
SELECT ASP_MainForm.UserID, Val([FormNo]) AS Expr1,ASP_MainForm.DateCreated, ASP_MainForm.DateNeeded,ASP_MainForm.FormStatus, ASP_MainForm.Print, ASP_MainForm.PRNo,ASP_MainForm.ForUse, [FirstName]+' '+[LastName] AS CompName FROMASP_MainForm INNER JOIN CEN_USERS ON ASP_MainForm.UserID =CEN_USERS.UserBadgeNo WHERE(((ASP_MainForm.FormStatus)<>'Approved') AND((ASP_MainForm.ForUse)<>'Test')) ORDER BY Expr1 DESC
Pls help thanks
Use SQL Server's Convert Function. Convert(decimal(10,5), [FormNo])

CONVERT(data_type[(length)],expression [,style])

Arguments

expression

Is any valid Microsoft? SQL Server? expression. For more information, seeExpressions.

data_type

Is the target system-supplied data type, includingbigint andsql_variant. User-defined data types cannot be used. For more information about available data types, seeData Types.

length

Is an optional parameter ofnchar,nvarchar,char,varchar,binary, orvarbinary data types.

style

Is the style of date format used to convertdatetime orsmalldatetime data to character data (nchar,nvarchar,char,varchar,nchar, ornvarchar data types), or the string format when convertingfloat, real,money, orsmallmoney data to character data (nchar,nvarchar, char,varchar,nchar, ornvarchar data types).

SQL Server supports the date format in Arabic style, using Kuwaiti algorithm.

In the table, the two columns on the left represent thestyle values fordatetime orsmalldatetime conversion to character data. Add 100 to astyle value to get a four-place year that includes the century (yyyy).

|||Thanks! That was indeed the solution to it. Thanks again.

Access user and system DSNs programmatically

Just as the ODBC Data Source Administrator lists user and system DSNs, I wan
t
to access the same information programmatically in C#. I found registry
entries for these but I was hoping there was a higher-level routine that
would provide the information. The OdbcFactory.CreateDataSourceEnumerator
looked promising at first, but it seems to list just instances of SqlServer.
Is there a .NET method that could provide this information?
If I have to use a registry lookup, how do I determine the path for the
current user in the registry?Hi,
I understand that you would like to know how to list all the DSNs installed
on a computer programmatically in C#.
If I have misunderstood, please let me know.
I recommend that you utilize either of the following two methods:
1. Use P-Invoke in C# to call SQLDataSources.
You may refer to the following articles:
SQLDataSources(ODBC32)
http://www.pinvoke.net/default.aspx...ataSources.html
Listing Available DSN / Drivers Installed
http://www.codeguru.com/vb/gen/vb_d...icle.php/c2045/
2. Write the code to analyze the following information respectively:
System DSNs are stored in the registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
User DSNs are stored in ODBC.INI file that is located at:
C:\WINNT
File DSNs are stored in the following directory:
C:\Program Files\Common Files\ODBC\Data Sources
Note that this response contains a reference to a third party World Wide
Web site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.
If you have any other questions or concerns, please feel free to let me
know. Happy New Year!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||I tried to incorporate from the code samples you pointed to, but I did not
know how to properly reference the function calls (i.e. SQLDataSources,
SQLSetEnvAttr, SQLAllocHandle) that are apparently from the odbc32.dll.
However, I did manage to find a simple implementation of accessing the info
from the registry at http://www.thescripts.com/forum/thread269514.html. I
refactored the code from that thread into this short solution:
public static SortedList listAllDSN()
{
SortedList allDSN = new SortedList();
// Get User DNS Names
GetOdbcRegistryValues(allDSN, Registry.CurrentUser);
// Get System DNS Names
GetOdbcRegistryValues(allDSN, Registry.LocalMachine);
return allDSN;
}
private static void GetOdbcRegistryValues(SortedList allDSN, RegistryKey reg
)
{
reg = reg.OpenSubKey("Software");
reg = reg.OpenSubKey("ODBC");
reg = reg.OpenSubKey("ODBC.INI");
reg = reg.OpenSubKey("ODBC Data Sources");
if (reg != null)
{
foreach (string s in reg.GetValueNames())
{
try { allDSN.Add(s, null); }
catch { }
}
}
try { reg.Close(); }
catch { }
}|||Hi,
Thanks for your response.
SQLDataSources, SQLSetEnvAttr and SQLAllocHandle are indeed included in
odbc32.dll. That is why you need to use P/Invoke technology in C#/VB.NET to
call them. You need to re-declare them in C#. The first link should have
introduced how to invoke it:
//1. import it and redeclare it in C#
[DllImport("odbc32.dll", CharSet=CharSet.Ansi))]
static extern short SQLDataSources(IntPtr EnvironmentHandle, short
Direction,
StringBuilder ServerName, short BufferLength1, ref short
NameLength1Ptr,
StringBuilder Description, short BufferLength2, ref short
NameLength2Ptr);
//2. Call it directly
....
rc = SQLDataSources(sql_env_handle, SQL_FETCH_FIRST, dsn_name,
(short)dsn_name.Capacity, ref dsn_name_len, desc_name, (short)
desc_name.Capacity, ref desc_len);
For SQLAllocHandle and SQLSetEnvAttr, you can find them in the web site:
http://www.pinvoke.net/default.aspx...llocHandle.html
http://www.pinvoke.net/default.aspx...SetEnvAttr.html
Anyway I am glad to hear that you had found the resolution by yourself. If
you have any other questions or concerns, please feel free to let me know.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============

Access user and system DSNs programmatically

Just as the ODBC Data Source Administrator lists user and system DSNs, I want
to access the same information programmatically in C#. I found registry
entries for these but I was hoping there was a higher-level routine that
would provide the information. The OdbcFactory.CreateDataSourceEnumerator
looked promising at first, but it seems to list just instances of SqlServer.
Is there a .NET method that could provide this information?
If I have to use a registry lookup, how do I determine the path for the
current user in the registry?
Hi,
I understand that you would like to know how to list all the DSNs installed
on a computer programmatically in C#.
If I have misunderstood, please let me know.
I recommend that you utilize either of the following two methods:
1. Use P-Invoke in C# to call SQLDataSources.
You may refer to the following articles:
SQLDataSources(ODBC32)
http://www.pinvoke.net/default.aspx/odbc32/SQLDataSources.html
Listing Available DSN / Drivers Installed
http://www.codeguru.com/vb/gen/vb_database/article.php/c2045/
2. Write the code to analyze the following information respectively:
System DSNs are stored in the registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
User DSNs are stored in ODBC.INI file that is located at:
C:\WINNT
File DSNs are stored in the following directory:
C:\Program Files\Common Files\ODBC\Data Sources
Note that this response contains a reference to a third party World Wide
Web site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.
If you have any other questions or concerns, please feel free to let me
know. Happy New Year!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||I tried to incorporate from the code samples you pointed to, but I did not
know how to properly reference the function calls (i.e. SQLDataSources,
SQLSetEnvAttr, SQLAllocHandle) that are apparently from the odbc32.dll.
However, I did manage to find a simple implementation of accessing the info
from the registry at http://www.thescripts.com/forum/thread269514.html. I
refactored the code from that thread into this short solution:
public static SortedList listAllDSN()
{
SortedList allDSN = new SortedList();
// Get User DNS Names
GetOdbcRegistryValues(allDSN, Registry.CurrentUser);
// Get System DNS Names
GetOdbcRegistryValues(allDSN, Registry.LocalMachine);
return allDSN;
}
private static void GetOdbcRegistryValues(SortedList allDSN, RegistryKey reg)
{
reg = reg.OpenSubKey("Software");
reg = reg.OpenSubKey("ODBC");
reg = reg.OpenSubKey("ODBC.INI");
reg = reg.OpenSubKey("ODBC Data Sources");
if (reg != null)
{
foreach (string s in reg.GetValueNames())
{
try { allDSN.Add(s, null); }
catch { }
}
}
try { reg.Close(); }
catch { }
}
|||Hi,
Thanks for your response.
SQLDataSources, SQLSetEnvAttr and SQLAllocHandle are indeed included in
odbc32.dll. That is why you need to use P/Invoke technology in C#/VB.NET to
call them. You need to re-declare them in C#. The first link should have
introduced how to invoke it:
//1. import it and redeclare it in C#
[DllImport("odbc32.dll", CharSet=CharSet.Ansi))]
static extern short SQLDataSources(IntPtr EnvironmentHandle, short
Direction,
StringBuilder ServerName, short BufferLength1, ref short
NameLength1Ptr,
StringBuilder Description, short BufferLength2, ref short
NameLength2Ptr);
//2. Call it directly
.....
rc = SQLDataSources(sql_env_handle, SQL_FETCH_FIRST, dsn_name,
(short)dsn_name.Capacity, ref dsn_name_len, desc_name, (short)
desc_name.Capacity, ref desc_len);
For SQLAllocHandle and SQLSetEnvAttr, you can find them in the web site:
http://www.pinvoke.net/default.aspx/odbc32/SQLAllocHandle.html
http://www.pinvoke.net/default.aspx/odbc32/SQLSetEnvAttr.html
Anyway I am glad to hear that you had found the resolution by yourself. If
you have any other questions or concerns, please feel free to let me know.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Access to Sqlserver transfering ?

I am having Access database in my local system . Values in the access database will be updated for every 5 min .

I am also having Sqlserver database online with the same structure database of Access in my local system .

What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically .How to do that ?
I hope your database isn't too big. Google around about the DTS packages of SQL Server. You can make one (it defines import/export mechanism), then call it periodically.|||

You can set a flag column in access database with default value 0. If the data is updated set flag to 1.

Then you run a program periodically update the updated data in access to sql server and set all flags to 0.

|||

hi dear ;

i think u mast using datareader object (connected datasource) to get ur data online updated but u mast try to refrishing it.

dont use dataset (disconnected datasource)

Access to SQL Server System Logs

I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this?Hi,

no this is the most common way to do this.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Access to SQL Server

I have almost finished a prototype system that I have developed in Access.
The idea now is to have the db (tables) run in SQL server with access to it
(ie the fe) in MS Access.
How would I go about porting the system to SQL Server or where could I find
out more.
The DB contains various forms and modules as well as some queries and report
s.
I realise this may not be the correct forum, but I am hoping that someone
may be able to assis as I am of desperate need of some help!
Thank you
KMHi KM
I think you can use linked tables in Access.
The tables give u a virtual feeling that SQL Server tables reside on the
Access databse
PLease let me know if u have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"KM" wrote:

> I have almost finished a prototype system that I have developed in Access.
> The idea now is to have the db (tables) run in SQL server with access to i
t
> (ie the fe) in MS Access.
> How would I go about porting the system to SQL Server or where could I fin
d
> out more.
> The DB contains various forms and modules as well as some queries and repo
rts.
> I realise this may not be the correct forum, but I am hoping that someone
> may be able to assis as I am of desperate need of some help!
> Thank you
> KM|||Hi,
I have no transactions set up. I understand they are quite simple to
program, and I assume that it wont matter to the 'transaction' where the
tables are?
cheers
"Chandra" wrote:
> Hi KM
> I think you can use linked tables in Access.
> The tables give u a virtual feeling that SQL Server tables reside on the
> Access databse
> PLease let me know if u have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://www.SQLResource.com/
> ---
>
> "KM" wrote:
>|||Check out "Microsoft Access Developer's Guide to SQL Server" by Mary Chipman
and Andy Baron (ISBN 0-672-31944-6) available at Amazon for about $10 used!
800 pages of how to get your Access database up and running on SQL Server.
Good Luck!
--
Todd
"KM" wrote:

> I have almost finished a prototype system that I have developed in Access.
> The idea now is to have the db (tables) run in SQL server with access to i
t
> (ie the fe) in MS Access.
> How would I go about porting the system to SQL Server or where could I fin
d
> out more.
> The DB contains various forms and modules as well as some queries and repo
rts.
> I realise this may not be the correct forum, but I am hoping that someone
> may be able to assis as I am of desperate need of some help!
> Thank you
> KM

Access to sql on windows for mysql application

Hi
I hope someone here can advise or at least point me to a good site to
pursue this.
Have installed a password protection system (freeware) successfully on
a unix/php/mysql server and looking forward to developing it into a
full blown database application. I is written in php and use a mysql
database to hold user id's and passwords. There is a small amount of
code on each protected page on the site that checks the session.
I now need to set it up on a windows server system which uses IIS and
sql, mysql is not an option. It appears that ODBC could be the answer
but I don't want to fight my way through the mire of finding and fixes
issues one by one only to get trapped near the end and find it was not
possible all along.
Does anyone have any experience of the and am I on the right track.
Ideally the code will work with minimal change once set up. Would that
be possible and what would I have to set up on the server?
Thanks JohnYou'll need to look at the code and see if the SQL is really
portable. If it's a system written for a mysql backend then
it may not work. The SQL languages have different
implementations on the different database platforms. Without
knowing the app or the code, I don't know that anyone up
here could give you a definitive answer.
-Sue
On Wed, 09 Aug 2006 11:32:10 +0100, John
<yjdyhugo@.d8hujsrfu> wrote:

>Hi
>I hope someone here can advise or at least point me to a good site to
>pursue this.
>Have installed a password protection system (freeware) successfully on
>a unix/php/mysql server and looking forward to developing it into a
>full blown database application. I is written in php and use a mysql
>database to hold user id's and passwords. There is a small amount of
>code on each protected page on the site that checks the session.
>I now need to set it up on a windows server system which uses IIS and
>sql, mysql is not an option. It appears that ODBC could be the answer
>but I don't want to fight my way through the mire of finding and fixes
>issues one by one only to get trapped near the end and find it was not
>possible all along.
>Does anyone have any experience of the and am I on the right track.
>Ideally the code will work with minimal change once set up. Would that
>be possible and what would I have to set up on the server?
>Thanks John

Access the filesystem with SQL server 2005

Hi,
We've got this strange situation. I want to perform a bulk insert in
SQLserver 2005 from a file on the file system. This works OK when I use a
SQLuser. When I do the same logged in with windows account (with
administrator privileges) I get an error. I thought that when I use a
windows account, this account is used to access the file system. When you
use a SQL account then the user of the sqlserver service is used to access
the filesystem. Am I wrong or how does this work ?
TIAYes, the windows account will need access to the file on the file system as
well as be a user with enough privledges on the database to perform the
insert. Are you using BCP or are you using SSIS to do the transfer?
--
Rob Walters
Program Manager - SQL Server
"Mark Brouwers" wrote:

> Hi,
> We've got this strange situation. I want to perform a bulk insert in
> SQLserver 2005 from a file on the file system. This works OK when I use a
> SQLuser. When I do the same logged in with windows account (with
> administrator privileges) I get an error. I thought that when I use a
> windows account, this account is used to access the file system. When you
> use a SQL account then the user of the sqlserver service is used to access
> the filesystem. Am I wrong or how does this work ?
> TIA
>
>|||Thanks for the reply,
I just use a query window within the management studio. I run the sql
statement as a SQLuser and it works. I change the connection properties to
my windows account (with administrator privileges) and is stops working.
Mark
"Rob Walters [MSFT]" <RobWaltersMSFT@.discussions.microsoft.com> wrote in
message news:4BBBCCE0-EFBD-4FD4-B046-B9C5371DA9E8@.microsoft.com...[vbcol=seagreen]
> Yes, the windows account will need access to the file on the file system
> as
> well as be a user with enough privledges on the database to perform the
> insert. Are you using BCP or are you using SSIS to do the transfer?
> --
> Rob Walters
> Program Manager - SQL Server
>
> "Mark Brouwers" wrote:
>

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?
Thanks
Hello 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/lyris.pl?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/products/odbc/Connect/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/homepages/Ken_North/odbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/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/subscriptions/managednewsgroups/default.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/subscriptions/support/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 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 Linked Server system function

Could anyone shed some light on the syntax of accessing system function on a linked server?

I'm trying to get the recovery models of databases on a linked. However using databasepropertyex locally generates wrong results.

e.g.

select databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases

I tried select [server/databasename].databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases

which does not work.

Thanks.

You cannot call a function directly from a linked server using the four part naming convention. You have to use a stored procedure to get the results.

Access Issue after Automatic Update

I finally added WinXP SP2 to my system yesterday (along with a lot of other security updates/patches through Automatic Updates) and now my backups and data exports are failing. Further, when I open my "Enterprise Manager" and try to export data ("All Tasks-Export-...") using the Import/Export Wizard, it won't let me select the "Export From" database.Can you give error message here or something?

Access Front-End

We have a system which uses an Access front end linked to a SQL 2000 database
If we were to move the SQL database onto a new server then would it just be
a case of editing the ODBC settings on each client to point to the new SQL
server?
Yes as long as the SQL Server end of it is correctly moved
(login, users, etc)
-Sue
On Thu, 21 Jul 2005 08:27:04 -0700, HSP
<HSP@.discussions.microsoft.com> wrote:

>We have a system which uses an Access front end linked to a SQL 2000 database
>If we were to move the SQL database onto a new server then would it just be
>a case of editing the ODBC settings on each client to point to the new SQL
>server?

Access Front-End

We have a system which uses an Access front end linked to a SQL 2000 databas
e
If we were to move the SQL database onto a new server then would it just be
a case of editing the ODBC settings on each client to point to the new SQL
server?Yes as long as the SQL Server end of it is correctly moved
(login, users, etc)
-Sue
On Thu, 21 Jul 2005 08:27:04 -0700, HSP
<HSP@.discussions.microsoft.com> wrote:

>We have a system which uses an Access front end linked to a SQL 2000 databa
se
>If we were to move the SQL database onto a new server then would it just be
>a case of editing the ODBC settings on each client to point to the new SQL
>server?

Access FileServer vs MSDE ClientServer

I am designing a new database system for a small team of
users (5-10). I have created similar systems in the past
using an Access FileServer architecture. I am thinking of
using MSDE in the new system to improve performance.
Does anyone have an opinion on whether this would be
worthwhile?
Thanks!
Yes. MSDE (SQL Server) is far more robust in a multi-user environment than
Access. Plus, MSDE offers many more valuable features and functionality than
Access. Several year ago I converted our application from Access to SQL
Server and never once regretted it.
Jim
"Jerry Black" <jerry.w.black@.saic.com> wrote in message
news:2ac201c51e8b$f9c100b0$a401280a@.phx.gbl...
>I am designing a new database system for a small team of
> users (5-10). I have created similar systems in the past
> using an Access FileServer architecture. I am thinking of
> using MSDE in the new system to improve performance.
> Does anyone have an opinion on whether this would be
> worthwhile?
> Thanks!
|||Thanks for the advice.
I'm sure my users will appreciate it.
>--Original Message--
>Yes. MSDE (SQL Server) is far more robust in a multi-
user environment than
>Access. Plus, MSDE offers many more valuable features
and functionality than
>Access. Several year ago I converted our application
from Access to SQL[vbcol=seagreen]
>Server and never once regretted it.
>Jim
>"Jerry Black" <jerry.w.black@.saic.com> wrote in message
>news:2ac201c51e8b$f9c100b0$a401280a@.phx.gbl...
past[vbcol=seagreen]
thinking of
>
>.
>
|||Performance for a small app such as you describe is more contingent on
factors such as database and application design than it is on the
database platform chosen. Some developers have found that the
increased overhead of an MSDE app negatively impacts performance of an
application that worked well in Jet. Whether it is worthwhile or not
will depend on the degree to which you understand the strengths and
weaknesses of the two platforms you are choosing between rather than
the platforms themselves.
--Mary
On Tue, 1 Mar 2005 10:24:58 -0800, "Jerry Black"
<jerry.w.black@.saic.com> wrote:

>I am designing a new database system for a small team of
>users (5-10). I have created similar systems in the past
>using an Access FileServer architecture. I am thinking of
>using MSDE in the new system to improve performance.
>Does anyone have an opinion on whether this would be
>worthwhile?
>Thanks!
|||Jerry,
I'm just finishing converting our billing system which used to run using
an Access database to MSDE/SQL server. Doing the same calculations on a
system after converting lots of code to Stored Procedures has resulted in
about a 4x performance increase for large sets of data. I've also redone
the application in other ways which has reduced memory usage so some of the
performance increase may be due to this as well.
Ron Allen
"Jerry Black" <jerry.w.black@.saic.com> wrote in message
news:2ac201c51e8b$f9c100b0$a401280a@.phx.gbl...
>I am designing a new database system for a small team of
> users (5-10). I have created similar systems in the past
> using an Access FileServer architecture. I am thinking of
> using MSDE in the new system to improve performance.
> Does anyone have an opinion on whether this would be
> worthwhile?
> Thanks!