MSDAC OLEDB x64 drivers
Sat, 12 Apr 2008 12:39:00 -0700
Has anyone installed the new x64 drives for MS MSDAC OLEDB support? I dont
have a x64 dev server and didnt want to just run it on a prod system. Just
curious how its working or if anyone installed it yet.
--
Stan ...
|
Import help
Thu, 10 Apr 2008 08:36:48 -0400
We recently purchased a new SQL 2005 server that I need to import a DB from
another server. in order to connect to the "other" server I have to use a
3rd party thoroughbred odbc driver. On our old SQL2000 box to perform this
task I would select import and next to data source I could select the
thoroughbred d ...
|
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 ...
|
