all groups > sql server odbc > january 2005 > threads for january 22 - 28, 2005
Filter by week: 1 2 3 4 5
MDAC error on VFP linked server
Posted by Michael at 1/28/2005 9:03:32 PM
I have a linked server pointing to a folder where foxpro tables exist.
The tables are listed when I click on the linked server/tables.
However I get this error when in query analyer I say: select * from
vfplinked...clients
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or cata... more >>
OLEDB & Recordset
Posted by Glynn at 1/28/2005 5:40:27 PM
Hi Guys,
I'm busy trawling through documentation trying to puzzle out an issue I'm
having. Am about to tackle the SDK.
OK, I'm using MDAC 2.8. Visual Basic 6 and SQL2000 SP3a.
If I execute the following code through a normal ODBC connection (In Admin
tools), I get a result. Works fine.
... more >>
Database performance
Posted by Marco Pais at 1/28/2005 12:27:17 PM
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the... more >>
Using DAO???
Posted by Matthew Wells at 1/26/2005 2:22:39 PM
I've heard that using DAO (without JET) with an ODBC workspace using SQL
Server is just as fast as using ADO that ADO is really an abstraction of
DAO - that the only advantage of using ADO is managing session data. Can
anyone verify this?
Thanks.
Matthew Wells
MWells@FirstByet.net
... more >>
ANSI to Unicode(MSSQL) convertions
Posted by Aras Kucinskas at 1/26/2005 12:12:08 PM
Hi,
How to convert and transfer ANSI string data from FoxPro table to MS SQL
Unicode table. Data in FoxPro are in 1251 codepage (Russian Windows). Now
result is like "ÊÎËÜÖÀ ÊÎÌÏÐÅÑÑÎÐÀ 100ìì ".The ODBC driver does not
performs the conversion from ANSI to Unicode.
Help.
... more >>
Access/SQL "Write Conflict"
Posted by Roy Roes at 1/25/2005 11:43:33 PM
Hello,
I'm using a Access 97 Front-end and a SQL Server 2000 back-end.
When entering a subform on a form, information has to be saved to the
database.
But when entering the subform I get a "Write conflict" error in Access.
In SQL I'm using 3 tables with 1 view defined on those 3 tables. I u... more >>
Different Collation designator Settings
Posted by Shadow at 1/24/2005 10:32:59 PM
Greetings,
In our company we have different kinds of SQL databases and SQL servers. We
are trying to consolidate those servers under a couple of powerful servers.
But when we began to tell this project to software houses and ask their
idea; we met a big problem .
Some of those companies ... more >>
importing tables from Acess to SQL
Posted by גל at 1/23/2005 1:29:01 AM
Hello
I am trying to import tables with data from Access to SQL.
The problem occures when the Primary keys and identity are not being saved
and i need to do it manually.
There is a way to import this tables with all the connection regulations
like Primary key will be saved ?
thanks
G... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|