Hi, I have set up a linked server on our SQL2005 using MSDASQL that maps to a system ODBC dns pointing to a Sybase server. The Sybase OLD DB Provider is very unreliable, so we have to use the ODBC thing. I can select, delete and update tables in Sybase using the linked server, but cannot d...more >>

Hi all, Looks like I inherited a little collation problem, and it's causing me headaches. This is a little involved, so please bear with me: Most of the CHAR and VARCHAR columns in the tables of this database are set to SQL_Latin1_General_CP1_CI_AS collation. A few are set to SQL_Latin...more >>

I'm writing a small app to bulk load some data and receiving strange results. Some of the data contains non-standard alphabetic characters, like the name Jose (with an accent over the e). It is being loaded into the table as JosT. The column is a VARCHAR(50), and it seems to work with reg...more >>

Whenever I try to make a pass through query in Access 2002 for Oracle sql server I get this fault "The microsof Jet engine cannot find table or query" and then mentions the connection string as table or query name. The query is not supposed to return records, because it is DROP TABLE <table_nam...more >>

Hi All, I am using SQL Server 2005 Developer Edition, the application is used ODBC to communicate with database, everything is OK in the beginning, but when the application running and data is filled into the tables, the size of the database increase, and now the size is about 11M, the sp...more >>

Hi Everyone, Ok, I'm pretty new to SQL Server. I installed SQL Server 2005 Express with extended option. I'm able to connect to it using Management Studio Express I was able to create a new DB and create a login user "demo" with password "demo". Gave full access to the new db. Now ...more >>

I am having a problem exporting a linked SQL server table from Access 2003 to Excel. The file is about 2,000 records with several columns. The problem is that when the table is imported into excel some of the records are not coming across with the correct data and when numeric fields are summ...more >>

Hi, I have tried to create my procedure by cut and paste the sample FTP get file using tsql from Author Nigel Rivett ( http://www.nigelrivett.net/FTP/s_ftp_GetFile.html). When I tried to execute it by passing parameter as below: exec s_ftp_GetFile @FTPServer = 'www.mysite.com' , @FTPUs...more >>

After installing Visual Studio 2005, SQL Express and other stuff I no longer can select my ODBC DSN name within MS Access 2003. When I link to a table in MS Access 2003 I should be able to change the File Type to ODBC from the standard file open dialog box and a new dialog box opens that perm...more >>

Hi, do you know the connection string for accessing a sybase DB from a Windows environment (more effective than odbc)? thx ...more >>

Hi, I've a Access 2003 program with linked tables to a sqlexpress configured with mixed mode security. From clients XP no problem. From clients 2000 MSACCESS don't get the right configuration from ODBC source, because try to conect with Windows Authentication Mode security, but the source is...more >>

Hello, I used SQL Server Enterprise Managers' Export Wizard with destination ODBC driver for SQL to create a dts package in the structured file format. I entered the following dtsrun line (msde 2000 sp3) dtsrun /S servSQL /U sa /P thepw /N db.dts and received the errors shown. ...more >>

Hi, I'm trying to insert a time stamp into SQL Server (2005) and can't figure out the right combination of column type and arguments to SQLBindParameter(). My C code currently looks like this: rc = SQLBindParameter(hstmt, 7, SQL_PARAM_INPUT, SQL_C_TYPE_TIMESTAMP, SQL_TYPE_TIMESTAMP, ...more >>

Hi there! I have a Sql Server 7 running on a webserver. Now I have a quite complicated query that I run on 4 ways. 1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds (done this about 10 times) 2. Using OLEDB-driver directly on the Sql Server. time to execute: 12 ...more >>

I am able to connect to a database set up on SQL windows 2003 under IIS. However I get an error message when I try to create a table. I am running from php. I am sure I am doing something stupid but I can't see it or could it be a permissions issue? Error - Connection to Database members ...more >>

Question - I have a little app that uses the ODBC Bulk Operations and DB-Lib bcp functions to load data into a table from variables (bcp_sendrow). It works great on SQL 2000, but I'm encountering some problems on SQL 6.5. Basically on the SQL 6.5 box the bcp_init function is returning FAIL in...more >>

Hi, We are writing a Java stand-alone program and need to connect to a SQL server 7.0 database. I can't find any drivers to connect to the database. There are very few which are in the market with interoperability with MS SQL Server7.0. The rest are all pointing to MS SQL 2000 or 2005. ...more >>

ok heres the scenario. I have my SQL2000 server on a Windows 2003 and its also on a AD2003 domain I have another server with is Windows 2003 and it was on the AD2003 domain but I had to put it in a workgroup for security reasons. Now my server cant get to the server server anymore. I can p...more >>

I have posted this across several newsgroups. I hope that this finds an answer in one of them. Hello, I have a client that is having this issue: Server 1 SQL Server Database FrontPage Server 2 IIS 6.0 with ODBC connection to database While running a query on the Enterprise Manag...more >>

Hi I hope someone here can advise or at least point me to a good site to pursue this. Have installed a password protection system (freeware) successfully on a unix/php/mysql server and looking forward to developing it into a full blown database application. I is written in php and use a mys...more >>

I would appreciate any help I can get. I'm no expert at ASP or SQL, but I've done a little research and I feel like I'm doing things right. I'm getting the following error message from my ASP page. Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (ParseCo...more >>

Hello everybody, I have installed SQL Server Express and uploaded an access database into it. It's running properly. The problem is that I'm trying an VS-6 application to connect to it using "SQL Native Client" I can connect if I use a "USER defined DSN", but can not if I try to write conne...more >>

sp_provider_types_rowset and some other stored procedures keep being executed We recently experienced a very interesting problem. When connecting to SQL Server 2000 (SP4) using ADO, after the recordset is retrieved, we can see the following stored procedures kept being executed every we su...more >>

Hi, I'm trying to refresh (re-read) the current row of an forward only cursor but SQLFetchScroll and SQLSetPos will fail for this kind of Cursor. Is there any way to do that? Regards, Michael Sterzl[GSD] ...more >>

Im having trouble putting all of this together, but here is the scenario ASP page with a Query String Variable, Example: http://mywebsite/mywebpage.aspx?variable=x now i need to query using openquery across a linked server using this variable. Like: SELECT COLUMN1, COLUMN2 FROM ...more >>

We are using an application that connects to SQL Server 2000 SP4 using ODBC. During this I noticed several executions for sp_datatype_info stored proc. Why it is necessary and is there any way to stop or reduce this execution? ...more >>

Hi everyone, I set up a customer error messge and auto email which record form data and error details on our web site in order to proactively to monitor what's going on for eCommerce site. Today, I got one message like this: * Line, Column:447, -1 * Description: [Microsoft][ODBC SQL Serv...more >>