help,a difficult text how to sql table code ?
Sat, 5 Apr 2008 15:32:51 -0700
help,a difficult text how to sql table code ?
i have a text as follow, line with ¡°|¡±and {LF},
8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|
i want to sign char(1)£¬ ...
|
miising oracle odbc data provider
Thu, 03 Apr 2008 09:07:40 -0700
Hi Gurus,
This is a question that I may have asked in the past on another forum I
think it was not the right forum well here goes... I have an instance of
sqlserver2005 64 bit and I need to be able to link it to an oracle 11g
server for the transfer of data
in all of the other instances there is an oracle l ...
|
Select "count" result on ONE line
Wed, 2 Apr 2008 11:21:00 -0700
I'm doing a "select count(*) from table_name" via ODBC. How can I get the
answer to be displayed in ONE line?
ex. select count(*) total_count from table_name
total_count
22
I need that "22" on the same line as the literal "total_count".
How can I do that? Thanks in advance! ...
|
ODBC error code 126 Setting up a System DSN
Wed, 2 Apr 2008 14:28:02 +0100
Can anyone help?
I am trying to setup a system DSN (on SQL2K SP4) to setup a linked server to
a Domino backend.
I am trying to setup the SQLNotes ODBC as a System DSN but I get the error
message:
Microsoft ODBC Administrator
'The setup routines for the
Lotus NotesSQL Driver (*.nsf) ODBC driver could not ...
|
Error History?
Wed, 02 Apr 2008 04:45:28 GMT
Is there a place where SQL Server logs errors? When I run my Access MDB
against a SQL 7 back end, I get ODBC errors, which are sometimes a little
descriptive, sometimes not at all. I usually have to execute code directly
against the back end to find out what's really going on. And that's if I'm
able to repro ...
|
Linked Server ... Can I use a File DSN?
Tue, 1 Apr 2008 12:23:46 +0100
Linked Server File DSN?
Can anyone help? I am trying to connect a Domino Server with the NotesSQL
ODBC.
I was unable to set the ODBC up as a System DSN ('The setup routines for the
Lotus NotesSQL Driver (*.nsf) ODBC driver could not be loaded due to system
error
code 126') and had to set it up as a file DSN ...
|
Access my profile Details in
Fri, 28 Mar 2008 12:29:50 -0700 (PDT)
Access my profile Details in:
http://al-bernardes.sites.uol.com.br/
http://www.linkedin.com/in/andrebernardes
http://andrebernardes.myplaxo.com/
André Luiz Bernardes ...
|
|
|
Connection to SQL Server failed using Excel 2007
Thu, 27 Mar 2008 11:09:01 -0700
We have Excel 2007 spreadsheets that are connected to Queries in Access 2007,
in turn the Queries in Access have link tables to an SQL Server. The SQL
Server requires the user to login with a user-id and password. In previous
versions of Access and Excel, this was not an issue, the login screen would
popup w ...
|
All TCPIP Connections No Longer Connect
Thu, 27 Mar 2008 08:16:43 -0500
There are a lot of variables in this mess, so it may not be that easy to
explain.
Basically, all my ODBC connections to SQL2K5 which have been in place and
working for more than a year suddenly no longer work. If I switch the local
machines' connections to Named Pipes, they work. My remote machines which ...
|
ODBC DSN created via script is not visible in "ODBC Datasource Administrator"
Wed, 26 Mar 2008 18:23:38 +0200
Hi,
I have used script, specified below, to add ODBS DSN
After I executed this script, the DSN was created and my application
used it, BUT - this DSN was not visible in "ODBC Datasource
Administrator". Furthermore , now if I add another DSN via "ODBC
Datasource Administrator", I can not see it there. It wo ...
|
