all groups > sql server odbc > november 2005
ODBC using SSH
Posted by Bahman at 11/29/2005 9:02:02 AM
Hello!
I am trying to use the ODBC services via an SSH connection.
What is the easiest way of doing this? Are there any ready-made software out
there than I can use to connect?
Thank you!
-Bahman
... more >>
attempting to create a linked server to MySQL
Posted by Sean Moore at 11/21/2005 9:08:43 AM
We attempted to create a link server between an MSDE database and MySQL 4.1
database using ODBC. However, whenever we attempt to look at the tables
associated with the link we are greeted with the message: Could not create
an instance of OLE DB provider 'MSDASQL'. OLD DB error trace [Non-inter... more >>
about multiple clients
Posted by Xianju at 11/19/2005 7:27:02 AM
I have a sql server application program developped with ODBC. The program can
run at different computer and realize synchronization operation. But
sometimes it has error message :
"Attemp to scroll past end or before beginning of data".
Could you tell me the reason ? ... more >>
column collation
Posted by Lijie at 11/16/2005 12:52:50 PM
Hi,
I am using C++ to develop an application to support SQL Server 2005. I have
a problem whant I use SQLColAttribute function. It only returns "Collation
Name", instead of the real column's collation name. Does any body has any
idea?
Here it is my code:
retcode = SQLColAttribute(hand... more >>
Problems with a JET-ODBC-Connection and Access97-Runtime
Posted by Andreas Lauffer at 11/16/2005 1:29:54 AM
I have a very strange problem with a JET-ODBC-Connection.
Using Access97-Runtime, we connect the table with a
DSN-less-ODBC-Connection to SQLServer 2000 SP3.
The Application runs on a Windows Server 2003 Terminal-Server with
CITRIX Metaframe.
Office 2003 is also installed (no Access2003)
And n... more >>
about GetODBCFieldInfo (MFC)
Posted by Xianju at 11/14/2005 9:31:03 AM
I use ODBC to operate SQL Server 2000. I want to know the data type for each
column in a table. But for image data, text , varchar.... , all the return
value are negative.
In addition, how can I realize a table structure copy with ODBC ?
Any suggestion?
Thanks.... more >>
Invalid Descriptor Ind
Posted by Saqib Saleem at 11/11/2005 9:49:01 PM
I am using Crystal Reports 8.0 in Visual Basic 6.0 With SQL Server 7.0.
When I pass the parameters to the report to see the results the following
error message appears
"ODBC Error : [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"
Can anyone help me.
Saqib... more >>
Error connecting to SQL Server 2005 Express from Access
Posted by Chris Burnette at 11/11/2005 10:45:09 AM
I am trying to connect to SQL Server 2005 Express from Access using a
DSN-less connection string, but I keep encountering errors. What happens is
that I have a login form with 2 text boxes for users to enter their username
and password. When they have entered them, they click OK and Access t... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem with DTS reading from spreadsheet
Posted by Andy S. at 11/8/2005 6:08:57 PM
Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I have
a spreadsheet where I read a range, and some of the cells show up as blank
even though there are values in them. If I alter the cell and res... more >>
SQL server 2000 installation
Posted by Nada Sherief at 11/7/2005 3:57:26 PM
hello,
1-I want a detailed step by step tutorial for installing SQL server 2000.
2- I want to install two SQL servers 2000 on the same machine, how could
i do that? (i mean will there be any change in the installation to the second
server?)
3- I want to know how to connect between these t... more >>
derived horizontal partitioning on SQL server 2000
Posted by Nada Sherief at 11/7/2005 3:47:44 PM
hello
i want someone to help me in solving a problem in sql server 2000
considering that i have a table named PAY(TITLE, SAL) where TITLE is the
primary key of this table
also this table is related to another one named EMP, where the other table
has a foreign
key to this table.
ta... more >>
Error 165 - Sql state Hy000
Posted by Pupo at 11/7/2005 9:42:44 AM
Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
... more >>
SQL Profiler: Attention Event class on DELETE statement - why?
Posted by j.a. harriman at 11/4/2005 1:16:02 PM
Hello,
I have a C++ app that is connecting (ODBC 3) to a MSSQL db.
I am issuing a DELETE statement where a "last update date" is less than the
program begin date/time.
The problem is that all of the rows on the table that are supposed to be
deleted, are not being deleted. This isn't an iss... more >>
Locks per File
Posted by elf at 11/4/2005 9:54:12 AM
For some time, I have been trying to determine why we are getting
timeouts under certain conditions using an A2003 front end, SQL2000
backend. I have recently seen several quirky conditions related to a
too-low setting of maxlocksperfile.
Can that setting perhaps cause a timeout if the pro... more >>
MS SQL ODBC Enterprise manager
Posted by dbctl at 11/1/2005 1:44:03 PM
My hosting service is supplying the space on a MS SQL ODBC server for my
phpBB forum so I don't have a SQL server CD-Rom. Is it possible to only get
the Enterprise manager not the sever package? If not where do I purchase this
at?
Thanks,
dbctl
... more >>
|