microsoft.public.sqlserver.odbc
RSS FEED IDEMS: www.tech-archive.net: microsoft.public.sqlserver.odbc
- Named Pipe ODBC reverts back to TCP/IP in ODBC Data Source Admin
microsoft.public.sqlserver.odbc: Named Pipe ODBC reverts back to TCP/IP in ODBC Data Source Admin
- SQLPutData against MSSQL view
Summary:
I am trying to insert data into SQL Server view, ... using MDAC driver. ... The insert/update of a text or image columndid not ... I could not find any limitation about using SQLPutData against view column. ...
- Script to switch datasource?
Summary:
On one machine I have 2 applications that use the same ODBC System DSN. ... When I switch from one app to the other I have to go through the ODBC ... Connection interface and switch the database the connection is using. ...
- Accpac Plus Data by MS-SQL Data
Summary:
We would like to create an MsAccess.Mdb (or Sequel database) in office 2000 ... to obtain individual table details from Accpac Plus in Dos (an accounting ...
- Cannot Update Excel File Using ODBC
Summary:
Cannot update same Excel file. ... this forum regarding the need for a unique key, ... Or does a special column need to ... // Execute that query (implicitly by opening the recordset) ...
- slow ODBC connection Via VPN
Summary:
It connects with ODBC via a VPN to the SQL server. ... The VPN is a hardware IPsec tunnel (router to router). ...
- Slow Inserts over Internet using MFC
Summary:
I've got an MFC app, that needs about 1,5 to 2 minutes to insert 850 rows ... into a table on an SQL Express server. ... ret = SQLPrepare"INSERT INTO TABC ...
- Performance problem connecting to SQL Server through ODBC over the internet
Summary:
I have cable modems on both ends of the connection. ... the performance problems occur when returning as low as 100-250 ... 10MB/s network connection takes < 0.5 seconds. ... Packet size mismatch between internal network and internet. ...
- SQL 2005 Express with Advanced Services: missing providers
Summary:
I installed "SQL 2005 Express with Advanced Services with SP1" onto two machines with "Windows XP Pro SP2". ... On both computers I noticed that in SSMS Express, ...
- SQLNumResultCols returns 0 when MSSQL procedure has IF clause
Summary:
SQLNumResultCols returns 0 for following stored procedure using both SQL ... Here is the SQL Server procedure DDL: ... RETCODE retcode; ... ProcessLogMessages(SQL_HANDLE_STMT, hstmt1, ...
- Problem with way to access all recordsets returned by sp_spaceused using ODBC APIs on C++
Summary:
I have a problem executing a sp_spaceused on a database. ... Please execute sp_spaceused on your local database so that further ... column of the second recordset so not able to fetch the unused space. ... if (retcode!= SQL_SUCCESS) ...
- Help I am getting an error when I run my insert statement
Summary:
Microsoft OLE DB Provider for SQL Server error '80040e14' ... Incorrect syntax near the keyword 'Plan'. ...
- SQL2000 SP4 and 64bit server with JetDriver...
Summary:
query Foxpro tables via ADO components in Delphi. ... After installing the MSJet-Driver, the Jet driver ... I have seen some references by MS stating that the Jet driver is ... How else can I build a LinkedServer to connect and query those ...
- SQL2000 SP4 and 64bit server with JetDriver...
Summary:
query Foxpro tables via ADO components in Delphi. ... After installing the MSJet-Driver, the Jet driver ... I have seen some references by MS stating that the Jet driver is ... How else can I build a LinkedServer to connect and query those ...
- SQL2000 SP4 and 64bit server with JetDriver...
Summary:
query Foxpro tables via ADO components in Delphi. ... After installing the MSJet-Driver, the Jet driver ... I have seen some references by MS stating that the Jet driver is ... How else can I build a LinkedServer to connect and query those ...