Old code not able to connect to unicode instance
Tue, 25 Sep 2007 11:18:27 +1000
Hi,
I have a program written in C/C++ compiled with MS Visual Studio 6.0 that
fails to connect to a french SQL Server instance (probably a 2005 instance)
with "SQL Server does not exist or access denied".
I can connect to the instance with SQL Server Management Studio with no
problems.
Is the OLE inte ...
|
restrict delete permission
Mon, 24 Sep 2007 10:30:01 -0700
i have the odbc connection connected to our SQL databasse via sql user
account through MS access Frontend and having problem controling the delete
function of the account.
In SQL i am only allow the account to read, insert,update and denied delete
on the database and tables. However, the account still be ...
|
Latest ODBC drivers for SQL Server 2005
Mon, 24 Sep 2007 13:18:13 -0400
Hi Group,
Greetings. I have some trouble loading NTEXT data into a SQL Server 2005
server using IBM Datastage. I have setup a DSN using SQL Server Driver for
my applications and IBM Support has requested me to check if there might be
any latest version of the ODBC drivers from Microsoft. The driver version I ...
|
OLEDB-ODBC-iSeries linked server. Select is fine, Create-Update-Delete do not work
Mon, 24 Sep 2007 13:04:04 -0400
I have AS400 database attached as a linked server to my SQL2005:
EXEC master.dbo.sp_addlinkedserver @server = N'THE', @srvproduct=N'THE',
@provider=N'MSDASQL', @datasrc=N'THE'
"THE" is the ODBC DSN pointing to the specific ip.
I have no problems retrieving the data from the linked server this way:
se ...
|
Re: Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN.
Thu, 20 Sep 2007 08:50:54 -0400
Differences between odbc dbase and sql required adjustments to table design
and filters.
Thanks anyway.
"CharlesC" <Charles@bscinforma.com> wrote in message
news:uiHvlFjyHHA.1176@TK2MSFTNGP05.phx.gbl...
> Hello,
>
> I imported dbf files (dbase) into an msde database.
>
> I see the tables with the data in ...
|
Linking Access 2003 to SQL 2005
Wed, 19 Sep 2007 13:24:00 -0700
I have read numerous posts on this topic, but to no avail. I have several
Windows XP Pro desktops (SP2) and a new server running Server 2003 (SBS) with
the full version of SQL 2005. I have a split MS Access program with the FE
residing on the desktops and the BE on the server. The Access program gets
info ...
|
ODBC & Remote SQL Server
Mon, 17 Sep 2007 22:07:47 -0700
Hello,
How to create system DSN (ODBC) on windows 2003 for SQL Server located
on remote machine ?
Please, guide me.
Bye.
...
|
|
|
SQL 2005 backups issued through ODBC failing
Tue, 11 Sep 2007 17:45:51 -0000
Hi,
I have some piece of software that issues backups. The connection is
done through ODBC.
Once in a while, when backin up 2005 databases, I get a 3041 error in
the error log and no backup file is written. It never happened on SQL
Server 2000.
I read that there are some issues with ODBC, SQL 2005 and ba ...
|
MSSQL2005 64 bit + Client ODBC
Fri, 7 Sep 2007 12:51:17 +0800
Hi,
If I have a Intel x86 64 bit server, installed Win2003 64bit OS + MSSQL2005
64 bit version, and the client running Intel "Core2 Duo" (32 bit), installed
WinXP Prof, is the client able to connect to MSSQL2005 64 bit Database thro
ODBC drivers?
Thanks.
...
|
Fastest Fetch for Client Application
Thu, 06 Sep 2007 12:45:21 -0700
I'm a total luddite and am writing a brand new C++ ODBC application
for numerical analysis against a SQL Server database. I'm not using
MFC or ATL or any foundation classes whatsover. It's just C++, my
little ODBC wrapper (and a thin one at that), and a few things I wrote
to do lots of multithreading.
Now, I ...
|
