all groups > sql server odbc > january 2004 > threads for january 1 - 7, 2004
Filter by week: 1 2 3 4 5
ISQL - problem
Posted by Michael K at 1/7/2004 11:08:46 PM
Not sure if this is the right place for this posting, sorry didn't find
anything better.
Anyway here is my problem. Trying to move from SQL7 to SQL2000.
Some of processes using isql by shelling batches with isql from several
machines.
Here how it looks like;
isqlrun.bat
path =\\SERVER7\... more >>
Creating odbc dsn's
Posted by Sean at 1/7/2004 4:18:34 PM
I'm like to create some sql server odbc dsn's by using a script.
does anybody know if can this be done,,,
... more >>
ODBC Connection Hangs after 15 minutes of non-use
Posted by Bob at 1/7/2004 3:23:30 PM
I have several workstations that login to a WIN_2000 Server and Connect just
fine to a SQL-2000 Server (different machines) over a dedicated VPN.....
They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing scheme.
Everything works beautifully for a while.
My application runs a Mai... more >>
SQLPutData problems with new version of SQL server drivers
Posted by Charles Gamble at 1/7/2004 6:41:03 AM
Hi,
We are getting problems when using SQLPutData with SQL
Server 2000. Our system uses C++ COM objects resident in
COM+.
We are getting unhandled exceptions in Release builds of
our COM objects only when we call SQLPutData with more
than 2 columns being set via the putdata mechanism.
... more >>
Importing Data Throught ASP
Posted by Anubis at 1/6/2004 11:47:23 PM
Hello,
I've been trying to work with code to import data from a "flat file" (.csv)
into a SQL 2000 table.
I'm not that well versed in SQL and was wondering is it was possible using
OPENROWSET or something similar?
I've tried using OPENROWSET and encountered the error "Ad hoc access to OLE... more >>
Stored Procedure permissions issues
Posted by cb at 1/6/2004 4:54:59 PM
I have a user who is upgrading her workstation. On her windows 2000, Office
2000 machine the applications work fine.
On her WinXP OfficeXP box, the application opens up, but eventually suffers
a permission error on a storeprocedure. What gives?
She is logging in as the same AD user who has r... more >>
Please help-ODBC Error
Posted by Lucy at 1/5/2004 6:41:10 PM
Folks - please, I desperatly need your help and ideas
We recently installed a SQL Server in our DMZ.
The DMZ servers are part of a DMZ workgroup and not a part of our internal domain
I must have an ODBC connection between this SQL Server and my PC so I am able to use MS Access Version XP to rev... more >>
QueryTimeout Property problem
Posted by Anita at 1/5/2004 2:50:58 PM
Hi All,
I have a problem with QueryTimeout property.
When I set cn.QueryTimeout = 2 (not zero)
and the time out really come then no runtime
error appears (I expect run time 3669,
execution canceled). This makes my application
works wrong.
If I set cn.QueryTimeout = 0 then it works.
Bu... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Out Of Memory
Posted by Amanda at 1/5/2004 12:24:02 PM
I'm trying to connect to a SQL database with an ODBC
connection. When I try to access the database I get
an "Out of Memory" error from Microsoft Access.
It won't load anything.
Any Ideas?... more >>
Text Editor
Posted by Rose Roland at 1/4/2004 6:00:19 AM
Do I need Front Page to manipulate text. I have Excel and
just installed MSSQL on my computer.
I just want to manipulate text to output Hello World.... more >>
|