Hi All, I need help to import dbf files into sql or msde database The dbf file is currently managed by sql server Please suggest how can we import data from dbf file into sql or msde Regards Samir Shah ...more >>

Is it possible to open a SQL Server connection using domain credentials that are not your own? In ODBC dialog, you have the option for Windows Authentication (your own domain account - this works, but not what I want) or SQL Authentication. In SQL Server, I have a login created as a domain...more >>

I have both SQL2005 and SQL2000 installed in the same machine. When I am trying to configure a ODBC connection to SQL2000 database, using SQL2000 driver, I do not see the SQL2000 in the list of servers. Please let me know how I can make it available in the list of servers....more >>

Application roles don't work well from Access because the ODBC driver opens additional connections under the covers that do not have the application role activated. -Mary On Wed, 24 Oct 2007 09:19:01 -0700, Dedge <Dedge@discussions.microsoft.com> wrote: >I have created an Application Ro...more >>

Is there any way to add our standard System DSN or equiv, ODBC connections on XP clients via scipt or GPO? THis cannot be the first time this question has been asked but I cannot find a satisfactory answer. Thanks in advance!...more >>

In some computers, just a few in thousands, appears the following message when try to login in SQL. Connection failed: SQLState: ‘S1T00’ SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver]Timeout expired I am using a ODBC string to connect to DB. This happened in two computers, ...more >>

An update on this issue, I am still experiencing this slowness problem. I have tried from executing the maintenance processes, to checking the codes of the MS Access 2003 application. One new thing that we found is that if we access the MS Access application from one of the workstations vi...more >>

i just want to ask quite basic question that what when data is commuicated between DB and application , where odbc driver plays its role, if we use ..net provider for odbc or u can place this question as whats the relation between .net provider and odbc driver? Its quite simple question ur ans...more >>

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Ser...more >>

I have created an Application Role with DEFAULT_SCHEMA=dbo. From MS-Access, I retrieve the AR password and execute sp_setapprole as follows: qd.Connect = strODBCConnect qd.ReturnsRecords = False qd.SQL = "exec sp_setapprole 'MyAppName','" & strAppRolePWD & "';" qd.Execute Fine un...more >>

I Want to select from an MSSQL-Server datatbase and realised, that if i do not use the flag mentioned above, the select takes much longer I'v got 2 tables with indices: create table XXX (S1 varchar (30) NOT NULL PRIMARY KEY, S2 int NOT NULL) create unique index Idx_X1 on XXX (S2) create t...more >>

On Oct 20, 11:47 am, Milto...@gmail.com wrote: > i dont connect db (sql server 2005) in vista. why? > i have a cod in asp and no conect database. > > the error is: > > "Microsoft SQL Native Client Version 09.00.3042 > > Running connectivity tests... > > Attempting connection > [Microsoft...more >>

Hi all, We are doing a survey to collect information on middleware usage and some features of the middleware. Through the survey data as one source of information, we can do research on middleware, and software engineering trend analysis and prediction. Please take out some minutes to fill i...more >>

i dont connect db (sql server 2005) in vista. why? i have a cod in asp and no conect database. the error is: "Microsoft SQL Native Client Version 09.00.3042 Running connectivity tests... Attempting connection [Microsoft][SQL Native Client]TCP Provider: No connection could be made bec...more >>

i dont connect db (sql server 2005) in vista. why? i have a cod in asp and no conect database. the error is: "Microsoft SQL Native Client Version 09.00.3042 Running connectivity tests... Attempting connection [Microsoft][SQL Native Client]TCP Provider: No connection could be made bec...more >>

Thanks for that Paul - this looks useful! Pete "Paul HR" <phototopix@test.com> wrote in message news:%23ee45LKEIHA.3980@TK2MSFTNGP03.phx.gbl... > I'm not sure about a fix for the specific issue you mention above but > i've found this post providing details on making the connection via ODBC...more >>

Is there somewhere I can get a handle on the common 'problems' found using odbc to interface with an sql server 2005 database? I need to program a database layer, and I know there are idiosyncracies between various drivers, and I'd like to figure out if any of them can be handled via some confi...more >>

I'm not sure about a fix for the specific issue you mention above but i've found this post providing details on making the connection via ODBC between MSSQL2000 and MySQL. http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx Hope this helps. Paul *** Sent via Developersdex h...more >>

I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com ...more >>

Hello, All I am getting the following problem trying to insert value in the MS SQL 2005 table that has trigger on insertion taking some time to execute (it inserts 1000 records in another table). The problem is that SqlExecDirect returns immediately while trigger is still executing, causin...more >>

Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/s...more >>

Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels The s...more >>

Can you just do an end run around PB and push it into the SQLS table directly from Access? That would be my recommendation. -mary On Thu, 11 Oct 2007 13:00:01 -0700, jaylou <jaylou@discussions.microsoft.com> wrote: >Dont shoot the messenger.... >I inheited a system that uses an Access MD...more >>

What Operating System, Service Pack on the OS and NIC Card do you have on both sides of the conversation? ------------------------------------- Chris Alton, Microsoft Corp. SQL Server Developer Support Engineer This posting is provided "AS IS" with no warranties, and confers no rights. ------...more >>

Dont shoot the messenger.... I inheited a system that uses an Access MDB as the front end with local tables in it. There is a SQL server 2005 database which pulls data from the Access tables and inserts into SQL tables to create invoices. Information is keyed into Access, at the end of the ...more >>

Hi folks, I'm having a spot of bother creating a linked MySQL server on SQL2K. I'm using the following code on an SP4 SQL2K instance. MySQL 5.1 is installed on the same box, and I've installed the MySQL ODBC 3.51 Driver. sp_addlinkedserver 'myAlias' , 'MySQL' , 'MSDASQL' , Null ...more >>

Hello, I found helpful suggestion in microsoft forum, and try to increase windows virtual memory. Hope it help. Will be back to reportthe result later. More suggestion is appriciate, Thank you in advance, Uma "Uma" wrote: > Hello ! > > Anyone, please help. > > I got the error ...more >>

Hello, I found helpful suggestion in microsoft forum, and try to increase windows virtual memory. Hope it help. Will be back to reportthe result later. More suggestion is appriciate, Thank you in advance, Uma "Uma" wrote: > Hello ! > > Anyone, please help. > > I got the erro...more >>

I just found some helpful suggestion in the microsoft forum. I try to increase windows virtual memory, don't know if it works. I'll be back to report later. More suggestion is appriciate, Thank you in advance, Uma "Uma" wrote: > Hello ! > > Anyone, please help. > > I got the e...more >>

Hello ! Anyone, please help. I got the error 08501 : [Microsoft][ODBC SQL Server Driver] Communication link failure, when I connect to database in SQL Server via some application and it happened very very often. I'm trying to find the way to solve on internet, but could not. Please su...more >>