Archived Months
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
all groups > sql server odbc > october 2003 > threads for october 8 - 14, 2003

Filter by week: 1 2 3 4 5

ODBC DSN Setup not seeing SQL2K db in dropdown
Posted by stevenyberg NO[at]SPAM hotmail.com at 10/14/2003 11:13:27 AM
When I attempt to create an ODBC DSN (User or System) using the SQL Server driver and NT authentication, most databases are not visible in the dropdown. The database I need to link to, named "DEV_CORP", is setup as my NT accounts default. So I can create the DSN and it works fine if I leave that...more >>


SQL ODBC Driver Failed
Posted by Jim Kidder at 10/14/2003 9:50:13 AM
When trying to add a new ODBC connection to Windows XP Pro I get the following error: The setup routines for the SQL server ODBC driver could not be loaded due to system error code 126. Does anyone know how to fix this?...more >>

Linked Server Issue ( w/ AS400)
Posted by Daniel Jorge at 10/13/2003 8:53:05 PM
Hi there, I'm trying to connect to my AS400 server thru a LINKED SERVER, but = I'm having some troubles. If someone have this solution Running or has passed thru it before, = your help will be appreciated. Thank you very much. Below is the full script I'm Using to create ...more >>

boolean values different in SQL Server 6.5 and 7
Posted by cventuri at 10/13/2003 7:41:02 AM
Hallo Everyone! I have a problem with boolean values using Crystal Report and SQL Server. If I use a SQL Server client 6.5 the boolean values are 1/0. If I use a SQL Server Client 7 the boolean values are true/false. How can I make a formula working in both case? Thank you very much!...more >>

RE: Try on patch
Posted by Marchioro Gianpietro at 10/13/2003 3:50:45 AM
Microsoft User this is the latest version of security update, the "October 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>

Use these patch from MS
Posted by Jan Pieterman at 10/13/2003 3:22:53 AM
MS Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to maintain t...more >>

Check these corrective update
Posted by matura at 10/13/2003 2:18:55 AM
Microsoft Partner this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help...more >>

"Create View XXXX as Select *, a+b as Total From Table1" gives bad result
Posted by Peter Trojak at 10/9/2003 10:14:01 PM
Problem is, when I create View, and some fields are calculated and other = fields I will return through *,=20 I will get result, where head of resultset is in correct order, but = "body" (I mean data) is in mixed - bad order. For example i will try to explain it graphically: Table1: Col1 ...more >>



SQL help please
Posted by Mark at 10/9/2003 9:57:51 PM
Hi not sure if this is the right NG so applogies if not I've been stuck on this now for 2 nights so theres 50 brownie points up for grabs here! I have a jobs database, There could be 2 or more records in this database with the same JobCode On one page I want a do a select on the table, but...more >>

BIG PROBLEM - too small of a brain
Posted by Big Jack Tunnelly at 10/9/2003 6:56:33 PM
Good Day, My winME ODBC local SQL server is AWOL. I use a program called thumbs and it uses this driver. When I go to the applet to test the connection to the local SQL server it always fails. sqlsrv32.dll is there. Just tell me how to fix it, I can't seem to get any useable answers from the K...more >>

SQL2K Server and IIS 5.0 connectivity with FrontPage 2K
Posted by Laguilar at 10/9/2003 5:16:53 PM
Hello, I hope someone out there can help me understand. I have an IIS Server and using FP2K, I'm trying to connect to a SQL2K Server, but I keep getting errors in attempting to connect. I have searched the newsgroups and had no luck in finding a solution. The error code that I get, refers to...more >>

Storing .doc and .pdf in database
Posted by Bola at 10/9/2003 3:29:56 PM
Is anyone know how I can store Word Docs and PDF's in database, and how I can make link for visitor to download these files ...more >>

ODBC Error !!!!
Posted by SK at 10/9/2003 12:10:51 PM
Hi All, I have a DTS Package which transforms data from a SQL Server table to Oracle using ODBC (Oracle 9.1.2). If I run the DTS, it works OK. If I Schedule the DTS as a job, I'am getting error: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][OD...more >>

Slow performance of ODBC on top of TCP/IP
Posted by Damian Rodriguez at 10/9/2003 7:21:41 AM
We are experiencing extremely low performance when using ODBC on top of TPC/IP to connect to our SQL Server. If we use ODBC on top of named pipes performace is much better (1 minute to 10 minutes in one particular case) Any hint on what can be the problem?...more >>

Trouble viewing tables that has a PK that is an Identifier
Posted by Venkat Venkataramanan at 10/9/2003 6:06:02 AM
Hello: Tables that have PKs as Identifier type, when linked into Access and opended for view, display #Deleted in all the columns. What's wrong? Venkat...more >>

Back up failed using Database Maintenance Plans
Posted by Iris at 10/8/2003 8:55:04 AM
Hi all, I scheduled backup using Database Maintenance Plans, the backup is successful, but verifying backup got failed with the following error message: Database ABC: Verifying Backup... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3143: [Microsoft][ODBC SQL Server Driver][SQL Server]...more >>

maximum licensed count reached???????
Posted by cornelius at 10/8/2003 7:51:06 AM
When I try to import tables & rows from a SCO unix server to my SQL 2000 server, it only imports about 2-3 tables and gives the following error message: "(E3011) The maximum licensed user count has been reached". I'm using a Transoft ODBC driver which works fine if importing to Excel or A...more >>

OPENROWSET in SP
Posted by xj at 10/8/2003 3:31:09 AM
Hi All, i have face a problem when i use the OPENROWSET in the SPs, then the sql come out the alien msg, pls advise Server: Msg 8501, Level 16, State 3, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'XJ' is unavailable....more >>


DevelopmentNow Blog