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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|