all groups > sql server odbc > september 2007
Old code not able to connect to unicode instance
Posted by John at 9/25/2007 12:00:00 AM
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.
... more >>
OLEDB-ODBC-iSeries linked server. Select is fine, Create-Update-Delete do not work
Posted by Dmitry Duginov at 9/24/2007 1:04:04 PM
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 serve... more >>
restrict delete permission
Posted by Sang Nguyen at 9/24/2007 10:30:01 AM
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 ... more >>
Linking Access 2003 to SQL 2005
Posted by BackthePack at 9/19/2007 1:24:00 PM
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 pr... more >>
ODBC & Remote SQL Server
Posted by pradeep at 9/17/2007 10:07:47 PM
Hello,
How to create system DSN (ODBC) on windows 2003 for SQL Server located
on remote machine ?
Please, guide me.
Bye.
... more >>
MSSQL2005 64 bit + Client ODBC
Posted by Markco Wong at 9/7/2007 12:00:00 AM
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.
... more >>
Fastest Fetch for Client Application
Posted by stork at 9/6/2007 12:45:21 PM
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 multithr... more >>
error setting up ODBC for remote sqlexpress database
Posted by ruth at 9/5/2007 9:08:00 PM
I am using SQL Server Express and have a database on the server. I have no
trouble setting up the ODBC for the local machine. It works fine. When I try
to set it up on another computer to access the database on the server, after
the screen which asks for a login and a bit of a wait, I get erro... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|