all groups > sql server odbc > july 2005
SQL server connection in a wireless atmosphere
Posted by awj at 7/29/2005 5:48:01 PM
We are running a dedicated program that uses SQL server in an ad hoc
invironment between multiple laptops. The OS is Windows 2K pro.
The problem we are having is that the SQL connection is being lost even
though the wireless connection is intact.
Does anyone have an idea what may be causing t... more >>
Data from Excel into SQL
Posted by Paul Smith at 7/29/2005 12:00:00 AM
Please excuse the cross posting I was not sure which newsgroup would produce
the required advice.
I have a requirement to update a SQL table with data from an Excel
worksheet.
Can anyone suggest the best way to do this....ADO?????
PWS
... more >>
Troubles to connect sql server 2000 on winXp-sp1
Posted by luismiqui at 7/28/2005 7:06:02 PM
I cant connect my sql server by ODBC to some pcs with WinXP-SP1
Anyone know how I can accomplish this?
I have Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)... more >>
utility to stress test
Posted by Edgar -MBNS.NET at 7/28/2005 4:20:03 PM
is there a util from Microsoft to test the sql server to find out how many
clients it can take w/o significant drop in performance?
... more >>
Access Front-End
Posted by HSP at 7/21/2005 8:27:04 AM
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?
... more >>
[Microsoft][ ODBC SQL Server Drive ] Timeout expired
Posted by Manish Acharya at 7/18/2005 3:34:02 PM
I am running a VB application which makes connection to the SQL server
database using DSN connection using ODBC. This application pulls data using
stored procedure. The application does not insert / delete / update data.
The application was working fine since it has been installed (more tha... more >>
Error "Cannot start transaction while in firehose mode" in terminal server hosted legacy application...
Posted by SammyBar at 7/16/2005 2:33:50 PM
Hi all,
We have a legacy client-server client application (developed with Centura
SQL Windows/32) that connects to a SQL Server 2000 database. In our LAN it
works without mayor flaws. Recently we added support to some remote offices
by using W2K terminal server. The decision was not to allo... more >>
Strange SP Problem
Posted by Neil at 7/14/2005 12:00:00 AM
I have a strange situation. I have a stored procedure that is hanging upon
execution, but only some machines and not others. The db is an Access 2000
MDB using ODBC linked tables and a SQL 7 back end. The sp is executed as a
pass-through.
The sp is fairly simple:
UPDATE CUSTOMER
SET Las... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Profiler defaults to master database
Posted by Bruce D. Meyer at 7/13/2005 8:50:34 AM
I am not even sure I can do what I am hoping but, I need to debug a complex
sql query. I was hoping to be able to load it in profiler and step through
it. oddly, right off the bat it errors out telling me the table I am
referencing is not found in the database master, which is correct. My ODBC
c... more >>
Transaction Log filling up
Posted by myaffee at 7/12/2005 11:49:09 AM
Hi, we have an application that is sending a large number of insert
statements (>5000) through ODBC to a SQL Server 2000 database. Apparently
this is causing the transaction log for that database to fill up which then
causes the web site that depends on that database to crash. We keep
increa... more >>
SQL Beta Problem
Posted by victorsk at 7/12/2005 8:50:01 AM
Hello,
I am trying to connect to a SQL Beta Database from Mapinfo using Integrated
Windows authenication, but I am getting error:
Connection failed:
SQLState: '08001'
SQL Server Error: 11001
[Microsoft][SQL Native Client]Client unable to establish connection
Connection failed:
SQLState:... more >>
SQLDriverConnect crash
Posted by JUNK at 7/11/2005 12:00:00 AM
I tried to connect to a local SQL server database using SQLDriverConnect in
a VC++ project, on a Windows 2003 OS. It is an unicode project. Everytime
the code reaches SQLDriverConnect it crashes. try catch block did not work.
I tried to pick up some samples from websites and found that none of ... more >>
Writing custom odbc driver.
Posted by avijit at 7/9/2005 12:08:01 PM
Hi
I am trying to write a custom odbc driver for one of my application.
The application is called data mediator which mediates between various
datasources . I have already developed JDBC driver for this application.
Now I want to develop ODBC driver so that any ODBC compliant application can
... more >>
ODBC SQL Server Driver[Shared Memory]ConnectionW
Posted by trans53 at 7/9/2005 3:35:38 AM
Hi all, question for you please :
We have client app. running on the same server as SQL and using LPC as
a network library.
Very often we have the error message bellow and application just
crash.
What can be a problem in this case.Your help is greatly appreciated.
Thanks.
2005/06/07 12... more >>
problem with large number of inserts
Posted by myaffee at 7/6/2005 9:27:02 PM
We have an application that is connecting to our SQL 2k server remotely via
ODBC and sending a large number of individual insert statements. Apparently
this is causing problems with the transaction filling up on the sql database
the inserts are being sent to. To solve the problem, we set the t... more >>
Time Out Issue
Posted by Travis at 7/5/2005 7:30:01 PM
Hi ,
I create a ODBC for SQL Server 2000 and use VB 6 to connect it. When I
pass it the sql query in vb and process the recordset , I am getting an error
"Microsoft ODBC SQL Server Driver Timeout expired". Where can I set the
time out in the ODBC ? TQ.
--
Travis Tan... more >>
|