|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 Security Settings question for ODBC access to SQL v8 Posted by Mystery at 9/19/2003 1:49:09 PM We have our accounts package running on a Win2K server running SQL v8. Can
someone please tell me which security settings I need to configure in order
for a user to be able to connect to the tables in the SQL server via ODBC.
I've tried configuring a User and System DSN from a workstation, and
...more >>
Vertical Partitioning Posted by Harman Dhillon at 9/18/2003 5:07:39 PM could anybody plz tell me how to vertically partition a table in SQL Server
2000. Is a view built over the partitioned tables just as it is done in case
of horizontal partitioning? If no, then how are the different operations of
insert,update,delete performed?
What is better to use horizontal ...more >>
removing sql Posted by mike young at 9/18/2003 3:25:30 PM how do i remove sql from my win2k server in prep for a fresh install of
mssql?
...more >>
Trusted Server Connection between Access and MS SQL Posted by bdaltilio NO[at]SPAM yahoo.com at 9/18/2003 11:47:55 AM I have an Access 2000 DB that has an ODBC connection to a SQL 6.5
Server. The server is runing in Mixed Mode (SQL Authentication and NT
Authentication). I can open the ODBC connections if I use SQL
authentication (my SQL username and password). I cannot use a trusted
connection to open the Ac...more >>
ODBC connects with netbios name but not IP address Posted by Gio at 9/18/2003 2:26:07 AM Error occurs when setting up System DSN. When I put the
IP address in server name, specifying TCP/IP connection
at port 1433, I get this error:
SQLState: "HYT00"
SQLServerError: 0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.
But when I put the netbios name, it connects!
What's t...more >>
Behaviour of OpenDatabase method when SQL Server is shut down Posted by Achal Bhargava at 9/17/2003 7:38:28 AM Here is the sequence (using DAO and connecting to SQL Server with ODBC):
1) SQL server is running.
2) OpenDatabase() works great.
3) Stop SQL Server.
4) OpenDatabase() still works and shows no error.
5) Restart the application, the method throws the error.
Perhaps the method picks up the i...more >>
General problem with ODBC Data Sources Posted by Johan Elfman at 9/17/2003 2:31:16 AM Hi!
I have a problem with using my registred data sources. The
registration i Control Panel works fine and I have seven
registred data sources (including Excel Files, dBASE etc.).
The problem is that I can't use them when I try to access
them in Excel.
When I choose 'Data' --> 'Get Extarn...more >>
Simple Authentication Question Posted by allan at 9/16/2003 7:02:52 PM Hi,
I have a web server that I'm trying to use to connect to
a SQL Server. If I try to create an ODBC DSN to the SQL
machine, I get SQL Server Error: 1326.
If I open network neighborhood on the web server and
browse to the sql server machine, it prompts me for a
username/password to...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Lots of Login Failed events Posted by Nick Hoare at 9/16/2003 4:05:28 PM Tracing an Access application which has linked SQL tables, in the SQL
Server Profiler, I see a lot of failed login attempts but the
application works fine! There is a failed login attempt with my
username, then a failed attempt with 'Admin' and then the successful RPC
Completes (or whatever)...more >>
Need help importing data to SQL Posted by Dan B at 9/16/2003 2:05:34 PM Hi,
I have an Excel Spreadsheet with data that I need to get into a SQL
Database. What is the best way to do that?
Thanks,
Dan
...more >>
ODBC error Posted by Kevin Lofton at 9/15/2003 9:42:28 AM I was able to create a linked Oracle server using the SQL
server Enterprise Manager. When I creat a query I am able
to view the the data that was selected however I when I go
to save I receive the following error message: "ODBC error:
[Mircosoft][ODBC SQL Server Driver][SQL Server]The
oper...more >>
Can't connect SQL server through ODBC Posted by Ling at 9/15/2003 3:51:29 AM Hi,
I created a System DSN under Data Source (ODBC). However,
if I had input the machine name instead of ip address,
then it wasn't run proper. Prompt the message
Connection failed: SQLState:
'HYT00' SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired
I have ping ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |