|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
No Microsoft Text Driver for sql 2005 x64 Posted by josto at 3/30/2007 7:18:02 AM HI,
I'me having the error The OLE DB provider "MSDASQL" has not been registered.
for the OPENROWSET command :
select * from
OPENROWSET( 'MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=c:\; ', 'SELECT * FROM [ea.csv]')
On the odbc manager (%SystemRoot%\system32\...more >>
ODBC Port Posted by Adam Sankey at 3/29/2007 7:24:02 AM Hi, I have just installed a default instance of SQL server 2000 and can
connect ok with Query Analyser. I can connect ok with ODBC via a DSN if I
don't specify the port. However if I specify the port (which is 1433 I've
double checked) in the DSN or a JDBC connection it fails! Can somebody hel...more >>
ODBC Posted by Anshul Kumar at 3/28/2007 2:28:05 AM I am extracting data from SQL Server to another data form, and i have a table which is of 5 GB , when ODBC reads the table a error comes "failed to create recordset from table".
Can someone suggest what might be the reason, 1 reason i found was that the jet.temp it creates in windows has a limit ...more >>
How to decrease database connectivity time Posted by Kumar at 3/20/2007 12:00:00 AM
Hi All,
I am an VC++ programmer. I had written an VC++ application, which
will fetch data from SQL Server. I am doing DB Connectivity by creating a
DSN.
My application works perfectly. But it lacked with need some
performance issues when the DB Connectvity fails.
...more >>
Win200 ODBC to Second Instance?? Posted by bruce d at 3/19/2007 1:38:07 PM I have a Win2000 machine that connects to my SQL 2000 server just fine. The
problem is that it cannot connect to the second instance. I have changed
the client configuration setting to use the proper port, 1124, for the
second instance. Any idea as to why I cannot connect? The error is bel...more >>
ODBC Link to SQL 2005 Posted by Newbie at 3/16/2007 12:00:00 AM I am trying to link table to Access 2003 from SQL 2005
Some tables come across ok but others just have the word deleted in all the
fields
Any ideas?
...more >>
64 Bit MSDASQL Posted by wg at 3/13/2007 8:26:51 AM Hi All,
It has been stated that Microsoft will "not" provide a 64 bit version of
MSDASQL...but I have found a response from the MDAC Team stating otherwise
(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1239339&SiteID=1).
When will this be available (dates please)?? We are migrating...more >>
Smart join when working with UNION Posted by Jorgen [DK/2200] at 3/5/2007 12:00:00 AM Hi,
a have a query, which used UNION to collect data from 70 identical tables.
My problem is now that I need to join these data against another table with
a join. Is there a smart way of doing this ??
I want to avoid adding the join code for each of my 70 unions.
regards
jorgen
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
need help about call sp sql server in vb.net Posted by jorge at 3/4/2007 11:51:47 AM need help about call sp sql server in vb.net
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com...more >>
Access Violation in SQL Server Native Client Posted by Dieter Pelz at 3/2/2007 5:05:14 PM Hi,
has anybody found a similar Error or could this verified?
When I run the following Statement:
insert into FACFG_SML_IDX
(FACFG_SML_IDX.WERK_ID,FACFG_SML_IDX.SML_ID,FACFG_SML_IDX.LAST_INDEX) values
(?,?,0)
I got an access violation here is the German error message:
"Es wurde vers...more >>
How do I bind a NULL string with SQLBindParameter? Posted by ()z at 3/2/2007 9:36:25 AM I have a routine that binds a string to a query. It is passed a
string and a length or NULL and 0. It works find for non-null strings
but I cant get the handling of NULL to work.
void bindString(struct _query *Q, int i, void *data, size_t len) {
LOG("BIND STRING PARAM %d ADDR %lx LEN %d\n",...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |